Description

Lead complex data migration projects, moving data from legacy systems to modern platforms. Own end-to-end ETL processes, including extraction, transformation, and loading. Manage data integration, master data management, cleansing, ingestion, and hierarchy management. Develop and tune complex database objects and automation scripts.

Responsibilities

• Lead development efforts as a technical lead on complex data projects.
• Execute end-to-end ETL processes including data extraction, transformation, and loading.
• Implement and maintain data integration and master data management processes.
• Manage data cleansing, ingestion pipelines, matching, merging, and hierarchy management.
• Develop and tune complex database objects and automation scripts.

Required Skills

• 7+ years of experience in complex data migration projects.
• 7+ years of hands-on experience with Informatica PowerCenter, Informatica Data Quality, and Informatica MDM.
• 7+ years of experience migrating data from databases, flat files, JSON, and XML.
• 5+ years of experience with data profiling, cleansing, standardization, and match/merge using Informatica Data Quality.
• 3+ years of experience with Informatica MDM activities, including deduplication and orchestration.
• 5+ years of experience implementing Slowly Changing Dimensions (SCD) and Change Data Capture (CDC).
• 7+ years of experience developing complex SQL, T-SQL, or PL/SQL objects in Oracle 19c or SQL Server 2019+.
• 3+ years of experience writing UNIX shell scripts for file validation, FTP, and ETL automation.
• 2+ years of experience in a leadership role as a Developer.

Preferred Skills

• Expertise in performance tuning for stored procedures, triggers, packages, and materialized views.

Key Skills

Education

Any Graduate