AS400/DB2 Data Migration Engineer

JOB DESCRIPTION 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-pre