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
Staff Connect UAE is hiring experienced QA testers for integration and end-to-end testing across Oracle Fusion ERP, OIC, WMS, CRM, and EDI. The role involves structured test execution, defect logging, and validation of c
Network Engineer
Abu Dhabi Emirate, UAE
Staff Connect UAE seeks a Network Engineer to design, implement, maintain, and troubleshoot enterprise network infrastructure. The role involves hands-on work with Cisco and Huawei equipment, firewalls, SD-WAN, and cyber
Oracle Application Technical Consultant
Ajman Emirate, UAE
Staff Connect UAE is looking for an Oracle Application Technical Consultant with at least 5 years of experience in Oracle Applications (Release 12). The role involves designing, implementing, testing, and documenting Ora
Senior Information Technology Support Engineer
Abu Dhabi Emirate, UAE
Staff Connect UAE is seeking an experienced L3 IT Support Engineer to provide advanced technical support across infrastructure, applications, and network environments in Abu Dhabi. The role requires 6+ years of experienc
IT Service Operations Manager
Dubai, UAE
Staff Connect UAE is seeking an IT Service Operations Manager to own the operational backbone of the Infrastructure & Cybersecurity function. The role leads service desk operations, incident management, change management
Site Project Manager
Abu Dhabi Emirate, UAE
Staff Connect UAE is hiring a Site Manager for water treatment and infrastructure projects in Abu Dhabi. The role involves planning, execution, supervision, and delivery of projects, managing site operations, coordinatin
Structural Drafter
Dubai, UAE
Staff Connect UAE is seeking a skilled Structural Draftsman to prepare detailed structural drawings for RCC and steel structure projects. The role requires 3+ years of experience, proficiency in AutoCAD, and strong knowl
Work Preparator
Dubai, UAE
Staff Connect UAE is seeking a detail-oriented Work Preparator to support maintenance and project activities in Dubai. You will prepare work packages, interpret engineering drawings, and coordinate with teams. Requires a
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
Structural Drafter
Dubai, UAE
Work Preparator
Dubai, UAE