Data Migration Specialist
Chennai, India · Full-time
- Posted 5d ago
- From SRM Technologies’s careers page
- Location
- Chennai, India
- Type
- Full-time
- Level
- Senior
- Experience
- 7+ years
- Department
- Data and Analytics
Opens the listing on careers.srmtech.com
Let the right jobs find you
In your inbox every Wednesday and SaturdayPersonalised suggestions from verified career pages, matched to your role, location, level and skills.
About the role
Role Objective & Summary
The Lead Data Engineer commands the data migration architecture, transformation logic, and reconciliation framework. Starting in November for legacy schema discovery, this senior engineer maps source data structures to the modern Azure SQL schema, designs automated ETL pipelines in Azure Data Factory, governs multi-cycle dry runs, and authors the final audit-grade reconciliation report.
Core Key Responsibilities
- Author the Data Migration Plan (Deliverable D-03), establishing migration stages, transformation rules, validation thresholds, and rollback plans.
- Conduct deep legacy schema analysis, mapping historical entities, fields, constraints, and data dictionaries to the target Azure SQL schema.
- Architect scalable, automated ETL/ELT pipelines using Azure Data Factory (ADF), PySpark, and SQL stored procedures.
- Design and oversee multi-cycle migration dry runs, tracking extraction throughput, transformation accuracy, and load performance.
- Establish automated field-level checksum, hash comparison, and record reconciliation routines to ensure zero critical data loss.
- Author the Final Data Reconciliation Report (Deliverable D-08), certifying 100% data integrity and financial ledger reconciliation.
- Lead the technical execution of cutover data migration during the production go-live window in September.
Required Technical Skills & Competencies
- 7+ years of data engineering and database migration experience leading complex, large-scale enterprise data migrations.
- Extensive expertise with Microsoft Azure Data Factory (ADF), Azure Data Lake Storage (ADLS Gen2), and Azure SQL Database / Managed Instance.
- Proficiency in SQL data manipulation, stored procedure optimization, indexing, and bulk loading utilities (BCP, SSMA).
- Strong programming skills in Python / PySpark for complex data transformations and normalization.
- Deep understanding of data quality governance, schema translation, data cleansing, and audit reconciliation techniques.
- Experience working with relational (Oracle, SQL Server) and legacy data formats (copybooks, fixed-width files, VSAM extracts).
Preferred Qualifications & Certifications
- Microsoft Certified: Azure Data Engineer Associate.
- Prior experience migrating legacy IBM or Unisys mainframe data into modern relational cloud databases.
Skills they ask for
Pick one to see other roles that ask for it.
About SRM Technologies
Digital and mobility engineering partnerSRM Technologies is a global engineering partner delivering automotive embedded systems, digital platforms, AI, cloud and enterprise transformation solutions.
See all 29 roles at SRM TechnologiesMore roles at SRM Technologies
See all 29- Oracle Redwood ConsultantChennaiInformation TechnologyChennai, India2d
- Service Delivery ManagerChennaiInformation TechnologyChennai, India3d
- Database AdministratorChennai · Entry Level · On-siteInformation Technology · Entry Level · On-siteChennai, India3d
- Site Reliability EngineerChennaiInformation TechnologyChennai, India3d
Let the right jobs find you
In your inbox every Wednesday and SaturdayPersonalised suggestions from verified career pages, matched to your role, location, level and skills.