Informatica Developer

Responsibilities:

• Design, develop, and maintain ETL processes for data warehouse solutions using Informatica PowerCenter.
• Create and optimize Informatica Mappings, Workflows, and processes to ensure efficient data extraction, transformation, and loading.
• Lead and coordinate an Informatica development team, providing guidance, support, and mentorship to team members.
• Collaborate with stakeholders to understand business requirements and translate them into technical solutions.
• Develop and maintain complex SQL queries to extract and manipulate data from various sources.
• Utilize integration technologies and processes to integrate data from disparate systems into the data warehouse.
• Apply Kimball design methodology principles to ensure the effectiveness and efficiency of data warehouse solutions.

Requirement:

• 10+ years of hands-on experience in ETL development for a data warehouse.
• 10+ years of hands-on experience in development, maintenance, and enhancements of Informatica Mappings, Workflows, and processes.
• 8+ years of leadership experience, including the management and coordination of an Informatica team.
• Strong expertise in complex SQL for data manipulation and extraction.
• Proficiency in integration technologies and processes.
• Experience with Query Surge for data validation and testing.

Key Skills:

• Proficiency in ETL Tools.
• Strong SQL Skills.
• Data Modeling Expertise
• Problem-Solving Acumen.
• Collaboration and Communication.
• Continuous Learning.