We are working on an prospect 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.
Solid expertise in writing complex SQL queries and database management.
Experience in data migration projects (on-premise to cloud).
Robust 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.