Description

You will design and maintain enterprise-scale data warehouse solutions using Informatica PowerCenter.

This role is hybrid.

Responsibilities

• Develop complex mappings and workflows in Informatica PowerCenter to support data warehouse initiatives.
• Write and optimize advanced SQL queries for data extraction, transformation, and loading processes.
• Apply Kimball methodology principles to dimensional modeling and data integration design.
• Implement and execute data quality testing strategies using tools like QuerySurge.
• Own the ETL lifecycle, ensuring data integrity and performance.

Required Skills

• 10+ years of experience in ETL development and data warehouse architecture.
• 5+ years of hands-on expertise with Informatica PowerCenter, including Mappings and Workflows.
• Strong proficiency in SQL and data integration techniques.
• Practical knowledge of Kimball dimensional modeling methodology.
• Experience with data testing tools, specifically QuerySurge or similar.

Key Skills

Education

Any Gradute