An AI agent that applies to roles like this on employers' own sites. 25 applications free, no card needed.
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 EngineerSqlIf 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 allLooking for something similar?
New Data Science Analytics & Machine Learning roles in United Arab Emirates.
One email a day. Unsubscribe any time.

