Senior Specialist Informatica Cloud Data Engineering

Neostats Analytics Solutions; Dubai; On-site; AED 300,000 - 540,000; Full time

Job summary

Neostats Analytics Solutions in the UAE seeks an experienced data integration specialist to design, configure, and deliver Informatica Cloud workflows, build ETL/ELT pipelines, and ensure data quality and governance across enterprise data. The role requires 6+ years in data integration, hands-on Informatica Cloud and ID Management Cloud, plus CDP/CDGC and strong SQL.

You will collaborate with source owners, document lineage, and support client deployments on site in Abu Dhabi for the contract

Qualifications

• 6+ years of experience in data integration or related delivery roles.
• Hands-on with Informatica Cloud / IDC management.
• Experience with data profiling, metadata management, lineage, governance workflows.
• Experience building mappings, workflows, schedules, error handling, and monitoring.

Responsibilities

• Design, configure, and deliver data integration workflows using Informatica Cloud.
• Build and support ETL/ELT pipelines for sourcing, transforming, validating, and loading data.
• Use Informatica CDP/CDGC for data profiling, metadata management, and data discovery.
• Collaborate with source system owners on data structures and extraction requirements.
• Ensure pipelines meet governance, metadata, and lineage requirements.
• Implement data validation and quality checks within workflows.
• Troubleshoot data load failures and performance bottlenecks.
• Document mappings, workflows, and operational procedures.
• Handover to client teams with runbooks and production guidance.

Skills

Informatica Cloud

ETL/ELT development

Data integration patterns

SQL

Data governance

Troubleshooting

Documentation

Client-facing delivery

Tools

Informatica Cloud

Informatica CDP/CDGC

Microsoft Azure

Job description

Role & responsibilities

• Design, configure, and deliver data integration workflows using Informatica Cloud.
• Build, enhance, and support ETL/ELT pipelines for sourcing, transforming, validating, and loading enterprise data.
• Use Informatica CDP/CDGC to support data profiling, metadata management, cataloging, lineage, governance workflows, and data discovery.
• Work with source system owners to understand data structures, extraction requirements, connectivity, metadata, lineage, and refresh schedules.
• Ensure data pipelines are set up correctly, tested thoroughly, and aligned with business, governance, and technical requirements.
• Implement data validation, reconciliation, profiling, and quality checks within integration and data management workflows.
• Troubleshoot data load failures, mapping issues, performance bottlenecks, connectivity errors, data transformation defects, and metadata/cataloging issues.
• Support data ingestion from cloud, on-premise, database, file-based, and API-based sources where required.
• Collaborate with data governance and data quality teams to ensure integration logic supports agreed business rules, controls, metadata standards, and lineage requirements.
• Document mappings, workflows, data lineage, metadata, dependencies, technical designs, operational procedures, and known issues.
• Support handover to client teams, including knowledge transfer, runbooks, production support guidance, and Informatica configuration documentation.

Preferred candidate profile

• 6+ years of experience in data integration, data engineering, ETL/ELT development, or related technical delivery roles.
• Strong hands‑on experience with Informatica Cloud / Informatica Intelligent Data Management Cloud.
• Strong hands‑on experience with Informatica CDP/CDGC.
• Experience using Informatica capabilities for data profiling, cataloging, metadata management, lineage, governance workflows, and data discovery.
• Experience building mappings, workflows, tasks, schedules, parameterization, error handling, and monitoring processes.
• Strong understanding of data integration patterns, transformation logic, incremental loads, full loads, data validation, and reconciliation.
• Good SQL skills and experience working with relational databases and enterprise data platforms.
• Experience integrating data from multiple source systems, including databases, flat files, cloud applications, APIs, or enterprise systems.
• Ability to troubleshoot data pipeline failures, performance issues, data quality defects, and metadata/cataloging issues.
• Understanding of data quality, metadata, lineage, and governance requirements in data engineering delivery.
• Strong documentation and communication skills.
• Ability to work from a client office in Abu Dhabi for the full contract duration.
• Consulting or client‑facing delivery experience is strongly preferred.

Preferred Qualifications

• Experience with Microsoft Azure data services, cloud data platforms, or modern lakehouse architectures.
• Experience with broader Informatica Cloud capabilities, including Cloud Data Integration, Cloud Data Quality, Cloud Application Integration, Cloud Data Governance and Catalog, and related modules.
• Exposure to data warehousing, data lakes, BI, analytics, or AI/ML data preparation use cases.
• Experience working in regulated or enterprise environments such as banking, financial services, government, telecom, retail, or large‑scale operations.
• Informatica, Azure, data engineering, data governance, or cloud certifications are preferred.