Description

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

This role is on-site.

Responsibilities

• Develop and maintain complex Informatica mappings, workflows, and sessions for data extraction, transformation, and loading.
• Perform performance tuning of Informatica mappings and workflows to ensure efficient data processing.
• Implement dimensional data modeling techniques, including Star and Snowflake schemas.
• Write and optimize complex SQL queries for Oracle, SQL Server, PostgreSQL, and Teradata databases.
• Utilize Unix/Linux scripting for automation and integration tasks.

Required Skills

• 10+ years of experience in Informatica PowerCenter development.
• Strong knowledge of ETL concepts and Data Warehousing principles.
• Hands-on experience with Informatica Workflow Manager and Repository Manager.
• Proficiency in SQL and database management across Oracle, SQL Server, PostgreSQL, and Teradata.
• Experience with data extraction, transformation, and loading processes.
• Strong understanding of dimensional data modeling.
• Proficiency in Unix/Linux scripting.

Preferred Skills

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

Key Skills

Education

Bachelor's degree