Informatica Developer – IICS / IDMC

ValueMomentum; Hyderabad; On-site; INR 900,000 - 1,200,000; Full time

Job summary

A data solutions firm is seeking an Informatica Developer with strong experience in IICS/IDMC and SQL to join their data engineering team. This role involves designing and developing scalable data integration solutions, performing ETL processes, and ensuring data quality and integrity. The ideal candidate will have 4–9 years of experience in ETL development and a solid understanding of data warehousing concepts. Collaboration with various teams will be essential to deliver effective solutions in a fast-paced environment.

Qualifications

• 4–9 years of experience in Data Integration / ETL Development.
• Minimum 2+ years of hands-on experience in IICS or IDMC.
• Strong proficiency in SQL and relational databases.

Responsibilities

• Design, develop, and implement ETL workflows using IICS / IDMC.
• Develop and optimize SQL queries and stored procedures.
• Build and maintain data integration pipelines.

Skills

Data Integration

ETL Development

SQL

Data Warehousing

Analytical Skills

Tools

IICS

IDMC

Informatica PowerCenter

AWS

Azure

GCP

Job description

Job Summary

We are seeking a skilled Informatica Developer with strong experience in IICS/IDMC and SQL to join our growing data engineering team. The ideal candidate will be responsible for designing, developing, and maintaining scalable data integration solutions using Informatica Intelligent Cloud Services (IICS) / Informatica Intelligent Data Management Cloud (IDMC). This role requires strong experience in ETL development, data integration, and database technologies to support enterprise data platforms.

Key Responsibilities

• Design, develop, and implement ETL workflows and mappings using IICS / IDMC.
• Develop and optimize SQL queries, stored procedures, and data transformation logic.
• Build and maintain data integration pipelines across multiple data sources.
• Perform data extraction, transformation, and loading (ETL) for large-scale data processing.
• Ensure data quality, consistency, and integrity across systems.
• Troubleshoot and resolve performance issues in ETL jobs and SQL queries.
• Collaborate with data architects, analysts, and business teams to understand requirements and deliver scalable solutions.
• Participate in code reviews, testing, and deployment activities.
• Support production issues and ongoing enhancements in data integration processes.
• Document ETL workflows, data mappings, and system architecture.

Required Skills

• 4–9 years of experience in Data Integration / ETL Development.
• Minimum 2+ years of hands-on experience in IICS or IDMC.
• Strong proficiency in SQL and relational databases.
• Experience developing ETL pipelines and data workflows.
• Strong understanding of data warehousing concepts and ETL best practices.
• Experience with performance tuning and optimization of ETL jobs.
• Knowledge of data quality, data governance, and integration patterns.
• Strong analytical and problem-solving skills.

Preferred Skills

• Experience with Informatica PowerCenter.
• Exposure to Cloud platforms (AWS, Azure, or GCP).
• Knowledge of data lakes and modern data architecture.
• Experience working in Agile/Scrum environments.