Senior OAC / ODI Data Warehouse

We are looking for an OAC / ODI Data Warehouse Consultant with strong experience in Oracle Analytics Cloud (OAC), Oracle Data Integrator (ODI), and Data Warehousing. The consultant will be responsible for developing data integration processes, data models, ETL/ELT workflows, and analytics solutions. Key Responsibilities Develop and maintain ODI mappings, packages, procedures, and workflows. Design and implement Data Warehouse solutions using Oracle technologies. Develop dashboards, reports, and data models using Oracle Analytics Cloud (OAC). Build and optimize ETL/ELT pipelines using ODI. Work with Oracle databases, SQL, PL/SQL, and data warehouse schemas. Perform data extraction, transformation, loading, and validation. Analyze and troubleshoot data integration and reporting issues. Optimize SQL queries, ODI workflows, and OAC reports for performance. Work with business and technical teams to understand reporting and data requirements. Support data migration, testing, deployment, and production issues. Required Skills Strong experience with Oracle Analytics Cloud (OAC). Strong hands-on experience with Oracle Data Integrator (ODI). Strong Data Warehouse / DW development experience. Excellent SQL and PL/SQL skills. Experience with ETL/ELT concepts and data integration. Good understanding of Dimensional Modeling, Star Schema, and Fact/Dimension tables. Experience with Oracle Database and data warehouse environments. Strong troubleshooting and analytical skills.

The consultant will develop and maintain ODI mappings, workflows, and ETL/ELT pipelines to support data warehouse solutions. They will also design dashboards and reports using Oracle Analytics Cloud (OAC) to meet business requirements.

Candidates must have strong hands-on experience with OAC, ODI, and data warehouse development. Proficiency in SQL, PL/SQL, and dimensional modeling is essential.

• SQLSouhaitée

Relevées dans la description du poste. Confirmez les exigences importantes ci-dessus.

• Oracle Analytics Cloud (OAC)
• Oracle Data Integrator (ODI)
• Data Warehousing
• SQL
• PL/SQL
• ETL/ELT
• Dimensional Modeling
• Star Schema
• Oracle Database
• Data Integration

• Data & Analytics
• Technology
• Software
• Consulting
• Engineering

Expérience minimale

5+ ans

Postuler avant le

19 sept. 2026

Langue de l’offre

anglais

Heures de travail

40 heures par semaine

Niveau d’expérience

Mid-Senior level

Mode de candidature

La candidature directe est offerte