Data Warehouse Engineer
About This 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, which will later integrate with legacy Microsoft Dynamics AX data within an on-premises Microsoft SQL Server environment.
Key Responsibilities: -
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
Similar Jobs
Data Warehouse Consultant
RiDiK (a Subsidiary of CLPS. Nasdaq: CLPS) · Jeddah
**Role:** Data Warehouse Consultant **Company:** RiDiK Pte Ltd **Exp:** 10\+ Years **Location:** Jeddah, Saudi Arabia **Job Summary** We are seeking an experienced **Data Warehouse Consultant** responsible for designing,
4 days ago
Generate Resume ↗Data Warehouse Consultant
AIQU · Abu Dhabi Emirate
We are hiring for Senior Data warehouse Consultant to join one of our clients based out of UAE. **Job Details:** **Role:** Senior Data warehouse Consultant **Work Location:** Abu Dhabi, UAE **Employment Type** \- Contrac
1 weeks ago
Generate Resume ↗Project Manager (ETL & Data Warehouse)
Energy Job Search · Riyadh
KalSoft is currently looking for an experienced **Project Manager** with strong expertise in **ETL and Data Warehouse solutions** to join our team. This role is ideal for professionals who have a solid background in deli
1 months ago
Generate Resume ↗Project Manager (ETL & Data Warehouse)
KALSOFT ·
KalSoft is currently looking for an experienced **Project Manager** with strong expertise in **ETL and Data Warehouse solutions** to join our team. This role is ideal for professionals who have a solid background in deli
1 months ago
Generate Resume ↗Project Manager (ETL & Data Warehouse)
Kalsoft · الرياض
KalSoft is currently looking for an experienced **Project Manager** with strong expertise in **ETL and Data Warehouse solutions** to join our team. This role is ideal for professionals who have a solid background in deli
1 months ago
Generate Resume ↗Stop applying blindly.
Start getting hired.
Base Career automates the hardest parts of job searching — apply smarter, not harder.
AI Resume in 60s
Your resume rewritten for this exact role using the job description as the brief.
ATS-Optimized
Get past automated screening filters with the right keywords matched to each job.
Application Tracker
Track every job, follow-up, and interview in one visual kanban board.
Free plan · No credit card required