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

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