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. Robust 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).

📌 Informatica Developer (Chennai)
🏢 SWITS DIGITAL Private
📍 Chennai