Data Integration Specialist: ETL, APIs & Oracle SQL

TalentOne; Dubai; On-site; AED 180,000 - 300,000; Full time

Benefits offered by this job

REST/SOAP services

Apache Airflow

dbt

Python

Shell scripting

Power BI

Job summary

Talent One seeks a Data Integration Officer to develop, monitor, and support reliable data interfaces across enterprise systems. The role covers ETL workflows, databases, APIs, file-based integrations, data quality, and production issue resolution.

Responsibilities include ETL/ELT development, data integration from Oracle databases, and production support with strong emphasis on data quality and documentation.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Software Engineering, or a related discipline.
• Minimum 4 years of experience in data integration, ETL development, or application integration.
• Hands-on experience with Informatica PowerCenter workflows, mappings, sessions, and production support.
• Strong Oracle SQL and PL/SQL skills, including query optimisation and troubleshooting.
• Experience with APIs, JSON or XML, SFTP, flat files, batch processing, and incremental data loads.
• Knowledge of data quality, reconciliation, job scheduling, version control, and incident management.
• Strong documentation, problem-solving, communication, and stakeholder coordination skills.

Responsibilities

• Develop, test, deploy, and support ETL and ELT workflows using Informatica PowerCenter and SQL.
• Integrate data from Oracle databases, enterprise applications, APIs, SFTP, and flat files.
• Prepare source-to-target mappings, transformation rules, interface specifications, and support documentation.
• Monitor scheduled jobs, investigate failures, perform root-cause analysis, and restore services promptly.
• Apply data validation, reconciliation, logging, error-handling, and audit controls.
• Support production releases, data corrections, change requests, and user acceptance testing.
• Maintain interface inventories, data lineage, operational procedures, and incident records.
• Coordinate with data engineers, application teams, vendors, analysts, and business users.

Education

Bachelor's degree in Computer Science, Information Systems, Software Engineering, or a related discipline

Tools

Informatica PowerCenter

Oracle SQL/PLSQL

Job description

Talent One seeks a Data Integration Officer to develop, monitor, and support reliable data interfaces across enterprise systems. The role covers ETL workflows, databases, APIs, file-based integrations, data quality, and production issue resolution.

Responsibilities include ETL/ELT development, data integration from Oracle databases, and production support with strong emphasis on data quality and documentation.