Job Title: Data Migration Specialist
Experience: 5+ Years
Location: Chennai, Bangalore, Hyderabad, Pune, Gurgaon
Work Mode: Hybrid – 3 Days Work from Office
Budget: Up to ₹1.70 LPM
Payroll: Haparz
Notice Period: Immediate Joiners Preferred
Role Overview
We are looking for an experienced Data Migration Specialist with strong expertise in migration strategy, ETL processes, data mapping, migration automation, and large-scale data transfers. The ideal candidate should be capable of planning and executing end-to-end data migration from legacy systems to modern SaaS platforms, ensuring data accuracy, completeness, security, and minimal business disruption.
The candidate will be responsible for developing migration strategies, validating data transformations, automating migration workflows, and supporting cutover activities. Experience with Snowflake, high-volume data processing, and PII data protection will be an added advantage.
Key Responsibilities
- Design and execute end-to-end data migration strategies, including source analysis, target data modelling, migration planning, and validation.
- Analyse legacy databases and applications to understand data structures, dependencies, relationships, and migration requirements.
- Develop source-to-target data mappings, transformation rules, and data cleansing processes to ensure data consistency.
- Build, configure, and optimise ETL/ELT pipelines for extracting, transforming, validating, and loading data into target platforms.
- Automate migration workflows, reconciliation processes, and data validation checks to reduce manual effort and migration errors.
- Execute full, incremental, and delta data loads based on migration requirements.
- Plan and execute cutover activities, including final data loads, reconciliation, issue resolution, and post-migration validation.
- Perform data quality checks to identify duplicates, missing records, invalid values, and inconsistencies between source and target systems.
- Conduct performance and volume testing to validate migration throughput, processing time, and scalability for large datasets.
- Troubleshoot migration failures, transformation defects, data mismatches, and ETL pipeline performance issues.
- Ensure secure handling of Personally Identifiable Information (PII) through appropriate masking, access controls, encryption, and data protection practices.
- Collaborate with business stakeholders, application teams, data engineers, and QA teams to ensure successful migration delivery.
- Maintain migration documentation, mapping specifications, validation reports, reconciliation results, and cutover plans.
Required Experience
- 5+ years of experience in data migration, data integration, ETL/ELT, or related data engineering activities.
- Hands-on experience with data migration strategy, source-to-target mapping, transformation logic, and data validation.
- Practical experience migrating data from legacy systems to SaaS applications or modern cloud platforms.
- Experience developing or automating ETL pipelines, migration scripts, and reconciliation processes.
- Knowledge of full, incremental, and delta data loading techniques.
- Experience with cutover planning, migration execution, data reconciliation, and post-migration verification.
- Experience handling large datasets and performing performance and volume testing.
- Strong SQL skills for data profiling, transformation validation, reconciliation, and troubleshooting.
Good to Have
- Experience with Snowflake, including data loading, SQL queries, and data validation.
- Exposure to cloud-based data migration and integration platforms.
- Understanding of PII handling, data masking, encryption, and data security controls.
- Experience with ETL tools such as Informatica, Talend, Azure Data Factory, AWS Glue, or similar platforms.
- Experience with Python or scripting for migration automation.
- Familiarity with migration runbooks, rollback planning, and production cutover procedures.
Work Location: Hybrid remote in Hyderabad, Telangana
