Payroll Data Conversion and Migration

CACI International Inc; New Orleans (LA); Hybrid; USD 72,000 - 150,000; Full time

Job summary

CACI International Inc. is seeking a Payroll Data Conversion and Migration professional to analyze legacy payroll data, map source-to-target data, and build ETL routines for a cloud-based payroll implementation in the United States.

The role covers data profiling, conversion lifecycle, and cutover activities with remote work from within the U.S. and periodic on-site as needed. A Bachelor's degree and 5+ years in data conversion are required.

Qualifications

• Must be a U.S. Citizen and able to obtain Public Trust clearance.
• Work is performed within the United States and its territories.
• Bachelor's degree plus 5 years of relevant experience.
• 5+ years in data conversion/migration on large enterprise implementations.
• Experience managing full conversion lifecycle from profiling to cutover.
• Experience creating field-level source-to-target mappings (version-controlled).
• Ability to work with undocumented schemas and derive structure empirically.
• Experience COBOL copybooks or fixed-width data is a plus.

Responsibilities

• Perform source data analysis and profiling of legacy payroll, reference and accounting data.
• Develop and maintain source-to-target data mapping specifications.
• Develop ETL routines using Oracle HCM data loading tools.
• Conduct data quality assessments and prepare data cleansing specifications.
• Execute mock conversion cycles and document results and defects.
• Perform data reconciliation and validation between source and target systems.
• Analyze and resolve conversion defects with Government data owners.
• Support conversion cutover activities and post-conversion validation.

Skills

US Citizenship

Public Trust clearance

SQL proficiency

Data profiling

Data mapping

Data reconciliation

ETL tooling

Data migration

Schema exploration

COBOL reading

Education

Bachelor's degree

5+ years data conversion experience

Tools

Oracle HDL/HSDL/HCM Extracts

PeopleSoft/Oracle/EBS/SAP payroll knowledge

PL/SQL

Job description

Job Title: Payroll Data Conversion and Migration

Job Category: Information Technology

Time Type: Full time

Minimum Clearance Required to Start: None

Employee Type: Regular

Percentage of Travel Required: Up to 25%

Type of Travel: Continental US

* * *

The Opportunity

A Federal shared services provider delivers payroll for approximately 605,000 Federal employees across more than 150 agencies. To address inefficiencies in fragmented and aging payroll systems, it is implementing a scalable, cloud-based payroll solution that improves automation, data quality, user experience and compliance, with implementation for the full customer base targeted within eighteen months.

This position supports the core implementation call order, which covers discovery and fit-gap analysis, solution design and configuration, data migration, interface development, testing and parallel payroll validation, and cutover through hypercare. In this role you will analyze the legacy payroll data, develop source-to-target mappings and conversion routines, and reconcile converted data against source through successive mock conversion cycles and conversion cutover.

Work is performed remotely from within the United States, with periodic on-site presence as the assignment requires.

Responsibilities

• Perform source data analysis and profiling of legacy payroll, reference and accounting data
• Develop and maintain source-to-target data mapping specifications
• Develop extract, transform and load routines using Oracle HCM data loading tools
• Perform data quality assessment and prepare data cleansing specifications
• Execute mock conversion cycles and document conversion results and defect disposition
• Perform data reconciliation and validation between source and target systems
• Analyze and resolve conversion defects and coordinate remediation with Government data owners
• Support conversion cutover activities and post-conversion validation

Qualifications

Required:

• Must be a U.S. Citizen and able to obtain and maintain a Public Trust clearance
• All work is performed from within the United States and its territories, from a work location approved in advance by the customer
• Bachelor's degree and 5 years of relevant experience. Additional experience may be substituted for degree.
• 5 or more years in data conversion or data migration on enterprise system implementations, including advanced SQL against large datasets
• Experience carrying a complete conversion lifecycle from source profiling through post-load reconciliation and cutover, rather than a single segment of one
• Experience producing and maintaining field-level source-to-target mapping as a version-controlled specification
• Experience reconciling converted data against source to tolerance agreed with a client in advance, and investigating variances to root cause
• Demonstrated ability to work productively against an undocumented schema, establishing structure and content empirically

Desired

• Ability to read COBOL copybooks or work with fixed-width and positional data, or experience extracting from a non-relational mainframe source — the highest-value skill on this requisition
• Oracle Fusion HCM conversion tooling — HCM Data Loader (HDL), HCM Spreadsheet Data Loader (HSDL), HCM Extracts
• Conversion of HR or payroll data specifically — pay history, leave balances, retirement service history, benefits elections, deductions, year-to-date accumulators
• Conversion experience to PeopleSoft Payroll for North America, PeopleSoft Global Payroll, Oracle E-Business Suite (EBS) HRMS or SAP Payroll; PL/SQL, enterprise ETL tooling, or Python for profiling and reconciliation

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.

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.

The Proposed Salary Range For This Position Is

$71,500 - $150,200

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.