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

NTT
Bengaluru
Workplace: OnsiteFull timeFunction: Solutions Engineering & Sales EngineeringSkills: ["Technical delivery","Troubleshooting","Peer collaboration","Attention to data quality","Documentation"]

Design and deliver production-grade data migration solutions that convert complex Informatica PowerCenter workflows into Python extract/load pipelines, dbt transformations, and Airflow orchestration. Own end-to-end delivery at enterprise scale, including high-volume data movement, dbt testing and validation, performance and data discrepancy troubleshooting during SIT/UAT, and producing documentation, runbooks, and peer review feedback.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
NTT
NTT
2 months ago

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

✓ Verified Job

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

Source: Company careers pageValidated by: Fursa AI
Last checked: 21 hours agoStatus: Live
Reposted: similar role first listed 2 months ago

Job Summary

Design and deliver production-grade data migration solutions that convert complex Informatica PowerCenter workflows into Python extract/load pipelines, dbt transformations, and Airflow orchestration. Own end-to-end delivery at enterprise scale, including high-volume data movement, dbt testing and validation, performance and data discrepancy troubleshooting during SIT/UAT, and producing documentation, runbooks, and peer review feedback.
Location: Bengaluru
Workplace: Onsite
Employment Type: Full time
Job Function: Solutions Engineering & Sales Engineering
Seniority: Mid level

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.
  • •Build dbt transformation models from Informatica mapping logic, applying best practices like layering, macros, incremental strategies, and snapshot patterns.
  • •Orchestrate Python EL and dbt scripts with Airflow DAGs to produce functionally equivalent outputs.
  • •Validate and troubleshoot end-to-end delivery using dbt-native tests and Python unit tests, and handle performance/data discrepancy issues during SIT/UAT with reconciliation.

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.
  • •3+ years of Airflow experience including DAG authoring and task dependencies.
  • •5+ years of Python experience with production use of parallelism and batch data processing.
  • •5+ years of SQL experience including complex joins, window functions, and aggregations across large datasets.
Experience:Data migrationETLData warehousingEnterprise dataLarge-scale migrationOffshore delivery
Skills:Technical deliveryTroubleshootingPeer collaborationAttention to data qualityDocumentation
Tech Stack:PythonDbtAirflowInformatica PowerCenterSQLSQLAlchemyCx_OraclePyodbcOracle Data PumpExpdpImpdpSQL Server BCPBULK INSERTGitLabCI/CDNASOracleSQL Server

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