Description

You will design, develop, and optimize complex ETL workflows and data integration processes using Informatica PowerCenter and IICS.

This role is on-site.

Responsibilities

• Design and develop ETL mappings and workflows in Informatica PowerCenter for diverse data sources.
• Implement data transformation logic including cleansing, enrichment, and validation to meet business requirements.
• Optimize ETL processes, SQL queries, and mappings to resolve performance bottlenecks and ensure scalability.
• Maintain data integrity through quality checks, validation rules, and robust error handling mechanisms.
• Mentor junior developers and collaborate with cross-functional teams on data integration initiatives.

Required Skills

• 7+ years of experience in ETL development and data integration.
• 7+ years of hands-on experience with Informatica PowerCenter and PowerExchange.
• Hands-on experience with IICS (IDMC).
• Proficiency with Oracle and Teradata databases.
• Experience with Azure cloud platform and Synapse.
• Strong SQL skills.
• Knowledge of Hadoop (HDFS).
• Knowledge of UNIX/Linux, shell scripting, and Java.

Preferred Skills

• Master's degree in a related field.
• Experience with DB2/MVS.
• API experience.

Key Skills

Education

Any Graduate