Description

You will design, develop, and optimize ETL processes using Informatica PowerCenter for data warehousing initiatives.

This role is on-site.

Responsibilities

• Develop and maintain Informatica PowerCenter mappings, workflows, and sessions.
• Perform performance tuning of Informatica mappings and workflows to ensure efficient data processing.
• Implement data extraction, transformation, and loading processes using strong SQL skills.
• Apply dimensional data modeling concepts, including Star and Snowflake schemas.
• Utilize Unix/Linux scripting for automation and operational support.

Required Skills

• 5-10 years of experience in Informatica PowerCenter development.
• Strong knowledge of ETL concepts and Data Warehousing.
• Hands-on experience with Informatica Workflow Manager and Repository Manager.
• Proficiency in SQL and database management (Oracle, SQL Server, PostgreSQL, Teradata).
• Experience with Unix/Linux scripting.
• Understanding of dimensional data modeling (Star/Snowflake schemas).
• Bachelor's degree in a related field.

Preferred Skills

• Experience with PowerExchange.
• Experience with Informatica Data Quality.

Key Skills

Education

Bachelor's degree