Data Integration Developer

About the Role

CloudAI Technologies is seeking an experienced Data Integration Developer with strong expertise in Informatica Intelligent Cloud Services (IICS) and enterprise ETL/ELT development.

This role will be responsible for designing, developing, testing, deploying, and supporting enterprise data integration solutions connecting cloud applications, databases, APIs, data warehouses, and data platforms.

Key Responsibilities

• Design, develop, test, and deploy enterprise ETL/ELT and data integration workflows.
• Build integrations using Informatica IICS / Informatica Intelligent Data Management Cloud (IDMC).
• Develop mappings, mapping tasks, taskflows, transformations, and reusable integration components.
• Integrate data across relational databases, cloud data warehouses, SaaS applications, APIs, files, and cloud storage.
• Design incremental loads, CDC processes, full-load strategies, error handling, restart/recovery mechanisms, and reconciliation processes.
• Develop complex transformations and business rules using Informatica and SQL.
• Perform performance tuning and optimization of mappings and integration jobs.
• Implement data validation, quality checks, audit controls, logging, and operational monitoring.
• Troubleshoot failed jobs, data discrepancies, connectivity issues, and production incidents.
• Develop technical specifications, source-to-target mappings, deployment documentation, and operational procedures.
• Participate in code reviews, testing, release management, and production deployments.
• Collaborate with data architects, DBAs, application teams, business analysts, and client stakeholders.

Required Qualifications

• Minimum 5 years of professional data integration/ETL experience.
• Strong hands-on experience with Informatica IICS/IDMC.
• Strong understanding of ETL and ELT architecture and design patterns.
• Advanced SQL skills.
• Experience integrating multiple databases, APIs, files, and cloud/SaaS systems.
• Experience with enterprise data warehouses and data migration/integration projects.
• Knowledge of data quality, reconciliation, error handling, and production support.
• Experience working with Git/version control and structured SDLC processes.
• Strong debugging and problem-solving skills.

Preferred Qualifications

Experience with Snowflake, Databricks, AWS, Azure, Oracle, SQL Server, PostgreSQL, REST APIs, CDC, cloud data migration, and Python is desirable.