HCM Data Migration Middleware Developer

🔥 1 minute ago

🇺🇸 United States – Remote

💵 $75.2k - $158.1k / year

⏰ Full Time

🟡 Mid-level

🟠 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 using Oracle Integration Cloud, Informatica, Talend, or equivalent tools • Create transformation rules mapping legacy HR values to Oracle Fusion HCM reference data, value sets, and lookups • Build data cleansing pipelines to resolve missing fields, invalid formats, duplicate data, and referential integrity issues • Implement scalable batch-processing frameworks with configurable parallelism and restart/recovery capabilities • Develop error handling with categorization, automated retries, and reporting dashboards • Build reconciliation processes across data stages • Maintain data quality dashboards for pipeline status, error rates, completeness, and reconciliation metrics • Design reusable transformation templates and parameterized mappings for repeatable agency migration cycles • Partner with PeopleSoft/EBS legacy export teams to define extraction formats and interface specifications • Support iterative mock migrations and final cutover loads, resolving data quality findings • Document ETL designs, transformation rules, data flows, and runbooks following SAFe Agile standards • Independently resolve functional and technical issues of moderate scope and contribute to team knowledge bases • Communicate progress, technical approaches, and issue resolution to stakeholders and Agile Release Train partners • Support Oracle Fusion Cloud HCM modernization for federal civilian agencies, transforming legacy HR data into HDL and HSDL formats

🎯 Requirements

• Must be able to obtain and maintain a Public Trust clearance • US Citizenship required • Bachelor’s degree and 5 years of relevant experience; additional experience may substitute for degree • 5+ years of enterprise ETL, middleware development, or data integration experience • 3+ years hands-on experience with OIC, Informatica PowerCenter/Cloud, Talend, or similar platforms • Strong SQL proficiency, including complex transformations, validation queries, and reconciliation logic • Experience with large-volume batch processing (100,000+ records) and performance optimization • Knowledge of data quality management: profiling, cleansing, standardization, and validation • Experience with CSV, XML, JSON, and enterprise loading specifications • Familiarity with Agile/SAFe methodologies • Desired: 6+ years ETL/middleware development experience supporting HCM or ERP data migration projects • Desired: Oracle Integration Cloud certification or strong proficiency with OIC adapters and orchestrations • Desired: Hands-on experience with Oracle Fusion HDL and HSDL file specifications • Desired: Informatica or Talend certification • Desired: Experience with federal HR data standards such as EHRI • Desired: Knowledge of Oracle Fusion HCM business objects and REST API models • Desired: Experience developing data quality dashboards with Oracle Analytics Cloud, Power BI, or similar tools • Desired: Experience with Oracle Cloud technologies, including OIC and OCI, supporting enterprise HCM/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