We are working on an opportunity where we require few Informatica candidates.

Here is the JD for your reference.

Responsibilities :

- Candidate should have hands-on experience on ETL and SQL.

- Design, develop, and optimize ETL workflows using Informatica PowerCenter.

- Implement cloud-based ETL solutions using Informatica IDMC and IICS.

- Should have expertise on all transformations in Power Center and IDMC/IICS.

- Should have experience or knowledge on the PC to IICS migration using CDI PC tool or some other tool.

- Lead data migration projects, transitioning data from on-premise to cloud environments.

- Write complex SQL queries and perform data validation and transformation.

- Conduct detailed data analysis to ensure accuracy and integrity of migrated data.

- Troubleshoot and optimize ETL processes for performance and error handling.

- Collaborate with cross-functional teams to gather requirements and design solutions.

- Create and maintain documentation for ETL processes and system configurations.

- Implement industry best practices for data integration and performance tuning.

Required Skills :

- Hands-on experience with Informatica Power Center, IDMC and IICS.

- Strong expertise in writing complex SQL queries and database management.

- Experience in data migration projects (on-premise to cloud).

- Strong data analysis skills for large datasets and ensuring accuracy.

- Solid understanding of ETL design & development concepts.

- Familiarity with cloud platforms (AWS, Azure).

- Experience with version control tools (e.g., Git) and deployment processes.

Preferred Skills:

- Experience with data lakes, data warehousing, or big data platforms.

- Familiarity with Agile methodologies.

- Knowledge of other ETL tools.