– Data Migration

Job Title

Data Migration Engineer – SQL

Locations: Location: Chennai / Bangalore / Pune / Coimbatore

Job Summary

We are looking for an experienced Data Migration with strong expertise in SQL, data profiling, data validation, reconciliation, and migration activities. The role will be responsible for analysing source data, designing and executing data migration processes, ensuring data quality and integrity, and resolving data-related issues throughout the migration lifecycle.

The ideal candidate should have strong hands-on experience with advanced SQL and database concepts, along with the ability to work closely with application, engineering, and business teams to ensure accurate and reliable data migration.

Key Responsibilities

- Analyse and understand source and target data structures, schemas, and business rules.
- Perform data profiling to identify data quality issues, inconsistencies, duplicates, and anomalies.
- Develop and execute data migration strategies, scripts, and transformation processes.
- Perform data extraction, transformation, cleansing, and loading across different systems/databases.
- Write complex and optimized SQL queries, stored procedures, joins, CTEs, subqueries, and analytical queries.
- Perform data reconciliation and validation between source and target systems.
- Identify and troubleshoot data discrepancies and migration failures.
- Ensure data completeness, accuracy, consistency, and integrity throughout the migration process.
- Develop validation queries and automated checks to support migration testing.
- Collaborate with application developers, data engineers, QA teams, business analysts, and other stakeholders.
- Analyse existing applications and databases to understand data dependencies and migration requirements.
- Support ETL/ELT processes and data transformation activities.
- Participate in migration testing, defect resolution, UAT,



and production deployment activities.
- Prepare migration documentation, data mapping documents, validation reports, and reconciliation reports.
- Monitor migration activities and proactively identify potential data risks or issues.
- Where required, contribute to application/API integration and backend development activities.

Required Skills Must-Have:

- Strong hands-on experience in SQL and database programming.
- Experience in data migration and data transformation projects.
- Strong understanding of data profiling, data validation, reconciliation, and data quality.
- Experience working with relational databases.
- Ability to write complex SQL queries and troubleshoot performance/data issues.
- Strong understanding of database structures, relationships, constraints, and data dependencies.
- Experience with ETL/ELT concepts and migration methodologies.
- Robust analytical and problem-solving skills.
- Ability to understand business requirements and translate them into technical/data solutions.

Good to Have

- Experience with Python or other scripting languages.
- Exposure to ETL tools such as Informatica, Talend, SSIS, or similar platforms.
- Experience with cloud databases/data platforms such as Azure, AWS, or GCP.
- Knowledge of REST APIs and application-to-database integrations.
- Exposure to full-stack/backend development.
- Experience working in Agile/Scrum environments.
- Experience handling large-volume data migration projects.

Experience 6+ years of relevant experience in Data Engineering, Data Migration, ETL, Database Development, or a closely related field.

Ideal Candidate Profile The ideal candidate will be someone who has a strong SQL and data engineering foundation, with practical experience in migration, profiling, reconciliation, validation, and data quality. Full-stack development experience can be an added advantage, but the primary focus of this role is data migration and engineering rather than UI/front-end development.

📌 Data Migration Engineer (Maharashtra)
🏢 True Tech Professionals
📍 Maharashtra