NTT

3 weeks 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: 20 hours agoStatus: Live

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

Website LinkedIn

Loading job details...

Preparing the role view and application actions.

NTT