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)