QA Tester​/Data Conversion Tester

QA Tester / Data Conversion Tester

We are seeking an experienced QA Tester / Data Conversion Tester to support the SAMII to MOVERS Database Conversion Project.

The selected resource will be responsible for validating the conversion of financial, HR, and payroll data from the legacy SAMII DB2 z/OS environment into the MOVERS Oracle environment. The QA Tester will work closely with developers, business partners, project SMEs, and technical teams to verify that converted data meets source-to-target mapping requirements, business rules, and data quality standards.

The ideal candidate will have strong experience in Quality Assurance Testing, SQL, DB2 z/OS, mainframe environments, data validation, reconciliation, and complex ERP data conversion projects.

Experience working with financial, HR, and payroll ERP systems at a state government or equivalent organizational level is required.

Quality Assurance

Experience:

• 5+ years of experience in Quality Assurance Testing
• Experience testing complex data conversion, data migration, or ETL processes
• Experience validating data between source and target systems
• Experience creating and executing detailed test cases, test scenarios, and validation scripts
• Experience identifying, documenting, tracking, and retesting defects
• Experience performing data reconciliation and data integrity testing

Technical

Experience:

• Strong experience with SQL
• Strong experience with DB2 for z/OS
• Mainframe environments
• Data validation and reconciliation
• Source-to-target data mapping
• Financial, HR, and payroll data

Working knowledge or experience with the following is highly desirable:

• JCL
• COBOL
• Oracle databases
• DB2 performance concepts
• Mainframe batch processing

The QA Tester will be responsible for testing and validating the conversion of SAMII DB2 data to MOVERS Oracle requirements based on mapping templates and specifications provided by the MOVERS project team SMEs.

Responsibilities include:

• Review business requirements, technical specifications, and source-to-target data mapping documents.
• Develop comprehensive test plans, test cases, test scenarios, and test scripts for data conversion activities.
• Validate data extracted from SAMII DB2 against MOVERS Oracle target requirements.
• Execute SQL queries against source and target databases to verify data accuracy.
• Perform record-count, field-level, transformation, reconciliation, and business-rule validation.
• Verify that data conversion programs correctly transform SAMII data according to approved mapping templates.
• Validate financial, HR, payroll, accounting, and related ERP data.
• Identify missing, duplicate, invalid, incorrectly transformed, or inconsistent data.
• Analyze complex data issues and clearly communicate data nuances and discrepancies.
• Verify relationships and dependencies between converted datasets.
• Perform positive, negative, regression, integration, and end-to-end testing as required.
• Support multiple conversion test cycles and production readiness activities.
• Validate defect fixes and perform regression testing after changes are implemented.
• Collaborate with developers and SMEs to troubleshoot data conversion issues.
• Participate in defect review and resolution meetings.
• Assist with conversion reconciliation and sign-off activities.
• Maintain accurate testing documentation and evidence.

The QA resource will specifically support the conversion of DB2 data from SAMII into MOVERS Oracle based upon mapping templates provided by the MOVERS project team SMEs.

Testing activities may include:

• Source-to-target validation
• Data mapping validation
• Data transformation testing
• Field-level validation
• Record-count reconciliation
• Financial balance reconciliation
• Payroll data validation
• Null and default-value testing
• Duplicate data validation
• Referential integrity testing
• Historical data validation
• Boundary and exception testing
• Batch process validation
• Error and reject validation
• Conversion performance validation
• Post-conversion data verification

The QA Tester must be able to understand and discuss subtle differences in source and target data and determine whether identified differences represent expected…