We are looking for a Senior Informatica Developer with extensive hands-on experience in Informatica Intelligent Data Management Cloud (IDMC), enterprise data integration, and ETL/ELT development. The ideal candidate should have strong expertise in Informatica Cloud Data Integration, mappings, transformations, taskflows, reusable components, runtime configuration, performance optimization, and integration with cloud data platforms such as Snowflake. The candidate will be responsible for designing, developing, optimizing, and maintaining scalable data integration solutions that support enterprise data warehousing, reporting, analytics, and business-critical data delivery. The role requires strong technical expertise in Informatica IDMC architecture and development capabilities, SQL, data transformation, workflow orchestration, error handling, and data quality. The ideal candidate should be capable of independently delivering complex IDMC solutions, troubleshooting production issues, optimizing data pipelines, and implementing reliable integration frameworks. Experience with legacy ETL modernization and SAS-to-Informatica migration will be an added advantage.

Key Responsibilities
• Design, develop, test, deploy, and maintain enterprise data integration solutions using Informatica IDMC.
• Build complex mappings, mapping tasks, taskflows, reusable components, parameterized workflows, and standardized ETL/ELT frameworks using Informatica Cloud Data Integration.
• Implement and optimize Informatica transformations, including Expression, Filter, Joiner, Lookup, Aggregator, Router, Sorter, Rank, and other relevant transformation components.
• Design reusable integration patterns and parameter-driven frameworks to support scalable, maintainable, and consistent development.
• Configure and manage connections, Secure Agents, runtime environments, integration settings, and source/target connectivity.
• Develop taskflows and orchestration logic to manage dependencies, conditional execution, sequencing, exception handling, notifications, and recovery.




• Build data pipelines integrating Snowflake, SQL Server, Oracle, flat files, cloud storage, and other supported enterprise data sources and targets.
• Develop and optimize SQL queries, database-side transformations, and Snowflake processing to improve performance and reduce unnecessary data movement.
• Leverage pushdown optimization and appropriate ELT patterns wherever supported and beneficial to the target architecture.
• Implement incremental data loading, parameterization, batch processing, restartability, logging, audit controls, and error-handling mechanisms.
• Develop data quality checks, data cleansing rules, validation frameworks, and reconciliation processes to ensure data accuracy and completeness.
• Troubleshoot mapping failures, taskflow errors, connectivity issues, data discrepancies, and performance bottlenecks.
• Perform performance tuning across mappings, transformations, workflows, SQL queries, and data movement processes.
• Work with relevant IDMC capabilities such as Cloud Data Quality, metadata management, data lineage, and API-based integration, as required.
• Collaborate with solution architects, data engineers, business analysts, QA teams, and business stakeholders to translate requirements into technical solutions.
• Conduct unit testing, integration testing, regression testing, and source-to-target validation.
• Follow source control, code review, CI/CD, and deployment practices using Azure DevOps, Git, or equivalent tools.
• Prepare technical specifications, mapping documents, test evidence, deployment procedures, and operational support documentation.
• Support production releases,



incident resolution, knowledge transfer, and continuous improvement of data integration processes. Required Qualifications
• 7+ years of experience in Informatica development, ETL/ELT engineering, or enterprise data integration.
• Strong hands-on experience with Informatica IDMC, particularly Cloud Data Integration and associated development capabilities.
• Extensive practical experience designing and developing complex mappings, mapping tasks, taskflows, transformations, reusable components, and parameterized workflows.
• Strong knowledge of Informatica transformation components, including Expression, Filter, Joiner, Lookup, Aggregator, Router, Sorter, and Rank.
• Experience configuring Secure Agents, runtime environments, connections, and source/target integration settings.
• Robust understanding of Informatica workflow orchestration, job dependencies, scheduling, error handling, restartability, and operational monitoring.
• Strong SQL skills, including complex joins, subqueries, aggregations, analytical functions, and query optimization.
• Hands-on experience integrating Informatica IDMC with Snowflake or comparable enterprise data warehouse platforms.
• Understanding of ETL/ELT architecture, data warehousing, data modeling, incremental loading, and batch-processing patterns.
• Experience with Snowflake pushdown optimization, database-side transformations, and efficient data movement.
• Strong experience with data profiling, source-to-target mapping, data quality validation, reconciliation, and defect resolution.
• Experience troubleshooting and optimizing complex integration workflows and production data pipelines.
• Understanding of development, testing, and production environments, deployment management, and software development lifecycle practices.
• Ability to produce technical documentation and collaborate effectively with architects, developers, QA teams, and business stakeholders.

📌 Informatica Developer (Noida)
🏢 Anaptyss
📍 Noida