Data Warehouse Engineer
Job Fit Check
Base Career helps you apply smarter for this job.
Key skills for this role
About the 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,
Key Skills for This Role
Full Job Posting
Overview
Job Title: Senior Oracle Fusion Data Warehouse Engineer
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.
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
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Staff Connect UAE
Quality Assurance Tester
Dubai, UAE
Job Title: Integration & ERP Quality Assurance Tester Location: Dubai Role Summary We are hiring experienced QA testers to support integration and end-to-end testing across Oracle Fusion ERP, OIC integrations, WMS, CRM,
Network Engineer
Abu Dhabi Emirate, UAE
Network Engineer to design, implement, maintain, and troubleshoot enterprise network infrastructure, support Cyber Security (if required). The ideal candidate will have hands-on experience with switches, routers, firewal
Oracle Application Technical Consultant
Ajman Emirate, UAE
To design, implement, test and document Oracle Applications with respect to new requirements and maintain the existing. JOB RESPONSIBLITIES : Design, implement, test and document Oracle Applications development to agree
Senior Information Technology Support Engineer
Abu Dhabi Emirate, UAE
Job Summary We are seeking experienced L3 IT Support Engineers to provide advanced technical support across infrastructure, applications, and network environments. The role focuses on complex issue resolution, root cause
IT Service Operations Manager
Dubai, UAE
The Manager, IT Service Operations owns the operational backbone of the Infrastructure & Cybersecurity function. This role leads service desk operations, incident management, change management, monitoring, and field supp
Site Project Manager
Abu Dhabi Emirate, UAE
Job Title: Site Manager Location: Abu Dhabi, UAE. Job Summary The Site Manager is responsible for the overall planning, execution, supervision, and successful delivery of water treatment and infrastructure projects. The
Work Preparator
Dubai, UAE
We are seeking a detail-oriented Work Preparator to support maintenance and project activities through the preparation of work packages, technical documentation, and material requirements. The ideal candidate will have s
Structural Drafter
Dubai, UAE
We are seeking a skilled Structural Draftsman to prepare detailed structural drawings for RCC and steel structure projects. The ideal candidate will have strong experience in structural drafting, rebar detailing, shop dr
Quality Assurance Tester
Dubai, UAE
Network Engineer
Abu Dhabi Emirate, UAE
Oracle Application Technical Consultant
Ajman Emirate, UAE
Senior Information Technology Support Engineer
Abu Dhabi Emirate, UAE
IT Service Operations Manager
Dubai, UAE
Site Project Manager
Abu Dhabi Emirate, UAE
Work Preparator
Dubai, UAE
Structural Drafter
Dubai, UAE