SSIS & T-SQL Data Migration Engineer (MySQL→SQL Server)

Improving; Ciudad de México; Remote; MXN 600,000 - 900,000; Full time

Job summary

Improving is seeking a skilled data integration specialist to migrate data from MySQL to SQL Server using SSIS. You will build robust data flows, ensure data integrity, and optimize large-volume loads.

Strong T-SQL expertise and experience with cross-database migrations are required; knowledge of SQL Server Agent and data validation is a plus. This role offers an opportunity to work in a diverse, inclusive team.

Qualifications

• Strong T-SQL expertise with SQL Server as target platform.
• Proven experience migrating data across database platforms (MySQL to SQL Server).
• Experience with parent/child key remapping in staging and crosswalk scenarios.

Responsibilities

• Develop, deploy, and maintain SSIS packages for data migration from MySQL to SQL Server.
• Build data flows with robust error handling and restart logic for resuming failed loads.
• Handle data type conversions between MySQL and SQL Server.
• Build staging and crosswalk loads with proper remapping of IDs.
• Validate migrations with row counts, checksums, and exception tables.

Skills

T-SQL expertise

Data migration

Data validation

Error handling

Cross-database migration

Tools

SQL Server

MySQL

Job description

Improving is seeking a skilled data integration specialist to migrate data from MySQL to SQL Server using SSIS. You will build robust data flows, ensure data integrity, and optimize large-volume loads.

Strong T-SQL expertise and experience with cross-database migrations are required; knowledge of SQL Server Agent and data validation is a plus. This role offers an opportunity to work in a diverse, inclusive team.