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)