ETL Informatica Developer

Description

Design, develop, and implement ETL processes using Informatica.
Collaborate with business analysts to understand data requirements and translate them into technical specifications.
Create and maintain data mappings, workflows, and procedures.
Optimize existing ETL processes for performance and efficiency.
Perform data profiling and quality checks to ensure accuracy and completeness.
Troubleshoot and resolve issues related to ETL processes and data quality.
Document ETL processes, data mappings, and technical specifications.
Participate in code reviews and ensure adherence to best practices.
Stay updated on industry trends and technologies related to ETL and data management

Responsibilities

• Analyze existing data integration solutions and provide recommendations for migration to Informatica Power Exchange and CDC Publisher.
• Design and develop migration plans and strategies for data integration solutions
• Create data mappings, transformations and workflows in informatica Power Exchange and CDC Publisher.
• Perform data profiling and data quality analysis to ensure data integrity during migration.
• Implement change data capture (CDC) solutions to capture and integrate real-time data changes from source systems during migration.
• Troubleshoot and resolve migration issues.
• Work closely with business analysts, developers, stakeholders to understand requirements
• Keep up-to-date with emerging trends and technologies in data integration and share knowledge with the team.
• At Least 5 years of experience in designing, developing, and maintaining data Integration solutions using Informatica Power Exchange and CDC Publisher.
• Strong understanding of data integration concepts, data mapping, data profiling, data quality, change data capture, And real time streaming.
• Experience with relational databases and SQL
• Strong problem-solving skills and ability to troubleshoot and resolve data integration issues.
• Excellent communication skills and ability to work collaboratively with business analysts, developers, and stakeholders.
• Ability to work independently and in a team environment.
• Experience with other informatica products is a plus.