Description

Develop and maintain ETL processes using Informatica PowerCenter for data warehouse environments.

This role is on-site.

Responsibilities

• Develop, configure, and unit test source-to-target mappings based on technical specifications.
• Design and document ETL solutions, estimating work effort for project deliverables.
• Provide first and second-level technical support for Informatica administration and production issues.
• Participate in design and code review sessions, adhering to ETL development best practices.
• Identify and implement improvements to the data warehouse environment.

Required Skills

• 5+ years of hands-on experience in ETL development for data warehousing.
• 5+ years developing, maintaining, and enhancing Informatica Mappings, Workflows, and processes.
• Strong experience writing and optimizing complex SQL queries.
• Experience with Query Surge for testing and validation.
• Working knowledge of Kimball data warehouse design methodology.
• Expertise with integration technologies and processes.
• Experience working in a Windows environment.
• Knowledge of testing tools and techniques.

Preferred Skills

• 3+ years tenure in previous similar roles.
• Bachelor's degree in a related field or equivalent experience.

Key Skills

Education

Any Gradute