SENIOR ORACLE FUSION DATAWAREHOUSE ENGINEER BICC & PVO SPECIALIST DUNCAN AND ROSS MANAGEMENT CONSULTANCIES

Posted on 12 Mar

Experience

3 - 6 Years

Job Location

Dubai - United Arab Emirates (UAE)

Education

Masters in Computer Application(Computers), Master of Technology/Engineering(Computers)

Nationality

Any Nationality

Gender

Any

Vacancy

1 Vacancy

Job Description

Roles & 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.

Desired Candidate Profile

  • 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)

Employment Type

    Full Time

Company Industry

Department / Functional Area

Keywords

  • Business Intelligence
  • Fusion Analytics Specialist
  • Oracle Fusion BI Consultant
  • PVO
  • Data Warehouse Lead
  • Oracle Fusion
  • Oracle Fusion Data Warehouse Architect
  • Performance Tuning

DUNCAN AND ROSS MANAGEMENT CONSULTANCIES

Duncan & Ross Engineering & Technology offers integrated and customer oriented services in the different industries such as Energy, Utilities, Oil & Gas, Construction, Healthcare & Life Sciences, Banking & Finance, Technology, Media & Telecommunications, Aerospace & Defense, Transport & Railway. We support our clients with Engineering Services onsite and offsite and Technology Services (Cloud & Security, Applications, Data & Analytics). Duncan & Ross can draw on its worldwide network of human capital, engineering consulting and quality oriented solutions. Our customers will profit from these synergies that play an important role in the processing of our projects.

Read More

Fabien Claeys - Operations Director

Ubora Business Tower Level 705 Post Code: 5002353 Dubai Knowledge Village, Dubai, United Arab Emirates (UAE)