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.

• SQLPreferred

Identified from the job description. Confirm important requirements above.

• 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

Minimum experience

5+ years

Apply by

Sep 19, 2026

Posting language

English

Working hours

40 hours per week

Seniority

Mid-Senior level

Application method

Direct apply is available