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
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, ch...
Senior Infrastructure Engineer
Jeddah, KSA
Manage infrastructure planning, design governance, and contractor compliance while ensuring cost optimization and risk management for site-wide systems.
Senior Architect
Jeddah, KSA
Lead architectural design governance and master planning for large-scale projects, ensuring alignment with business objectives and operational requirements.
SAP Case Management
Ras Al Khaimah, UAE
Responsible for implementing and supporting SAP Case Management, requiring strong business process understanding, configuration skills, and integration awareness with third-part...
Airport Civil Design Engineer Specialist
Ras Al Khaimah, UAE
Develop civil designs for airport infrastructure, prepare technical specifications, and ensure compliance with regulations using AutoCAD and Civil 3D.
Junior Business Analyst
Abu Dhabi, UAE
Assist in gathering business requirements, support user acceptance testing, and analyze data using tools like JIRA and SQL for operational efficiency.
Gym Membership Sales Consultant
Dubai, UAE
Promote and sell gym memberships, generate leads, achieve sales targets, and maintain client relationships with strong communication and negotiation skills.
L3 Engineer
Abu Dhabi, UAE
Provide advanced technical support, perform troubleshooting, manage Active Directory, and support Microsoft Office 365 while ensuring high availability.
IT Service Operations Manager
Dubai, UAE
Senior Infrastructure Engineer
Jeddah, KSA
Senior Architect
Jeddah, KSA
SAP Case Management
Ras Al Khaimah, UAE
Airport Civil Design Engineer Specialist
Ras Al Khaimah, UAE
Junior Business Analyst
Abu Dhabi, UAE
Gym Membership Sales Consultant
Dubai, UAE
L3 Engineer
Abu Dhabi, UAE