24 Sep
|
CloudAI Technologies
|
Hyderabad
24 Sep
CloudAI Technologies
Hyderabad
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.
- Solid 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.
📌 Data Integration Developer (Hyderabad)
🏢 CloudAI Technologies
📍 Hyderabad