Data Migration Engineer

True Tech Professionals; Pune District; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

True Tech Professionals is seeking an experienced Data Migration specialist with strong SQL, data profiling, validation, reconciliation, and migration activities. You will analyse source data, design and execute migration processes, ensure data quality, and resolve issues throughout the migration lifecycle.

The ideal candidate has hands-on SQL and database concepts experience, and can collaborate with application, engineering, and business teams to ensure accurate data migration.

Qualifications

• Strong hands-on experience in SQL and database programming.
• Experience in data migration and data transformation projects.
• Knowledge of data profiling, data validation, reconciliation, and data quality.
• Experience with relational databases and complex SQL queries.
• Understanding of ETL/ELT concepts and migration methodologies.

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.

Skills

SQL

Data Migration

Data Profiling

Data Validation

Data Reconciliation

ETL/ELT concepts

Database Programming

Data Quality

Tools

Informatica

Talend

SSIS

Azure

AWS

GCP

Job description

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.
• Strong 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.