Data Integration Developer

CloudAI Technologies; Hyderabad; Hybrid; INR 1,200,000 - 1,800,000; Full time

Job summary

CloudAI Technologies is seeking an experienced Data Integration Developer to design, develop, test, deploy, and support enterprise data integration solutions connecting cloud applications, databases, APIs, data warehouses, and data platforms. The role emphasizes Informatica IICS/IDMC expertise and hands-on ETL/ELT development in an enterprise setting.

The ideal candidate will design incremental loads, CDC processes, and robust error handling, while collaborating with architects, DBAs, and

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.

Responsibilities

• Design, develop, test, and deploy enterprise ETL/ELT and data integration workflows.
• Build integrations using Informatica IICS / 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.

Skills

Informatica IICS/IDMC

ETL/ELT architecture

SQL

Git/version control

SDLC

Debugging

Problem solving

Tools

Snowflake

Databricks

AWS

Azure

Oracle

SQL Server

PostgreSQL

REST APIs

CDC

Python

Job description

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.