Senior Oracle Fusion Data Warehouse Engineer
Job Fit Check
Base Career helps you apply smarter for this job.
Key skills for this role
About the Role
Design and document BICC extraction framework, optimize data performance, validate data using OTBI, and require expertise in Oracle Fusion and SQL.
Key Skills for This Role
Full Job Posting
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 And Power Bi Team
for integration readiness.
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 Information Technology Consultants
Operations Manager- Equity/ Stock/ Capital market
Abu Dhabi, UAE
Financial Operations Ensure integrity of financial operations of the business. Will undertake the auctioning and processing of transaction between accounts. Produce reports, ver...
ERP Next and SAP Consultant
Dubai, UAE
Job Summary We are looking for a Support Engineer – ERPNext & SAP to support and manage integrations between ERPNext and SAP. The role involves resolving integration issues, sup...
Maintenance Supervisor
Dubai, UAE
The Maintenance Supervisor is responsible for overseeing the maintenance, upkeep, and operational performance of the owner's private villas, offices, and commercial property in ...
ITSM Manager
Dubai, UAE
Manage IT service operations, incident and change management, ensuring ITIL compliance and continuous improvement while leading a professional team.
Group HR Manager
Abu Dhabi, UAE
Core Duties & KPIs HR Department Leadership & Supervision Supervise and control all activities of the HR department Assign tasks, set priorities, and monitor performance of HR t...
Oracle Fusion Solutions Architect
Dubai, UAE
Job Title: Oracle Fusion Enterprise Solutions Architect Location: Dubai, UAE (On-site) Leadership Opportunity We are looking for accomplished Oracle transformation leaders for t...
Site Manager
Abu Dhabi, UAE
Staff Connect is seeking a Senior Site Manager for water treatment and infrastructure projects in Abu Dhabi. The role involves managing site operations, coordinating resources, ensuring compliance with quality and safety
Water Treatment Engineer
Abu Dhabi, UAE
Staff Connect is seeking a Site Manager for water treatment and infrastructure projects in Abu Dhabi. The role involves planning, executing, and supervising site operations, managing teams, ensuring compliance with quali
Operations Manager- Equity/ Stock/ Capital market
Abu Dhabi, UAE
ERP Next and SAP Consultant
Dubai, UAE
Maintenance Supervisor
Dubai, UAE
ITSM Manager
Dubai, UAE
Group HR Manager
Abu Dhabi, UAE
Oracle Fusion Solutions Architect
Dubai, UAE
Site Manager
Abu Dhabi, UAE
Water Treatment Engineer
Abu Dhabi, UAE