Description

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

Key Skills

Education

Bachelor's degree