HCM Data Migration Middleware Developer
CACI International1 day ago
Base Salary
$75k - $158k/yr
Responsibilities
- Design and develop ETL pipelines using Oracle Integration Cloud, Informatica, Talend, or equivalent tools.
- Create transformation rules that map legacy HR data to Oracle Fusion HCM reference data, value sets, and lookups.
- Build data cleansing, validation, batch-processing, error-handling, retry, and reconciliation processes for large-volume migrations.
- Develop data-quality dashboards and reusable, parameterized transformation templates for repeatable agency migration cycles.
- Partner with PeopleSoft and EBS legacy export teams to define extraction formats and interface specifications.
- Support mock migrations and final cutover loads while resolving data-quality findings.
- Document ETL designs, transformation rules, data flows, and runbooks, and communicate progress and technical issues to stakeholders.
Requirements
- Bachelor’s degree and at least five years of relevant experience; additional experience may substitute for the degree.
- At least five years of enterprise ETL, middleware development, or data integration experience.
- At least three years of hands-on experience with Oracle Integration Cloud, Informatica PowerCenter/Cloud, Talend, or similar platforms.
- Strong SQL proficiency, including complex transformations, validation queries, and reconciliation logic.
- Experience processing 100,000 or more records in batch workloads and optimizing performance.
- Knowledge of data profiling, cleansing, standardization, validation, and data-quality management.
- Experience with CSV, XML, JSON, and enterprise loading specifications.
- Ability to obtain and maintain a Public Trust clearance; US citizenship is required.
- Preferred qualifications include six or more years of ETL or middleware experience in HCM or ERP migrations, Oracle Integration Cloud or Informatica/Talend certifications, Oracle Fusion HDL/HSDL experience, federal HR data standards knowledge, Oracle Fusion HCM business-object and REST API knowledge, and dashboard development experience with Oracle Analytics Cloud or Power BI.
Benefits
- Primarily remote work, with possible onsite reporting in Reston as business needs arise.
- Up to 10% travel within the continental United States.
- Flexible time off, healthcare, wellness, financial, retirement, family support, continuing education, and other time-off benefits.
- Learning and development resources and opportunities for professional growth.
- Regular full-time employment contingent on funding; the position may not be filled immediately.
Tech Stack
Categories
Data Engineering
About CACI International
CACI International is a public government contractor that delivers enterprise IT, cybersecurity, electronic warfare, space, and intelligence solutions to U.S. defense, intelligence, and federal civilian customers. It provides systems engineering, software and data services, and mission support across C4ISR and business systems, primarily through long-term government contracts. Founded in 1962 and headquartered in Reston, Virginia, CACI trades on the NYSE under the ticker CACI.