Description
You will design and maintain Azure Data Factory pipelines for ingestion, orchestration, and transformation while building scalable ETL/ELT solutions for enterprise data modernization.
This role is remote.
Responsibilities
- Design multizone data lake architectures (Bronze/Silver/Gold) using Azure cloud technologies and implement automated monitoring and error handling frameworks.
- Develop and optimize SQL/T-SQL scripts, stored procedures, and transformation logic for high-performance data processing.
- Extract and migrate data from legacy/mainframe environments, including IMS DB/DC and DB2 systems, ensuring accurate delta loads and production cutovers.
- Execute end-to-end migration activities, including source system inventory, data discovery, and field-level source-to-target mapping documentation.
- Develop CI/CD deployment pipelines and support Azure governance standards, including RBAC, ABAC, and Key Vault integration.
Required Skills
- 7+ years of experience in data engineering, ETL development, or cloud data modernization.
- Strong hands-on expertise with Azure Data Factory (ADF) for pipeline design and orchestration.
- Proficiency in Azure SQL, Azure Data Lake Storage (ADLS), and the broader Azure cloud ecosystem.
- Advanced SQL and T-SQL development skills, including stored procedures and complex query optimization.
- Experience implementing multizone data lake solutions and data quality validation controls.
- Proven track record migrating data from legacy or mainframe environments (IMS, DB2).
- Familiarity with DevOps practices, CI/CD processes, and automated testing frameworks.
Preferred Skills
- Experience supporting government or highly regulated environments.
- Azure Data Engineer certifications.
- Experience with Dynamics 365 and Power Platform integrations.