Description

You will design and maintain enterprise-scale data warehouse solutions using Informatica PowerCenter. You own the ETL lifecycle, from mapping development to workflow optimization, ensuring data integrity and performance.

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.

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.

Preferred Skills

• Bachelor’s degree in Computer Science, Information Systems, or related field.

Key Skills

Education

Any Gradute