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.
- Robust knowledge of data mapping, profiling, transformation, reconciliation, and validation.
- Experience designing repeatable and audit-ready ETL frameworks.
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.
- 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.
- Experience in financial, transactional, or regulatory data validation is preferred.
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.
Responsibilities
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.
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.
- 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.
- Experience in financial, transactional, or regulatory data validation is preferred.
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.
Qualifications
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.
- Robust knowledge of data mapping, profiling, transformation, reconciliation, and validation.
- Experience designing repeatable and audit-ready ETL frameworks.
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.
- 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.
- Experience in financial, transactional, or regulatory data validation is preferred.
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.
At Zensar, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises.
We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus.
Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.
We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.
📌 ETL Lead - Data || Offshore (Pune)
🏢 Zensar
📍 Pune