Informatica Developer

Job Description – Informatica Developer

Role: Informatica Developer

Experience: 5+ Years

Location: Pune

Job Type : Contract 2 hire

Skills: IICS, SQL

Job Summary

We are looking for an experienced Informatica Developer with strong expertise in IICS and SQL. The candidate will be responsible for designing, developing, and maintaining ETL solutions and data integration workflows to support business and analytics requirements.

Key Responsibilities

• Design, develop, and maintain ETL workflows using Informatica Intelligent Cloud Services (IICS).
• Develop and optimize SQL queries, stored procedures, and database objects.
• Work closely with business analysts and data teams to understand data integration requirements.
• Perform data extraction, transformation, and loading activities from multiple source systems.
• Troubleshoot and resolve ETL and data quality issues.
• Optimize workflow performance and ensure efficient data processing.
• Implement data validation, testing, and error handling mechanisms.
• Maintain technical documentation for ETL processes and workflows.
• Collaborate with cross-functional teams for deployment and production support.

Required Skills

• 5+ years of experience in Informatica development.
• Strong hands-on experience with Informatica IICS.
• Strong SQL development and query optimization skills.
• Experience with ETL development and data integration concepts.
• Good understanding of relational databases and data warehousing concepts.
• Experience in debugging and performance tuning ETL workflows.
• Strong analytical and problem-solving skills.
• Good communication and teamwork abilities.

Preferred Skills

• Exposure to cloud platforms and modern data integration tools.
• Experience in handling large-scale data migration projects.
• Knowledge of scheduling and monitoring tools is an added advantage.