Data Migration Lead

Mployee.me; Pune District; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

Zensar is seeking a Data Migration Lead to manage and execute large-scale data migration initiatives. The role requires hands-on pipeline development, data mapping, transformation, loading, validation, and close collaboration with data architects and stakeholders.

You will plan, monitor, and drive migration activities across environments, ensuring accuracy and completeness of migrated data. With 10+ years in the field, you will lead a team, analyze source/target structures, create mapping

Qualifications

• Strong SQL and database knowledge.
• Experience with data migration projects.
• Experience in source-to-target mapping and data transformation.
• Hands-on experience writing migration/ETL scripts.
• Good understanding of relational databases, tables, relationships, keys, and data types.
• Experience with data validation and reconciliation.
• Good problem-solving and communication skills.
• Ability to lead and coordinate migration activities across technical teams.

Responsibilities

• 10+ year experience in data migration leadership.
• Expertise in data migration projects.
• Hands-on experience developing data migration pipelines, mapping, transformation, loading, monitoring and reconciliation.
• Lead a team and work independently.
• Analyze source and target database structures, maps, and relationships.
• Create and maintain source-to-target data mapping docs.
• Define data transformation and cleansing rules.
• Develop ETL scripts to migrate data.
• Build reusable data migration pipelines for large volumes.
• Execute and monitor migration activities across environments.
• Perform data validation and reconciliation.

Skills

SQL & DB knowledge

Data migration

Data mapping & transformation

ETL scripting

Data validation & reconciliation

Leadership

Problem solving

Communication

Education

Bachelor Degree

Job description

Job Description

Data migration lead to manage and execute large scale data migration activities

Responsibilities

Key Responsibilities

• 10+ year experience


• Expertise in data migration projects


• Hands-on experience with developing data migration pipelines, data mapping, transformation, loading, monitoring and reconciliation.


• Ability to work independently & lead a team


• Analyze source and target database structures, tables, fields, and relationships.


• Create and maintain source-to-target data mapping documents.


• Define data transformation and cleansing rules where required.


• Develop scripts to extract, transform, and load data from source to target databases.


• Build reusable pipelines for migrating large volume of data.


• Execute and monitor data migration activities across environments.


• Perform data validation and reconciliation to ensure migrated data is complete and accurate.


• Identify and resolve data migration issues and discrepancies.


• Work closely with data architect & business stakeholders


• Communicate effectively with client stakeholders


• Support migration testing & defect resolution


• Plan & support production cutover activities.


• Prepare migration documentation, including mapping, transformation rules, scripts, validation results, and migration runbooks.

Required Skills

• Strong SQL and database knowledge.


• Experience with data migration projects.


• Experience in source-to-target mapping and data transformation.


• Hands-on experience writing migration/ETL scripts.


• Good understanding of relational databases, tables, relationships, keys, and data types.


• Experience with data validation and reconciliation.


• Good problem-solving and communication skills.


• Ability to lead and coordinate migration activities across technical teams.

Qualifications

Bachelor Degree

About Us

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.