Data Migration, Conversion Specialist

• Design and execute end-to-end data migration strategies from legacy federal HR systems into Oracle Fusion Cloud HCM
• Develop ETL/ELT pipelines, mapping documentation, and transformation rules using HDL and HSDL templates
• Profile, detect anomalies in, and cleanse large-volume HR datasets
• Build data cleansing routines to standardize values, remove duplicates, and align with EHRI and eOPF requirements
• Lead mock conversions, dress rehearsals, and production cutover for agencies of varying complexity
• Conduct parallel payroll validation to ensure zero variance between legacy and Oracle payroll outputs
• Create and maintain runbooks, data dictionaries, reconciliation reports, and conversion specifications
• Develop automated validation and reconciliation scripts
• Partner with federal HR policy teams on employee status, SCDs, eligibility markers, and personnel action history
• Coordinate with integration teams to support downstream HR interfaces
• Support data governance, issue resolution, and quality metric reporting
• Independently resolve moderate technical and functional issues
• Provide progress updates and support collaborative problem-solving within Agile and SAFe project structures

• Ability to obtain and maintain a Public Trust clearance
• U.S. Citizenship required
• Bachelor’s degree and 5 years of relevant experience; additional experience may substitute for degree
• 5+ years of data migration, data conversion, or ETL development experience
• 3+ years of hands-on migration experience into Oracle Fusion Cloud HCM, Oracle ERP Cloud, or similar enterprise cloud platforms using HDL, HSDL, or FBDI
• Proficiency in SQL
• Experience profiling and cleansing large datasets of 100K+ records
• Experience with ETL technologies such as ODI, Informatica, Talend, or Python-based pipelines
• Strong understanding of HR data domains
• Experience working within Agile or SAFe delivery teams
• Up to 10% travel may be required
• Desired: 6+ years of data migration experience, including large-scale Oracle Fusion Cloud HCM implementations
• Desired:
  Hands-on experience with HDL/HSDL templates and BI Publisher
• Desired:
  Experience migrating from federal HR systems
• Desired:
  Knowledge of EHRI, eOPF, SF-50, and federal reporting requirements
• Desired:
  Experience with parallel payroll validation methodologies
• Desired:
  Proficiency in Python or R
• Desired:
  Oracle OCI Data Integration or Oracle Data Integrator certification
• Desired:
  Experience with Oracle Integration Cloud or Oracle Cloud Infrastructure

Demonstrates expertise in data migration strategies, particularly into Oracle Fusion Cloud HCM, with a strong focus on ETL development, data cleansing, and validation processes. Proficient in managing large datasets and collaborating within Agile project environments to ensure data integrity and compliance with federal HR standards.

• Data Migration Experience
• Oracle Fusion Cloud HCM Expertise
• ETL Development Proficiency
• SQL Proficiency
• HR Data Domain Knowledge

• Data Migration
• ETL Development
• Data Cleansing
• SQL
• Data Profiling
• Data Validation
• Data Transformation
• Data Integration
• Parallel Payroll Validation
• Data Governance

• Collaborative Problem-Solving
• Communication
• Leadership

• Oracle OCI Data Integration Certification

• Federal HR Systems
• EHRI
• EOPF
• SF-50
• Agile
• SAFe
• Data Governance
• Quality Metric Reporting

• Oracle Fusion Cloud HCM
• Oracle ERP Cloud
• HDL
• HSDL
• Informatica
• Talend
• Python
• Oracle Integration Cloud
• Oracle Cloud Infrastructure
• Oracle Data Integrator