Data Migration Specialist 1 (Lead Data Engineer)

Posted 8 Hours Ago
Be an Early Applicant
Chennai, Tamil Nadu, IND
In-Office
Senior level
Information Technology
The Role
Lead enterprise data migration architecture, including legacy schema analysis, Azure SQL mapping, ETL pipeline design, transformation logic, dry-run oversight, reconciliation, and production cutover. The role uses Azure Data Factory, ADLS Gen2, PySpark, Python, and SQL to ensure data integrity, performance, auditability, and financial ledger reconciliation during migration.
Summary Generated by Built In
Data Migration Specialist 1 (Lead Data Engineer)

Seniority / Level:

Senior (7+ Years)

Location / Work Mode:

Offshore


​

Primary Deliverables / Focus:

Data Migration Plan (D-03), Schema Mapping Specs, Pipeline Architecture & Final Reconciliation Report (D-08)

 

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 Required

  • 7+ years of data engineering and database migration experience leading complex, large-scale enterprise data migrations
  • Extensive expertise with Azure Data Factory, Azure Data Lake Storage Gen2, and Azure SQL Database or Managed Instance
  • Proficiency in SQL data manipulation, stored procedure optimization, indexing, and bulk loading utilities including BCP and SSMA
  • Strong programming skills in Python and PySpark for complex data transformations and normalization
  • Deep understanding of data quality governance, schema translation, data cleansing, and audit reconciliation techniques
  • Experience with relational databases including Oracle and SQL Server, and legacy formats including copybooks, fixed-width files, and VSAM extracts
  • Microsoft Certified: Azure Data Engineer Associate
  • Prior experience migrating IBM or Unisys mainframe data into modern relational cloud databases
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Chennai
1,396 Employees
Year Founded: 1998

What We Do

SRM Technologies is a global IT services company specialising in automotive technologies, digital transformation and product engineering services. We provide technology consulting, platform development, data analytics, artificial intelligence, cloud enablement, digital infrastructure, quality assurance, embedded software and design to manufacturing product solutions to various industries and enterprises across the North America, Japan, Europe and India. At the heart of our organization are passionate employees who embody our core belief - 'ideas@work.' We firmly believe that ideas and innovation truly matter only when they create a meaningful impact on our customers' businesses and the lives of their end customers. Therefore, we prioritize the practical application of these ideas and their transformative impact through our talented and ever-growing workforce. 𝘚𝘙𝘔 𝘛𝘦𝘤𝘩 𝘪𝘴 𝘢 𝘱𝘳𝘰𝘶𝘥 𝘮𝘦𝘮𝘣𝘦𝘳 𝘰𝘧 𝘵𝘩𝘦 𝘚𝘙𝘔 𝘎𝘳𝘰𝘶𝘱, 𝘢 𝘮𝘶𝘭𝘵𝘪𝘯𝘢𝘵𝘪𝘰𝘯𝘢𝘭 𝘤𝘰𝘯𝘨𝘭𝘰𝘮𝘦𝘳𝘢𝘵𝘦 𝘸𝘪𝘵𝘩 𝘢 𝘳𝘪𝘤𝘩 𝘩𝘪𝘴𝘵𝘰𝘳𝘺 𝘴𝘱𝘢𝘯𝘯𝘪𝘯𝘨 𝘰𝘷𝘦𝘳 𝘧𝘰𝘶𝘳 𝘥𝘦𝘤𝘢𝘥𝘦𝘴. 𝘛𝘩𝘦 𝘚𝘙𝘔 𝘎𝘳𝘰𝘶𝘱 𝘰𝘱𝘦𝘳𝘢𝘵𝘦𝘴 𝘪𝘯 𝘥𝘪𝘷𝘦𝘳𝘴𝘦 𝘴𝘦𝘤𝘵𝘰𝘳𝘴, 𝘪𝘯𝘤𝘭𝘶𝘥𝘪𝘯𝘨 𝘌𝘥𝘶𝘤𝘢𝘵𝘪𝘰𝘯, 𝘛𝘦𝘤𝘩𝘯𝘰𝘭𝘰𝘨𝘺, 𝘏𝘦𝘢𝘭𝘵𝘩𝘤𝘢𝘳𝘦, 𝘢𝘯𝘥 𝘔𝘦𝘥𝘪𝘢

Similar Jobs

Tapestry - Coach and Kate Spade Logo Tapestry - Coach and Kate Spade

Manager, Production Operations

eCommerce • Fashion • Retail • Sales • Wearables • Design
Remote or Hybrid
India
16000 Employees

Pfizer Logo Pfizer

External Supply PC1 Network Strategy Lead

Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Remote or Hybrid
9 Locations
121990 Employees
163K-272K Annually

Toast Logo Toast

Senior Software Engineer

Cloud • Fintech • Food • Information Technology • Software • Hospitality
In-Office
Chennai, Tamil Nadu, IND
5000 Employees

Capco Logo Capco

Project Manager

Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Remote or Hybrid
India
6000 Employees

Similar Companies Hiring

NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity • Defense • Defense Technology
Austin, TX
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
567 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account