AS400/DB2 Data Migration Engineer Key Responsibilities 1. Assessment &
Discovery • Map the legacy technical landscape by identifying all active databases, tables, logical files, views, and indexes.
Document complex relationships, hidden constraints, triggers, and dependencies embedded in legacy RPG or COBOL code.
Data Cleansing &
Transformation • Design mapping rules to translate legacy AS/400 data types (e.g., converting EBCDIC to ASCII, packed/zoned decimals to standard numbers) into contemporary SQL-based formats.
Create scripts and use modernization tools to eliminate duplicate records, correct data quality issues, and standardize data for the target system.
ETL/ELT Pipeline Development • Build, configure, and maintain robust Extract, Transform, Load (ETL) pipelines to move data smoothly from on-premise DB2/400 to target settings.
Convert legacy physical/logical files to contemporary DDL structures prior to loading.
Validation &
Testing • Oversee schema mapping, data validation, and reconciliation processes to ensure 100% data integrity and accuracy post-migration.
Perform dry runs (mock migrations)



to evaluate pipeline speed and identify potential system bottlenecks without disrupting daily business operations. 5.

Cutover

Strategy &
Decommissioning • Plan the final production cutover strategy, balancing data readiness with minimal business downtime.

Experience
10+ years leading legacy data extraction and migration from AS400 / DB2 and related operational data stores into modern cloud data platforms.
Solid experience assessing historical policy, claims, financial, and 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 source through Silver layer consumption.

Experience Level Mid Level

📌 Anddata Migration Engineer Bengaluru
🏢 NTT DATA Global Delivery Services
📍 Bengaluru