Description

You will design, develop, and maintain data integration workflows using Informatica PowerCenter and Greenplum.

Responsibilities

• Develop and maintain ETL processes, mappings, and sessions using Informatica PowerCenter and ETL Designer.
• Create, maintain, and optimize stored procedures, functions, and inline SQL for data transformation.
• Perform performance tuning for Informatica sources, mappings, targets, and sessions to ensure efficiency.
• Monitor, support, and resolve application issues involving Informatica and Greenplum environments.
• Participate in all phases of the Agile Software Development Life Cycle and provide on-call support during production maintenance hours.

Required Skills

• 3-5 years of experience with ETL development and Informatica PowerCenter.
• Strong proficiency in SQL and hands-on experience with Informatica ETL Designer.
• Experience working with Greenplum (PostgreSQL) or Oracle SQL/PLSQL.
• Ability to work effectively within an Agile development environment.
• Experience in application monitoring, troubleshooting, and issue resolution.
• Any Graduate degree.

Preferred Skills

• Experience with Greenplum specifically, as it is the primary data warehouse platform.
• Background in performance tuning large-scale ETL jobs.

Key Skills

Education

Any Graduate