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

Robust experience with Oracle Analytics Cloud (OAC).

Strong hands-on experience with Oracle Data Integrator (ODI).

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

📌 Senior OAC / ODI Data Warehouse (Ontario)
🏢 Prophecy Technologies
📍 Ontario