Payroll Data Conversion and Migration

Job Title: Payroll Data Conversion and MigrationJob Category: Information TechnologyTime Type: Full timeMinimum Clearance Required to Start: NoneEmployee Type: RegularPercentage 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,200CACI 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.Department:Data Analytics