SENIOR ORACLE FUSION DATAWAREHOUSE ENGINEER

Duncan & Ross View all jobs

  • Dubai
  • Temporary
  • Full-time
  • 1 month ago
  • Apply easily
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.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.
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.
Preferred Experience
  • Experience in ERP Migrations (specifically AX to Oracle)
VerticalTechnology

Duncan & Ross