Senior HCM Data Migration Middleware Developer

🔥 1 hour ago

🇺🇸 United States – Remote

💵 $90.3k - $189.6k / year

⏰ Full Time

🟠 Senior

🚰 Data Engineer

👻 Ghost score 0%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

CACI International Inc

WebsiteLinkedInAll Job Openings

10,000+ employees

Founded 1962

🎖️ Defense

🏛️ Government

🔒 Cybersecurity

🔥 Funding within the last year

💰 $500M Post-IPO Debt on 2026-02

Defense • Government • Cybersecurity

CACI International Inc is a U. S. -based government contractor that provides technologies and professional services to national security, defense, and federal civilian customers. CACI delivers solutions across cyber and digital operations, enterprise IT modernization, electronic warfare, counter-unmanned systems (C-UxS), space and optical communications, agile DevSecOps software development, and mission engineering and logistics support. The company positions itself as a large prime contractor that uses advanced software, analytics, sensing, and hardware to detect and counter evolving threats and modernize government technology architectures.

📋 Description

• Design, develop, and maintain ETL pipelines and middleware for federal HCM data migration • Transform legacy HR data into Oracle Fusion HCM HDL and HSDL load file formats • Map legacy codes, descriptions, and hierarchies to Oracle Fusion HCM reference data, value sets, and lookup values • Build data cleansing pipelines to remediate missing fields, invalid dates, duplicate records, and referential integrity violations • Implement batch processing frameworks for large-volume agency migrations with parallelism and restart/recovery capabilities • Develop error handling, exception management, retry logic, and error reporting dashboards • Develop reconciliation processes comparing source records, transformation outputs, and target loaded records • Create and maintain data quality dashboards for pipeline status, error rates, completeness, and reconciliation results • Design reusable transformation templates and parameterized mapping configurations • Collaborate with PeopleSoft/EBS legacy export developers on file formats, handoffs, and interface specifications • Support 3–4 mock migration cycles per agency and final cutover data loads • Document ETL designs, transformation rules, data flows, and operational runbooks according to SAFe Agile standards • Analyze and resolve complex functional and technical issues independently • Serve as a technical resource and mentor for less experienced team members • Lead small work efforts and technical initiatives, conduct technical reviews, and guide junior consultants on Oracle Fusion Cloud HCM practices

🎯 Requirements

• Bachelor's degree and 7 years of relevant experience; additional experience may be substituted for degree • 7+ years of experience in ETL development, middleware development, or data integration for enterprise system implementations • 5+ years of hands-on experience with Oracle Integration Cloud (OIC), Informatica PowerCenter/Cloud, Talend, or equivalent data integration platforms • Strong SQL proficiency, including complex transformation queries, data validation scripts, and reconciliation procedures • Experience with batch data processing for large-volume datasets of 100,000+ records • Experience with performance optimization, error handling, and restart/recovery design patterns • Knowledge of data profiling, cleansing, standardization, and validation • Experience with CSV, XML, JSON, and enterprise data loader specifications • Familiarity with Agile/SAFe development methodologies and iterative delivery practices • Must be able to obtain and maintain a Public Trust clearance • US Citizenship required • Desired: 8+ years of ETL/middleware development experience with HCM or ERP data migration projects • Desired: Oracle Integration Cloud certification or demonstrated OIC proficiency • Desired: Direct experience with Oracle Fusion HCM Data Loader (HDL) and HCM Spreadsheet Data Loader (HSDL) • Desired: Informatica PowerCenter/Cloud or Talend certification • Desired: Federal government HR data migrations, EHRI data standards, and federal personnel data formats • Desired: Oracle Fusion HCM business object structures and REST API data models • Desired: Data quality dashboards using Oracle Analytics Cloud, Power BI, or equivalent tools • Desired: Oracle Cloud technologies, including OIC and/or OCI, in enterprise HCM or ERP environments

🏖️ Benefits

• Flexible time off benefit • Robust learning resources • Healthcare benefits • Wellness benefits • Financial benefits • Retirement benefits • Family support benefits • Continuing education benefits • Time off benefits • Competitive compensation • Learning and development opportunities