Senior Oracle Fusion Datawarehouse Engineer (BICC & PVO Specialist) - 6 months extendable contract

Transguard Workforce Solutions is the UAE's leading provider of unique and innovative HR solutions. With a decade of experience in the region and a team that possesses extensive knowledge of the market, we provide a fully integrated HR solution.

We are currently recruiting for an Senior Oracle Fusion Datawarehouse Engineer (BICC & PVO Specialist) for our client to be based out of their Dubai office.

Role Summary

We are hiring a senior expert to own the data extraction strategy from Oracle Fusion Cloud into Oracle Autonomous Data Warehouse (ADW). Responsible for modelling and validating extracted Fusion ERP data using BICC and PVOs, establishing the bronze staging layer that will eventually integrate with our legacy MS Dynamics AX data in an on-premises MSSQL environment.

Must-Have Expertise

• BICC Extraction: Mastery of full/incremental load strategies and high-volume data handling.
• PVO (Public View Objects): Deep understanding of PVO relationships, joins, and source-of-truth logic.
• Fusion ERP Data Model: Technical knowledge of transactional (Sales/Finance) and master data structures.
• Oracle ADW & OCI: Schema design, performance tuning, and cloud data staging.
• Validation: Using OTBI and BI Publisher for data reconciliation and integrity checks.
• Advanced SQL: Expert-level Oracle SQL for complex data modelling.

Key Responsibilities

• Design & Document: Architect and develop the end-to-end BICC extraction and ADW staging flow.
• Model & Join: Construct the Bronze layer by joining raw PVOs into usable structures.
• Validate: Ensure extracted data matches the Fusion UI using OTBI/BI Publisher.
• Optimize: Manage ADW performance and OCI resource efficiency.
• Handoff: Deliver clear source to destination mapping documentation (Primary Keys, Join Logic, and PVO lineages) for the downstream MSSQL/Power BI team.

Preferred Experience

Experience in ERP Migrations (specifically AX to Oracle)