NTT

1 month ago

AS400/DB2 Data Migration Engineer

✓ Verified Job

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

Source: Company careers pageValidated by: Fursa AI

Last checked: 4 hours agoStatus: Live

Job Summary

Lead end-to-end migration of legacy AS/400 and DB2 data into modern SQL-based cloud environments. You will map legacy database structures and hidden dependencies, design cleansing and transformation rules (including code page/format conversions), build ETL/ELT pipelines, and validate/reconcile data for 100% integrity. Plan production cutover strategies with minimal downtime, including dry runs and decommissioning activities.

Location: Bengaluru

Workplace: Onsite

Employment Type: Full time

Job Function: Data Analytics & Business Intelligence

Seniority: Mid level

Key Responsibilities

•Map the legacy technical landscape by identifying active databases, tables, logical files, views, and indexes.
•Document complex relationships, constraints, triggers, and dependencies embedded in legacy RPG or COBOL code.
•Design data cleansing and transformation mapping rules, including conversions from EBCDIC to ASCII and numeric format standardization.
•Build, configure, and maintain ETL pipelines to move data from on-premise DB2/400 to target environments, including DDL conversion prior to loading.
•Oversee validation, reconciliation, and production cutover strategy, including dry runs to evaluate performance and minimize downtime.

Key Requirements

•10+ years leading legacy data extraction and migration from AS400/DB2 into modern cloud data platforms.
•Strong experience assessing historical policy/claims/financial/reference data for archival migration, conformance, and reporting continuity.
•Proven track record defining migration waves, data quality treatment, reconciliation logic, and controls between legacy sources and Guidewire target-state data.
•Ability to design bulk and incremental extraction patterns, historical backfill strategy, code page/format handling, and exception management.
•Experience partnering with business SMEs to preserve reporting history, regulatory traceability, and lineage from legacy sources through Silver layer consumption.

Experience:10+ years

Tech Stack:AS/400DB2ETLELTSQLRPGCOBOLDDLEBCDICASCIIPacked decimalsZoned decimalsOn-premiseCloud data platformsGuidewireSilver layerData reconciliationData validation

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