Role Summary

We are seeking a Data Migration Engineer to design and execute enterprise data migration from legacy systems to a contemporary Azure SQL platform. The role involves developing ETL processes, implementing data transformation logic, validating data quality, and supporting production cutover to ensure accurate and successful migration.

Key Responsibilities
Develop and maintain SQL scripts for extracting, transforming, and loading (ETL) data into Azure SQL.
Design data transformation logic to map legacy data structures to the target Azure SQL data model.
Perform data reconciliation to ensure accuracy, completeness, and consistency between source and target systems.
Execute mock migration cycles, validate migrated data, and resolve migration issues before production deployment.
Document data mappings, transformation rules, reconciliation processes, and migration assumptions.
Manage migration scripts using Azure DevOps, Git, and CI/CD best practices.
Support data validation during System Integration Testing (SIT), User Acceptance Testing (UAT), and production cutover.
Troubleshoot migration issues, identify data anomalies, and implement corrective actions.




Collaborate with cross-functional teams to ensure successful migration delivery.

Required Skills
4- 7 years of experience in Data Engineering, ETL Development, or Data Migration.
Robust expertise in SQL, including complex queries, stored procedures, data transformation, and performance optimization.
Hands-on experience with Azure SQL Database or other cloud-based relational databases.
Solid understanding of ETL processes, data migration methodologies, and data integration best practices.
Experience in data reconciliation, validation, and source-to-target data verification.
Hands-on experience with Azure DevOps, Git, and CI/CD pipelines.
Familiarity with AI-assisted development tools for SQL generation, data mapping, and transformation.
Robust analytical, troubleshooting, documentation, and communication skills.

Preferred Skills
Experience migrating data from legacy enterprise systems or ERP platforms.
Knowledge of Azure Data Lake, Azure Synapse Analytics, or similar cloud data platforms.
Familiarity with enterprise cloud application data models.
Experience supporting production cutover, reconciliation, and post-migration validation.

📌 Data Migration Engineer Chennai
🏢 Kavi Software Technologies
📍 Chennai