Data Migration & Conversion Specialist

Job Title: Data Migration & Conversion Specialist

Job Category: Information Technology

Time Type: Full time

Minimum Clearance Required to Start: None

Employee Type: Regular

Percentage of Travel Required: Up to 10%

Type of Travel: Continental US

* * *

The Opportunity:

CACI is seeking Data Migration & Conversion Specialists to support a transformational federal HCM modernization program. This initiative involves migrating HR data from diverse legacy systems to Oracle Fusion Cloud HCM for a large federal civilian workforce.  You will extract, transform, and load HR data from legacy platforms including PeopleSoft, mainframe/GOTS systems, and other HRIS solutions. This role requires strong ETL skills, attention to data quality, and understanding of HR data structures.  We are seeking specialists with experience in various source systems to join our Data Migration team and ensure successful, high-quality data conversions.

Responsibilities:

• Analyze legacy system data structures and develop data mapping specifications to Oracle Fusion HCM

• Design and develop ETL processes for extracting data from PeopleSoft, mainframe, and other legacy systems

• Transform legacy data to conform to Oracle HDL/HSDL file specifications

• Execute data quality assessments and develop cleansing rules for migration readiness

• Build and maintain data validation scripts to ensure conversion accuracy

• Support iterative mock conversions, analyzing results and refining transformation logic

• Develop reconciliation reports comparing source and target data

• Document data lineage, transformation rules, and conversion procedures

• Collaborate with functional teams to resolve data quality issues and mapping decisions

• Support cutover activities including final data extraction and production loading

• Create data migration runbooks and operational documentation

Qualifications:

Required:

• Bachelor's degree in Computer Science, IT, or related field + 4 years experience (additional experience may substitute)

• 3+ years experience with data migration or ETL development

• Proficiency in SQL and at least one ETL tool (Informatica, SSIS, Talend, or similar)

• Experience extracting data from at least one: PeopleSoft, mainframe/COBOL, Workday, or similar HRIS

• Strong data analysis and quality assessment skills

• Experience with Oracle HDL or similar bulk data loading tools

• Must be able to obtain and maintain a Public Trust clearance (US Citizenship required)

Desired:

• 6+ years data migration experience (for Senior/Lead positions)

• Oracle HCM Cloud data migration experience (HDL, HSDL, PBL)

• PeopleSoft HCM technical experience

• Mainframe/COBOL data extraction experience

• Experience with federal HR data (personnel records, benefits, payroll)

• Oracle Data Management (DM) Accelerator experience

• Python, PowerShell, or other scripting for data manipulation

• Active Secret clearance or higher

This position is contingent on funding and may not be filled immediately. However, this position is representative of positions within CACI that are consistently available. Individuals who apply may also be considered for other positions at CACI.

_________________________________________________________________________

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.

Your potential is limitless. So is ours.

_________________________________________________________________________

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:

$63,300-$129,700

CACI 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.