Job Description :
Version : 12.2.6
Senior Oracle BI & ODI Consultant (5+ Years) – Onsite
Location: Singapore
Role Summary:
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).
Interested candidates can share their resumes to [Confidential Information] / +91 9566054227
