Data Migration Engineer SQL

Data Migration Engineer – SQL

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

SQL | Data Migration | Data Engineering | Data Profiling | Data Validation | Data Reconciliation | Data Quality | ETL/ELT | Database | Data Transformation | Stored Procedures | Query Optimization | Data Mapping | Python | API Integration

Interview Process

• L1: Virtual
• L2: In-Person
• Client Round: In-Person

Important: 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 [HIDDEN TEXT] or WhatsApp it to 8827565832.

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

Sourcebae on LinkedIn