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.
2. 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 modern SQL-based formats.
Create scripts and use modernization tools to eliminate duplicate records, correct data quality issues, and standardize data for the target system.
3. 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 environments.
Convert legacy physical/logical files to modern DDL structures prior to loading.
4. 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.
Strong 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.