Oracle Data Engineer

Department Icon Data Science Analytics & Machine Learning
Posted: 4 months ago
5-7 years
United Arab Emirates
Data Science Analytics & Machine Learning
work from office
Full Time

Posted: 4 months ago
This job's closing date (2 Sep 2026) has passed, so the role may already be filled. See live similar jobs.
Let Jobaaj One apply for you

An AI agent that applies to roles like this on employers' own sites. 25 applications free, no card needed.

Job Description
About Company
Similar Jobs
Please verify your account first! Send OTP

Job Description

Job Title: Oracle Data Engineer

Contract: 6 Months

Start Date: 15th July 2026

Location: Remote

Salary: AED 13,000 per month - No other benefits

Requirements:

  • Must have your own UAE residence visa and NOC. A labour card will be issued
  • Must have valid medical insurance (not provided)
  • Must be available to work UAE hours from Monday to Friday

Working Hours

Mon – Thu: 8:00 AM – 5:30 PM

Fri: 8:00 AM – 3:30 PM

We are seeking a technical and detail-oriented Data Engineer to spearhead data extraction and warehousing initiatives. This role is highly hands-on, focusing on extracting critical Finance, Supply Chain, and Warehouse data from Oracle Fusion using DET and BICC tools, and building resilient Python-driven pipelines. If you have deep expertise in MS SQL Server, advanced SQL scripting, and structuring data using layered warehouse patterns (Bronze, Silver, Gold), this is the perfect opportunity to make a tangible impact on our core data infrastructure.

SKILLS REQUIRED

Oracle Fusion & Data Extraction

  • Hands-on experience with Oracle Fusion data extraction tools — DET (Data Extraction Tool) and BICC
  • Proficient in downloading and handling flat file extracts from Oracle UCM via SOAP (GenericSoapPort)
  • Understanding of Oracle Fusion data models across Finance, Supply Chain, and Warehouse subject areas
  • Familiarity with Oracle BICC scheduling, subject area configuration, and incremental extract patterns

Python & Pipeline Development

  • Strong Python scripting skills for file download, parsing, transformation, and data loading
  • Experience building and maintaining ETL/ELT pipelines with incremental watermark-based logic
  • Familiarity with Prefect (or equivalent orchestration tool) for job scheduling, retry handling, and alerting

SQL & Data Warehouse

  • Proficient in MS SQL Server — writing MERGE/UPSERT statements, stored procedures, and complex joins
  • Experience implementing medallion architecture (Bronze, Silver, Gold) or equivalent layered warehouse patterns
  • Comfortable applying SCD Type 2 history tracking and data quality validation logic

General

  • Ability to translate business logic and source-to-target mapping specs into working pipeline code
  • Good documentation habits — runbooks, pipeline specs, and data dictionaries

JOB RESPONSIBILITIES

Data Extraction

  • Configure and execute Oracle Fusion DET and BICC extracts across Finance, Supply Chain, and Warehouse subject areas
  • Build and maintain Python SOAP scripts to download flat file extracts from Oracle UCM to the on-premises environment
  • Manage incremental watermark logic to ensure daily loads are reliable, auditable, and recoverable

Data Warehouse Build

  • Load raw extracts into the Bronze staging layer in MS SQL Server with deduplication and audit columns
  • Apply SCD Type 2 history tracking and incremental MERGE/UPSERT logic in the Silver layer
  • Enforce data quality gates, referential integrity checks, and business rule validations in the Gold layer

Automation & Monitoring

  • Build Prefect flows for all pipeline jobs with scheduling, retry logic, failure alerting, and logging
  • Set up pipeline monitoring and produce runbooks to support offshore handover and day-to-day operations

Collaboration

  • Work closely with the BI team to receive and apply data discovery findings, business logic, and SQL join conditions
  • Participate in source-to-target mapping reviews and flag extraction gaps or data quality issues early
  • Support handover to the reporting team once Gold layer data is validated and pipeline is stable

PERSON SPECIFICATION

  • Overall Data Engineering Expertise: 5+ years of proven experience specializing in ETL/ELT development and data warehousing design.
  • Python Programming & File Handling: 3+ years of hands-on experience using Python for data transformation, parsing multiple file types (CSV, XML, JSON), and managing file downloads via SOAP/REST APIs.
  • Oracle Fusion Data Extraction: 2+ years of direct, hands-on experience configuring Oracle Fusion data extraction tools, specifically utilizing DET (Data Extraction Tool) and BICC extracts.
  • ERP Domain & Schema Mapping: Strong understanding of Oracle Fusion data models across Finance, Supply Chain, and Warehouse subject areas, alongside the ability to accurately map them to downstream schemas.
  • Advanced SQL & Warehousing Design: 4+ years of experience working with SQL Server, featuring deep knowledge of data warehouse design patterns, complex joins, stored procedures, and MERGE/UPSERT logic.
  • Modern Lakehouse Architecture: Demonstrated experience implementing and managing layered data warehouse patterns, specifically Medallion Architecture (Bronze, Silver, Gold environments).
  • Pipeline Orchestration: 1+ years of practical experience using workflow orchestration tools like Prefect (or an equivalent) to manage job scheduling, dependency tracking, retry handling, and error alerting.
  • Resilient Extract & Load Design: Proven ability to design watermark-based incremental extraction logic, ensuring daily data loads are highly reliable, auditable, and easily recoverable following a system failure.
  • API Integration & Fault Tolerance: Hands-on experience retrieving flat file extracts from Oracle UCM via SOAP (GenericSoapPort), including writing robust error-handling routines for partial or failed downloads.
  • Clean Code & Architecture Practices: Track record of writing modular, reusable, and testable pipeline code, paired with strong habits for building structured business-logic translations.

Skills

PythonData WarehousingEtlData ExtractionErpMs Sql ServerData EngineerSql

If a job posting appears fraudulent, asks for payment, contains misleading information, or violates our guidelines, please report it immediately. Our team will review it promptly, Jobaaj does not charge any fee from the applicants.

About Company

Our client is a boutique, Dubai-based luxury events company known for a cinematic, story-driven approach to celebrations. Its creative leadership has an international background in film and storytelling, and its weddings are designed to feel like stepping into a movie. The company plans high-end weddings across Indian, Arab and international traditions. It is now expanding into destination weddings, for couples marrying in Dubai and for Dubai couples marrying abroad.

Similar Jobs

View all
Loading...

Looking for something similar?

Bag Logo
Jobaaj
Get jobs like this by email

New Data Science Analytics & Machine Learning roles in United Arab Emirates.

Job Alert
Google hiring for Specific Roles Apply Now!
1 min ago
New Opportunity
Amazon is hiring freshers Apply Now!
5 min ago
Featured Jobs
Microsoft opening 50+ positions Apply Now!
10 min ago

One email a day. Unsubscribe any time.