System Programmer

Senior Oracle BI & ODI Consultant (5–6 Years) We are seeking a seasoned Oracle BI & ODI Consultant to lead the end-to-end delivery of Business Intelligence solutions. This role requires a technical expert capable of designing complex ETL pipelines in Oracle Data Integrator (ODI) and architecting robust reporting layers in OBIEE/OAC. Key Responsibilities: ETL/ELT Development (ODI) Design and maintain high-performance data integration processes using ODI 12c. Build and customize Knowledge Modules (KMs) and manage complex Load Plans. BI Architecture (OBIEE/OAC) Architect and optimize the Metadata Repository (RPD) across all three layers (Physical, BMM, and Presentation). Reporting & Visualization Develop advanced dashboards, interactive reports, and pixel-perfect templates using BI Publisher. Migration & Cloud Lead or support migrations from on-premise OBIEE to Oracle Analytics Cloud (OAC) or Oracle Analytics Server (OAS). Performance Tuning Diagnose and resolve bottlenecks in SQL queries, RPD joins, and ETL mappings to ensure low-latency reporting. Required Technical Skills: Core Tools ODI (11g/12c) OBIEE (12c) Oracle Analytics Cloud (OAC) Languages: Expert-level SQL and PL/SQL (Stored Procedures, Packages, Triggers) Data Modeling: Strong understanding of Star/Snowflake schemas and Dimensional Modeling (SCD Type I/II) Database : Deep knowledge of Oracle 12c/19c and Autonomous Data Warehouse (ADW)