Description

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

This role is on-site.

Responsibilities

• Develop and maintain complex Informatica PowerCenter mappings, workflows, and sessions.
• Perform performance tuning and troubleshooting of Informatica objects to ensure optimal data processing.
• Implement data extraction, transformation, and loading processes aligned with dimensional data modeling principles.
• Write and optimize complex SQL queries for Oracle, SQL Server, PostgreSQL, and Teradata.
• Utilize Unix/Linux scripting for automation and workflow management.

Required Skills

• 10+ years of experience in Informatica PowerCenter development.
• Deep understanding of ETL concepts and Data Warehousing architectures.
• Hands-on expertise with Informatica Workflow Manager and Repository Manager.
• Strong SQL skills and experience with Oracle, SQL Server, PostgreSQL, and Teradata.
• Proficiency in Unix/Linux scripting.
• Solid grasp of dimensional data modeling (Star/Snowflake schemas).

Preferred Skills

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

Key Skills

Education

Bachelor's degree