SRM Technologies Technology/Software

Data Migration Specialist 1 (Lead Data Engineer)

Chennai, India In person Full-time

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.

Job description provided by SRM Technologies.
View the original posting