Description

Lead complex data migration projects and manage end-to-end ETL workflows using Informatica tools.

This role is on-site.

Responsibilities

• Lead data migration projects from legacy systems using Informatica PowerCenter and MDM.
• Design and implement ETL processes for data extraction, transformation, and loading.
• Automate ETL processes and workflows using UNIX shell scripting.
• Manage MDM activities including data cleansing, deduplication, and hierarchy management.
• Perform data quality profiling and monitor ETL process performance.

Required Skills

• 10+ years of experience in complex data migration projects.
• 2+ years of experience in a technical leadership role.
• Hands-on experience with Informatica PowerCenter, Informatica Data Quality, and Informatica MDM.
• Proficiency in SQL, T-SQL, and PL/SQL.
• Experience working with Oracle 19c or SQL Server 2019+.
• Strong UNIX shell scripting skills for process automation.
• Experience with JSON, XML, and flat file data migration.
• Knowledge of Slowly Changing Dimensions (SCD Type) and Change Data Capture (CDC).

Key Skills

Education

Any Graduate