Informatica Developer

Job Title: Informatica Developer

Location: Chennai

Experience: 5 7 Years

Job Summary We are looking for an experienced

Informatica Developer with 5 7 years of experience in designing, developing, and optimizing enterprise ETL solutions using

Informatica PowerCenter, Informatica Data Quality (IDQ), or Informatica Intelligent Cloud Services (IICS) . The ideal candidate should have strong expertise in SQL, data warehousing concepts, ETL development, and performance tuning to build scalable and reliable data integration solutions.

Key Responsibilities

• Design, develop, and maintain end-to-end ETL pipelines using Informatica PowerCenter, IDQ, or IICS.
• Develop complex mappings, transformations, sessions, workflows, and reusable components.
• Integrate data from multiple sources including databases, APIs, cloud storage, and enterprise applications.
• Translate business requirements into technical ETL and data warehouse solutions.
• Optimize ETL jobs, SQL queries, and workflows for improved performance and scalability.
• Design and implement data validation, cleansing, and error-handling mechanisms.
• Schedule and automate ETL workflows for daily and batch data processing.
• Perform unit testing, troubleshoot production issues, and support ongoing maintenance.
• Ensure data quality, integrity, and compliance with enterprise data governance standards.
• Collaborate with cross-functional teams to deliver high-quality data integration solutions.

Required Skills

• 5 7 years of experience in Informatica ETL development.
• Strong hands-on experience with: + Informatica PowerCenter + Informatica Data Quality (IDQ) + Informatica Intelligent Cloud Services (IICS)
• Strong SQL and relational database skills.
• Experience with Unix/Linux shell scripting.
• Good understanding of Data Warehousing concepts.
• Knowledge of Dimensional Modeling, Star Schema, and Snowflake Schema.
• Experience in developing ETL mappings, sessions, workflows, and performance tuning.
• Experience in data validation, data quality, and troubleshooting ETL failures.
• Excellent analytical and problem-solving skills.
• Strong communication and teamwork skills.

Preferred Skills

• Experience integrating with Search Platforms, PIM solutions, or similar enterprise platforms.
• Experience with XML.
• Knowledge of JavaScript, jQuery, HTML5, and CSS.
• Familiarity with JavaScript frameworks such as Node.js, Vue.js, or Angular.
• Exposure to databases like Oracle and MongoDB.
• Knowledge of web servers such as Apache and IIS.
• Understanding of UI/UX concepts.

Educational Qualification

• Bachelor's or Master's Degree in Engineering (B.E./B.Tech CS/IT/IS or equivalent).