Senior Oracle Fusion Data Warehouse Engineer Staff Connect Information Technology Consultants

Posted on 9 Mar

Experience

5 - 10 Years

Job Location

Dubai - United Arab Emirates (UAE)

Education

Any Graduation

Nationality

Any Nationality

Gender

Any

Vacancy

1 Vacancy

Job Description

Roles & Responsibilities

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.

Desired Candidate Profile

  • 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

Employment Type

    Full Time

Company Industry

Department / Functional Area

Keywords

  • BICC Data Extraction
  • Business Intelligence
  • Oracle Fusion Cloud
  • Data Warehouse Architect
  • Database Engineer
  • Oracle Data Integrator ODI
  • Data Systems Engineer
  • SQL
  • Oracle Fusion Public View Objects
  • OTBI And BI Publisher

Disclaimer: Naukrigulf.com is only a platform to bring jobseekers & employers together. Applicants are advised to research the bonafides of the prospective employer independently. We do NOT endorse any requests for money payments and strictly advice against sharing personal or bank related information. We also recommend you visit Security Advice for more information. If you suspect any fraud or malpractice, email us at abuse@naukrigulf.com

Staff Connect Information Technology Consultants

Staff Connect is one of the most reputable recruitment companies in the UAE. We are a rapidly growing recruiting service that is run by a dedicated staff of highly skilled and experienced recruitment experts. We have extensive experience working with the most prestigious companies all over the world to provide them permanent and reliable recruitment solutions. We strive to become the most trusted and reputable recruitment, talent acquisition, andoutsourcing service in the UAE as well as on an international scale. We employ a top-quality professional, strategic and consultative approach that assists our clients to findthe right talent that will take their business to the higher levels. Working tirelessly and smoothly connecting candidates to their dream jobs with just the click of a button. Staff Connect aims to bridge the gap between recruiters and jobseekers.

Read More

Chandni - recruiter

AL Jahra Building 703, Khalid Bin Al Waleed Road, DUBAI, Dubai, United Arab Emirates, 233468, Dubai, United Arab Emirates (UAE)

Similar Jobs

Data Analyst

Data Analyst

Data Analyst

Data Engineer & Senior Data engineer (immediate to 30 days NP)banking

Data Analyst- Transformation & Performance Management

Ayedh Hasain A Abndajem

  • 5 - 10 Years
  • Dubai - United Arab Emirates (UAE)
View All