ETL Lead - Data || Offshore

Role overview

ETL Lead - Data || Offshore at Zensar

The role will be responsible for defining the end-to-end data migration architecture, designing ETL pipelines, handling legacy data complexity, and ensuring record-level accuracy, auditability, and functional equivalence between legacy and modernized platforms.

Preferred qualifications and skills

• Azure Data Platform Skills Azure Data Factory ADLS Gen2 Azure SQL / SQL Managed Instance SQL Server Data pipelines and staging layers Monitoring and pipeline failure handling Legacy Data Skills Experience with mainframe or HP NonStop data migration is preferred.
• Experience in financial, transactional, or regulatory data validation is preferred.

Employment details

• Location: India

Additional role details

• Core Data & ETL Skills Strong experience in ETL / ELT architecture and enterprise data migration.
• Hands-on experience with large-scale data migration from legacy platforms to cloud.
• Strong knowledge of data mapping, profiling, transformation, reconciliation, and validation.
• Experience designing repeatable and audit-ready ETL frameworks.
• Understanding of SQL/MP, Enscribe, COBOL copybooks, packed decimals, fixed-width files, and batch data processing.
• Ability to translate legacy data structures into relational/cloud-native target models.
• Data Quality & Reconciliation Strong experience with source-to-target reconciliation.
• Ability to design validation rules, exception handling, and audit reports.
• AI & Agile Experience Exposure to AI-assisted data migration, data profiling, or ETL generation.
• Experience working in Agile / Scrum / SAFe delivery models.
• Ability to work in sprint-based, wave-based, and evidence-driven delivery structures.
• The TrackAll data estate includes SQL/MP tables, Enscribe flat files, COBOL-driven batch data, SSIS reporting, and COLD+ reports, with target-state modernization planned around Azure-native data services.