Senior Data Migration Engineer

NTT
Bengaluru
Workplace: OnsiteFull timeFunction: Solutions Engineering & Sales EngineeringSkills: ["Technical collaboration","Peer code review","Mentoring"]

Design and deliver production-grade data migration pipelines by translating complex Informatica PowerCenter workflows into Python extract/load scripts, dbt transformation models, and Airflow orchestration. Build high-volume ingestion using Python and SQL, implement dbt incremental and snapshot patterns with thorough testing, and develop automated CI/CD with GitLab for deployments. Own end-to-end technical delivery, including performance troubleshooting, data quality validation, and documentation for enterprise-scale migrations.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
NTT
NTT
3 months ago

Senior Data Migration Engineer

✓ 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 migration pipelines by translating complex Informatica PowerCenter workflows into Python extract/load scripts, dbt transformation models, and Airflow orchestration. Build high-volume ingestion using Python and SQL, implement dbt incremental and snapshot patterns with thorough testing, and develop automated CI/CD with GitLab for deployments. Own end-to-end technical delivery, including performance troubleshooting, data quality validation, and documentation for enterprise-scale migrations.
Location: Bengaluru
Workplace: Onsite
Employment Type: Full time
Job Function: Solutions Engineering & Sales Engineering
Seniority: Mid level

Key Responsibilities

  • •Assess Informatica PowerCenter workflows (sessions, mappings, parameterizations) and translate them into equivalent Python EL scripts and dbt models.
  • •Develop and maintain Python EL pipelines to land high-volume data into the target warehouse using SQLAlchemy and database connectivity tools.
  • •Design and build dbt transformation models using Informatica mapping logic, including layering, macros, incremental strategies, and snapshot patterns.
  • •Develop dbt-native tests and custom Python unit tests to validate transformation correctness and data quality.
  • •Create Airflow DAGs to orchestrate Python EL and dbt end-to-end, troubleshooting performance and data discrepancies during SIT and UAT.

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, including production use of parallelism and batch data processing.
  • •5+ years of SQL experience, including complex joins, window functions, and aggregations on large datasets.
Experience:Data migrationETLData pipelinesData warehousing
Skills:Technical collaborationPeer code reviewMentoring
Tech Stack:PythonDbtAirflowInformatica PowerCenterSQLSQLAlchemyCx_OraclePyodbcOracle Data PumpExpdpImpdpSQL 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