Data Migration Engineer

Espire Infolabs; Delhi; Hybrid; INR 2,200,000 - 4,200,000; Full time

Job summary

Espire Infolabs is seeking a data engineer to own the data migration approach from legacy systems to Salesforce, focusing on extracting from legacy systems into an Azure staging layer, then mapping, cleansing and reconciling data for Salesforce load. You will work with the onshore Integration Lead and data owners.

Design and build in Azure—ADLS Gen2 staging layers, data factory pipelines, and Azure Functions code.

Qualifications

• 6-10 years in data engineering with at least one large-scale end-to-end migration.
• Strong experience with Azure data services and data warehousing concepts.
• Ability to communicate clearly with senior stakeholders.
• Willing to travel to the UK and work UK office hours.

Responsibilities

• Design and own the Azure staging layer (ADLS Gen2 zoning: raw, cleansed, curated).
• Lead early data mapping and cleansing for Student record management , UGA/Clearing, PGA Ellucian (Dynamics) and TargetX.
• Build extraction and transformation pipelines in Azure Data Factory, and write code in Azure Functions where pipelines arent enough.
• Identify data quality issues early and work with LU data owners to resolve them.
• Maintain migration logs, reconciliation reports, issue trackers and field-level lineage.
• Support cutover readiness and reconciliation.
• Support the Integration Lead on data-side dependencies.

Skills

Azure Data Lake Gen2

Azure Data Factory

Azure SQL

Azure Functions (C# or Python)

ETL/ELT

Data quality & reconciliation

Stakeholder communication

Travel to UK

Tools

Azure Synapse

Databricks

Job description

Role summary

You will own the data migration approach legacy system to Salesforce. That covers extracting from legacy systems into an Azure staging layer, then mapping, cleansing and reconciling data so Creation can load Salesforce. You work closely with the onshore Integration Lead and with LUs data owners.

Responsibilities

• Design and own the Azure staging layer (ADLS Gen2 zoning: raw, cleansed, curated).


• Lead early data mapping and cleansing for Student record management , UGA/Clearing, PGA Ellucian (Dynamics) and TargetX.


• Build extraction and transformation pipelines in Azure Data Factory, and write code in Azure Functions where pipelines arent enough.


• Identify data quality issues early and work with LU data owners to resolve them.


• Maintain migration logs, reconciliation reports, issue trackers and field-level lineage.


• Support cutover readiness and reconciliation.


• Support the Integration Lead on data-side dependencies.

Essential skills

• 6-10 years in data engineering, with at least one large-scale migration delivered end to end (millions of records).


• Strong Azure Data Lake Storage Gen2, Azure Data Factory, Azure SQL and Azure Functions (C# or Python), with a willingness to write code.


• Data warehousing concepts: dimensional modelling, staging layers, ETL/ELT, data quality and reconciliation.


• Clear communication with senior stakeholders and non-technical data owners.


• Willing to travel to the UK, and to work UK office-hours overlap.

Desirable

• Experience migrating into Salesforce, or from Dynamics or Ellucian.


• Higher education data experience.

Synapse or Databricks. DP-203 or equivalent certification