Data Migration Engineer (Fall 2026)

NTT
Karnataka
Workplace: RemoteFull timeFunction: Software EngineeringSkills: ["Peer review","Technical feedback","Troubleshooting","Data quality validation"]

Assess and translate Informatica workflows (sessions, mappings, parameterizations) into Python EL scripts and dbt transformation models that replicate source logic. Build and optimize high-volume data pipelines into the target warehouse using SQLAlchemy, cx_Oracle, pyodbc, and bulk export tools (Oracle Data Pump, SQL Server BCP). Orchestrate end-to-end execution with Airflow DAGs, support CI/CD with GitLab, and validate with dbt and Python tests, troubleshooting during SIT/UAT.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
NTT
NTT
1 week ago

Data Migration Engineer (Fall 2026)

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Last checked: 15 hours agoStatus: Live

Job Summary

Assess and translate Informatica workflows (sessions, mappings, parameterizations) into Python EL scripts and dbt transformation models that replicate source logic. Build and optimize high-volume data pipelines into the target warehouse using SQLAlchemy, cx_Oracle, pyodbc, and bulk export tools (Oracle Data Pump, SQL Server BCP). Orchestrate end-to-end execution with Airflow DAGs, support CI/CD with GitLab, and validate with dbt and Python tests, troubleshooting during SIT/UAT.
Location: Karnataka
Workplace: Remote
Employment Type: Full time
Job Function: Software Engineering

Key Responsibilities

  • •Assess complex Informatica workflows and translate them into equivalent Python EL scripts and dbt transformation models.
  • •Develop and maintain Python EL pipelines to land high-volume data into the target warehouse using SQLAlchemy, cx_Oracle, pyodbc, and bulk export tools.
  • •Design and develop dbt transformation models based on Informatica mapping logic, applying best practices like model layering, macros, incremental strategies, and snapshots.
  • •Build dbt-native tests and custom Python unit tests to validate transformation correctness and data quality.
  • •Orchestrate end-to-end execution with Airflow DAGs and contribute to GitLab CI/CD for dbt and Airflow code, including linting, testing, and deployment.

Key Requirements

  • •Experience assessing Informatica workflows (sessions, mappings, parameterizations) and translating them into equivalent transformation logic.
  • •Strong Python development for EL-style pipelines for high-volume data loads into a target warehouse.
  • •Hands-on dbt model development, including layering, macros, incremental strategies, and snapshot patterns.
  • •Ability to implement data quality validation using dbt-native tests and custom Python unit tests.
  • •Experience orchestrating pipelines using Airflow DAGs and collaborating via GitLab CI/CD with testing and deployment workflows.
Skills:Peer reviewTechnical feedbackTroubleshootingData quality validation
Tech Stack:InformaticaPythonELDbtSQLAlchemyCx_OraclePyodbcSQLOracle Data PumpSQL Server BCPAirflowGitLabCI/CDSQL queriesUnit testingDbt testsMacrosIncremental modelsSnapshot patterns

Company Brief

NTT
Dimension Data, operating under NTT Ltd, provides managed IT services, cloud and data center solutions, networking, cybersecurity, and digital transformation services to enterprise customers worldwide.
Industry: Professional Services
Company Size: Enterprise (1,001+ employees)
Revenue: USD 1B+
Growth: Established Company
Valuation: Public Company (Market Cap in USD)
Headquarters: London, United Kingdom
Founded: 1983
WebsiteLinkedIn