Data Migration Engineer – SQL

Sourcebae

Chennai, Tamil Nadu, India

Location: Chennai / Bangalore / Pune / Coimbatore

Work Mode: Hybrid

Employment: Contract (C2H)

Experience: 6+ Years

Job Summary

We are looking for an experienced Data Migration Engineer with strong expertise in SQL, data profiling, data validation, reconciliation, data transformation, and migration activities.

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

Key Responsibilities

Analyse source and target data structures, schemas, relationships, and business rules.
Perform data profiling to identify data quality issues, duplicates, inconsistencies, and anomalies.
Develop and execute data migration strategies, scripts, and transformation processes.
Perform data extraction, transformation, cleansing, and loading across systems/databases.
Write complex and optimized SQL queries, stored procedures, joins, CTEs, subqueries, and analytical queries.
Perform data validation and reconciliation between source and target systems.
Troubleshoot data discrepancies, migration failures, and performance issues.
Ensure data completeness, accuracy, consistency, and integrity.
Develop validation queries and automated checks for migration testing.
Support ETL/ELT processes and data transformation activities.
Participate in migration testing, defect resolution, UAT, and production deployment.
Prepare data mapping, migration, validation, and reconciliation documentation.
Collaborate with developers, data engineers, QA teams, business analysts, and other stakeholders.
Analyse applications and databases to understand data dependencies and migration requirements.
Monitor migration activities and identify potential data risks or issues.
Where required, support API integration and backend activities.Mandatory Skills
6+ years of relevant experience in Data Engineering, Data Migration, ETL, or Database Development.
Strong hands-on SQL and database programming.
Hands-on experience in Data Migration and Data Transformation projects.
Strong knowledge of Data Profiling, Data Validation, Data Reconciliation, and Data Quality.
Strong experience with relational databases.
Advanced SQL including complex queries, joins, CTEs, subqueries, analytical queries, and stored procedures.
Strong understanding of database structures, relationships, constraints, and data dependencies.
Experience with ETL/ELT concepts and migration methodologies.
Ability to troubleshoot data and SQL performance issues.
Strong analytical and problem-solving skills.Good to Have
Python or other scripting languages.
Informatica, Talend, SSIS, or similar ETL tools.
Azure, AWS, or GCP data platforms.
REST APIs and application-to-database integrations.
Full-stack/backend development exposure.
Agile/Scrum experience.
Experience with large-volume data migration projects.Key Skills

Interview Process

L1: Virtual
L2: In-Person
Client Round: In-PersonImportant: Candidates should be available for the required in-person interview rounds and should be comfortable with the hybrid work model.

Apply Now

Interested candidates can share their updated CV at Khushboo@Sourcebae.com or WhatsApp it to 8827565832.

Stay updated with our latest job opportunities and company news by following us on LinkedIn:

Sourcebae on LinkedIn

Score my resume against this job, free →