The Opportunity:
Responsibilities:
Design and develop ETL pipelines using Oracle Integration Cloud (OIC), 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 comprehensive error handling including categorization, automated retries, and reporting dashboards
Build reconciliation processes comparing record counts, key field values, and business rule validations across data stages
Maintain data quality dashboards showing 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 in each cycle
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
Qualifications:
Required:
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 related performance optimization
Knowledge of data quality management: profiling, cleansing, standardization, and validation
Experience with file-based integration formats (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
Oracle Integration Cloud (OIC) certification or strong proficiency with OIC adapters and orchestrations
Hands-on experience with Oracle Fusion HDL and HSDL file specifications
Informatica or Talend certification
Experience with federal HR data standards (e.g., EHRI)
Knowledge of Oracle Fusion HCM business objects and REST API models
Experience developing data quality dashboards with Oracle Analytics Cloud, Power BI, or similar tools
Experience with Oracle Cloud technologies (OIC, OCI) supporting enterprise HCM/ERP environments
What You Can Expect:
A culture of integrity.
At CACI, we place character and innovation at the center of everything we do. As a valued team member, you’ll be part of a high-performing group dedicated to our customer’s missions and driven by a higher purpose – to ensure the safety of our nation.
An environment of trust.
CACI values the unique contributions that every employee brings to our company and our customers - every day. You’ll have the autonomy to take the time you need through a unique flexible time off benefit and have access to robust learning resources to make your ambitions a reality.
A focus on continuous growth.
Together, we will advance our nation's most critical missions, build on our lengthy track record of business success, and find opportunities to break new ground — in your career and in our legacy.
Pay Range:
There are a host of factors that can influence final salary including, but not limited to, geographic location, Federal Government contract labor categories and contract wage rates, relevant prior work experience, specific skills and competencies, education, and certifications. Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives. We offer competitive compensation, benefits and learning and development opportunities. Our broad and competitive mix of benefits options is designed to support and protect employees and their families. At CACI, you will receive comprehensive benefits such as; healthcare, wellness, financial, retirement, family support, continuing education, and time off benefits.
Since this position can be worked in more than one location, the range shown is the national average for the position.
The proposed salary range for this position is:
$75,200-$158,100CACI is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, age, national origin, disability, status as a protected veteran, or any other protected characteristic.
Skills Required
- Must be able to obtain and maintain a Public Trust clearance
- U.S. citizenship
- Bachelor's degree and 5 years of relevant experience, or additional experience substituting for the degree
- 5+ years of enterprise ETL, middleware development, or data integration experience
- 3+ 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 with large-volume batch processing of 100,000+ records and performance optimization
- Knowledge of data quality management, including profiling, cleansing, standardization, and validation
- Experience with CSV, XML, JSON, and enterprise loading specifications
- Familiarity with Agile and SAFe methodologies
- 6+ years of ETL or middleware development supporting HCM or ERP data migration projects
- Oracle Integration Cloud certification or strong proficiency with OIC adapters and orchestrations
- Hands-on experience with Oracle Fusion HDL and HSDL file specifications
- Informatica or Talend certification
- Experience with federal HR data standards such as EHRI
- Knowledge of Oracle Fusion HCM business objects and REST API models
- Experience developing data quality dashboards with Oracle Analytics Cloud, Power BI, or similar tools
- Experience with Oracle Cloud technologies, including OIC and OCI, in enterprise HCM or ERP environments
CACI International Inc Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about CACI International Inc and has not been reviewed or approved by CACI International Inc.
-
Healthcare Strength — Pay is supported by a broad set of health-plan options across multiple national carriers, with telemedicine and tax-advantaged accounts included. Dental and vision choices are also described as multi-option, which strengthens overall coverage breadth.
-
Leave & Time Off Breadth — Flexible Time Off is available for many salaried-exempt roles, while hourly roles accrue PTO, creating multiple time-off pathways by employment class. Paid disability coverage, fixed holidays, and paid leave programs (including parental leave and other leave types) further round out time-off and leave coverage.
-
Retirement Support — Retirement support includes a 401(k) match structure described as 50% up to 8% of pay (effective 4%) and an Employee Stock Purchase Plan with a discount. Tuition reimbursement and certification support also add to the overall rewards package that complements core retirement benefits.
CACI International Inc Insights
What We Do
CACI’s approximately 23,000 talented employees are vigilant in providing the unique expertise and distinctive technology that address our customers’ greatest enterprise and mission challenges. Our culture of good character, innovation, and excellence drives our success and earns us recognition as a Fortune World's Most Admired Company. As a member of the Fortune 1000 Largest Companies, the Russell 1000 Index, and the S&P MidCap 400 Index, we consistently deliver strong shareholder value. Visit us at www.caci.com.
