Senior Specialist Informatica Cloud Data Engineering

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.