Key Responsibilities

Design, develop, and maintain Azure Data Factory (ADF) pipelines for ingestion, orchestration, and transformation.
Build scalable ETL/ELT solutions supporting enterprise data migration and modernization.
Implement multizone data lake architectures (Bronze/Silver/Gold) using Azure cloud technologies.
Develop and optimize SQL/T-SQL scripts, stored procedures, and transformation logic.
Extract and migrate data from legacy/mainframe environments including IMS DB/DC and DB2 systems.
Implement automated monitoring, logging, alerting, and error handling frameworks for data pipelines.
Support scheduling frameworks, orchestration sequencing, and refresh cycle management.
Develop CI/CD deployment pipelines supporting data movement and database objects.
Execute end-to-end migration activities including extraction, transformation, validation, delta loads, and production cutovers.
Implement data quality and validation controls supporting reconciliation and accuracy reporting.
Collaborate with architects, analysts, SMEs, and project leadership teams.
Support Azure governance standards including RBAC, ABAC, and Key Vault integration.
Perform source system inventory and data discovery activities to support migration planning.
Develop and maintain ingestion contracts, including field-level source-to-target mapping documentation.
Support data classification efforts, including identification and documentation of PII, SSN, and other sensitive data elements.
Design and support transactional staging environments for data ingestion and migration processes.
Create and maintain Azure Data Factory (ADF) pipeline specifications and support technical documentation.

Required Qualifications

7+ years of experience in data engineering, ETL development, or cloud data modernization.
Strong hands-on expertise with Azure Data Factory (ADF).
Experience with Azure SQL, Azure Data Lake Storage (ADLS), and Azure cloud ecosystems.
Strong SQL and T-SQL development skills.
Experience developing multizone data lake solutions.
Experience migrating data from legacy or mainframe environments.
Experience implementing monitoring, logging, and automated validation frameworks.
Familiarity with DevOps and CI/CD processes.
Strong troubleshooting, analytical, and communication skills.