Senior Oracle BI & ODI Consultant

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).