Mainframe Data Conversion Developer

Mainframe/Data Conversion DeveloperWe are seeking an experienced Mainframe/Data Conversion Developer to support the SAMII to MOVERS Database Conversion Project. The selected resource will be responsible for converting financial, HR, and payroll-related data from the legacy Missouri SAMII DB2 environment into the MOVERS Oracle database based on data mapping templates and conversion requirements provided by the MOVERS project team and Subject Matter Experts (SMEs).The ideal candidate will have extensive experience with JCL, COBOL, DB2 z/OS, SQL, data conversion, and Quality Assurance testing, preferably within a state government financial, HR, or payroll ERP environment.This position requires strong technical analysis skills, attention to data quality and nuances, and the ability to work effectively with both technical teams and business stakeholders.Required Experience and QualificationsCandidates must have experience working with financial, HR, and payroll ERP systems at a state government or equivalent organizational level.Technical ExperienceMinimum 7+ years of experience with the following:JCL (Job Control Language)DB2 for z/OS, including database performance knowledge and optimizationSQLCOBOLMinimum 5+ years of experience in:Quality Assurance TestingData validation and reconciliationTesting complex data conversion or migration processesRequired SkillsThe successful candidate must demonstrate:Experience working with complex and ambiguous technical and business scenariosStrong ability to analyze and resolve data conversion issuesExperience communicating effectively with business partners, SMEs, developers, testers, and project stakeholdersAbility to identify, analyze, and clearly discuss data nuances, anomalies, dependencies, and discrepanciesStrong troubleshooting and problem-solving skillsExperience interpreting source-to-target data mapping specificationsAbility to validate converted data against business and technical requirementsStrong documentation skillsAbility to manage assigned work independently while collaborating with a larger project teamPreferred SkillsThe following experience is strongly preferred:Accounting knowledgePayroll knowledgePrevious experience supporting Missouri SAMIIExperience with financial and accounting data conversionExperience with HR and payroll data conversionExperience migrating data from DB2/Mainframe environments to OracleExperience working on large-scale government ERP modernization or system replacement projectsFamiliarity with Oracle database structures and data requirementsKey ResponsibilitiesThe selected resource will:Convert DB2 data from the Missouri SAMII system to MOVERS Oracle requirements.Perform data conversion activities according to mapping templates and specifications provided by MOVERS project team SMEs.Analyze existing SAMII DB2 data structures, business rules, and data and maintain COBOL, JCL, SQL, and DB2-based programs/processes required to extract, transform, validate, and prepare data for conversion.Review source-to-target mapping documents and translate business requirements into technical conversion logic.Identify data anomalies, exceptions, inconsistencies, and other nuances that could impact conversion.Collaborate with MOVERS project SMEs and business partners to clarify mapping requirements and resolve data-related questions.Perform data reconciliation and validation to ensure converted data is complete, accurate, and aligned with MOVERS Oracle requirements.Conduct and support Quality Assurance testing of conversion processes and converted conversion failures, data discrepancies, performance issues, and technical defects.Optimize DB2 queries and conversion processes when necessary to support performance requirements.Participate in conversion testing cycles, defect resolution, and production conversion activities.Maintain clear technical documentation for conversion programs, mappings, testing results, issues, and resolutions.JIRA and Documentation RequirementsJIRA will be used to manage tasks, issues, defects, and project assignments.The resource will be responsible for:Reviewing and completing assigned tasks through JIRAEntering and tracking issues within JIRAProviding timely status updates for assigned workDocumenting technical analysis, changes, testing activities, and resolutionsRecording all implemented changes as comments within the applicable JIRA ticket for each assigned taskWorking with project team members to resolve JIRA issues and defects through completionIdeal Candidate ProfileThe ideal candidate is a senior-level mainframe and database professional who has supported complex ERP environments involving financial, accounting, HR, and payroll data. The candidate should be comfortable working with legacy mainframe systems while supporting a large-scale migration to a modern Oracle-based experience with Missouri SAMII and familiarity with its financial and payroll data structures would be a significant advantage.Mandatory Skills SummarySkill / Experience - RequirementJCL - 7+ yearsDB2 z/OS - 7+ yearsDB2 Performance Knowledge - 7+ years preferred within DB2 experienceSQL - 7+ yearsCOBOL - 7+ yearsQuality Assurance Testing - 5+ yearsFinancial/HR/Payroll ERP Experience - RequiredState Government or Equivalent Enterprise Experience - RequiredComplex Data Conversion / Migration - RequiredBusiness Partner Communication - RequiredData Analysis / Data Nuance Identification - RequiredAccounting Knowledge - Strongly PreferredPayroll Knowledge - Strongly PreferredMissouri SAMII Experience - Strongly PreferredJIRA - Required for task and issue managementWork Location RequirementThis position is 100% onsite. Candidates must be able and willing to work onsite for the duration of the engagement. Remote or hybrid work is not available for this position.