Data Warehouse Engineer

About This Role

Job Title: Senior Oracle Fusion Data Warehouse Engineer

Work Location: Dubai

Role Summary: -

We are seeking a Senior Oracle Fusion Data Warehouse Engineer with strong expertise in BICC and PVO extraction to design and implement data extraction strategies from Oracle Fusion Cloud ERP into Oracle Autonomous Data Warehouse (ADW).

The selected candidate will be responsible for modelling and validating extracted ERP data and building the Bronze staging layer, which will later integrate with legacy Microsoft Dynamics AX data within an on-premises Microsoft SQL Server environment.

Key Responsibilities: -

1. Data Architecture & Design

• Design and document the end-to-end BICC extraction framework from Oracle Fusion to ADW.
• Define staging architecture and data pipelines within Oracle Cloud Infrastructure (OCI).

2. Data Modeling

• Build the Bronze data layer by joining and transforming raw Public View Objects (PVOs).
• Ensure correct mapping of primary keys, relationships, and join logic.

3. Data Validation

• Validate extracted data against the Oracle Fusion UI.
• Perform reconciliation using OTBI and BI Publisher reports.

4. Performance Optimization

• Optimize ADW schema design, indexing, and query performance.
• Manage OCI resources to ensure efficient data processing.

5. Documentation & Handover

• Prepare source-to-destination mapping documentation.
• Provide detailed documentation of:
• Primary Keys
• Join logic
• PVO lineage
• Data transformation rules
• Collaborate with the downstream MSSQL / Power BI team for integration readiness.

Must-Have Skills & Expertise: -

• Strong expertise in BICC data extraction (Full & Incremental loads)
• Deep understanding of Oracle Fusion Public View Objects (PVOs)
• Solid knowledge of Oracle Fusion ERP data models (Finance / Sales / Master Data)
• Hands-on experience with Oracle ADW and OCI environments
• Strong validation experience using OTBI and BI Publisher
• Advanced Oracle SQL for complex joins and data transformations
• Experience handling large-volume enterprise ERP datasets

Preferred Experience: -

• Experience with ERP Migration or Transformation Projects
• Exposure to Microsoft Dynamics AX to Oracle Fusion Cloud ERP migration
• Experience working with enterprise data warehouse and BI environments such as Microsoft Power BI