This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
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. 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. 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. 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. Plan the final production cutover strategy, balancing data readiness with minimal business downtime.
Job Responsibility
Assessment & Discovery
Data Cleansing & Transformation
ETL/ELT Pipeline Development
Validation & Testing
Cutover Strategy & Decommissioning
Requirements
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