Data Migration/ETL Engineer
Core
Design, develop, and execute enterprise-scale data migration processes and ETL pipelines for federal government clients, ensuring data completeness, accuracy, and security.
Role type
Senior Data Migration/ETL Engineer
Builds
Obfuscated datasets, non-production data environments, and production data migrations for HCM/ERP platforms
Domain
Federal Government / Human Capital Management (HCM) / Enterprise Resource Planning (ERP)
Deliverable
production ML models | product features | dashboards & analysis | infrastructure
Required skills
ETL development, SQL, data transformation, data cleansing, data mapping, validation testing, reconciliation, error handling, secure file ingestion (SFTP), cloud HCM/ERP loading
Preferred skills
Oracle HCM Data Loader (HDL), PeopleSoft HCM extraction, Workday extraction, mainframe/COBOL HR systems, federal HR data, EHRI familiarity, large-volume PII handling
Technologies
SFTP, Oracle HCM, PeopleSoft, Workday, COBOL, Cloud HCM/ERP platforms
Responsibilities
Design and develop ETL processes and data pipelines using approved schemas. Develop client-specific obfuscated datasets meeting data protection standards. Execute data migration test cases and scripts validating completeness and accuracy. Perform data cleansing and mapping against client data standards. Support secure file-based ingestion from legacy systems. Execute production migration and support reconciliation and post-migration audit.
Seniority
Senior, hands-on IC