Informatica Developer

Role Overview: You will be working as an Informatica Developer at Everest DX, a Digital Platform Services company based in Stamford. Your main responsibility will be to design, develop, and optimize ETL workflows using Informatica PowerCenter and implement cloud-based ETL solutions using Informatica IDMC and IICS. Additionally, you will lead data migration projects from on-premise to cloud environments and collaborate with cross-functional teams to gather requirements and design solutions. Key Responsibilities: - 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. - Expertise on all transformations in Power Center and IDMC/IICS. - 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. Qualifications Required: - 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. (Note: The job description does not contain additional details about the company.) Role Overview: You will be working as an Informatica Developer at Everest DX, a Digital Platform Services company based in Stamford. Your main responsibility will be to design, develop, and optimize ETL workflows using Informatica PowerCenter and implement cloud-based ETL solutions using Informatica IDMC and IICS. Additionally, you will lead data migration projects from on-premise to cloud environments and collaborate with cross-functional teams to gather requirements and design solutions. Key Responsibilities: - 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. - Expertise on all transformations in Power Center and IDMC/IICS. - 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. Qualifications Required: - 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. (Note: The job description does not contain additional details about the company.)