SEI - Data Migration Engineer (IMS) (Expanded Resources)

NTT
Bengaluru
Workplace: OnsiteFull timeFunction: Solutions Engineering & Sales EngineeringExperience: 5+ yearsSkills: ["Collaboration","Peer feedback","Technical documentation"]

Design and deliver production-grade data migrations by translating Informatica PowerCenter workflows into Python-based extract/load pipelines, dbt transformation models, and Airflow DAG orchestration. Own end-to-end delivery for enterprise-scale migrations, including billion-row data movement, dbt testing and Python unit tests, CI/CD integration on GitLab, and troubleshooting performance and data reconciliation issues during SIT/UAT. Provide code reviews, technical documentation, and handover materials.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
NTT
NTT
1 month ago

SEI - Data Migration Engineer (IMS) (Expanded Resources)

✓ Verified Job

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

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

Job Summary

Design and deliver production-grade data migrations by translating Informatica PowerCenter workflows into Python-based extract/load pipelines, dbt transformation models, and Airflow DAG orchestration. Own end-to-end delivery for enterprise-scale migrations, including billion-row data movement, dbt testing and Python unit tests, CI/CD integration on GitLab, and troubleshooting performance and data reconciliation issues during SIT/UAT. Provide code reviews, technical documentation, and handover materials.
Location: Bengaluru
Workplace: Onsite
Employment Type: Full time
Job Function: Solutions Engineering & Sales Engineering
Seniority: Mid level

Key Responsibilities

  • •Assess Informatica workflows (sessions, mappings, parameterizations) 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 and related tooling, including bulk export methods.
  • •Build dbt transformation models from Informatica mapping logic using best practices such as layering, macros, incremental strategies, and snapshot patterns.
  • •Create dbt-native tests and custom Python unit tests to validate transformation correctness and data quality.
  • •Orchestrate Python EL and dbt scripts with Airflow DAGs end-to-end, perform troubleshooting during SIT/UAT, and support documentation, runbooks, and handover.

Key Requirements

  • •5+ years of Informatica PowerCenter experience with mappings, sessions, workflows, and parameterization.
  • •3+ years of hands-on dbt Core experience, including model layering, macros, tests, and incremental materializations.
  • •Airflow experience with DAG authoring, task dependencies, and scheduling tool integration.
  • •5+ years of Python experience including production parallelism and batch data processing.
  • •5+ years of SQL experience, including complex joins, window functions, and aggregations on large datasets.
Experience:5+ years
Skills:CollaborationPeer feedbackTechnical documentation
Tech Stack:PythonDbtAirflowInformatica PowerCenterSQLSQLAlchemyCx_OraclePyodbcOracle Data PumpSQL Server BCPBULK INSERTOracleSQL ServerGitLab CI/CDGitLabNAS

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