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