Submitting more applications increases your chances of landing a job.
Here’s how busy the average job seeker was last month:
Opportunities viewed
Applications submitted
Keep exploring and applying to maximize your chances!
Looking for employers with a proven track record of hiring women?
Click here to explore opportunities now!You are invited to participate in a survey designed to help researchers understand how best to match workers to the types of jobs they are searching for
Would You Be Likely to Participate?
If selected, we will contact you via email with further instructions and details about your participation.
You will receive a $7 payout for answering the survey.
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.
You'll no longer be considered for this role and your application will be removed from the employer's inbox.