A technology services company in Phoenix is seeking candidates to execute data validation tests, leveraging SQL, JCL, and SORT utilities for ensuring accurate data migration. The ideal applicant will have strong skills in mainframe systems and experience in data verification. Responsibilities include identifying and reporting defects, along with applying foundational migration testing knowledge. This role offers a chance to work on critical projects with a dedicated team.
Qualifications
Strong understanding of mainframe systems.
Familiarity with Job Control Language (JCL).
Experience in using SORT utilities for data manipulation.
Responsibilities
Execute structured data validation tests for migration.
Leverage JCL and SORT utilities to extract and validate data.
Apply SQL for validating data integrity.
Skills
Mainframe
JCL
SORT
SQL
Job description
Overview
JOB DESCRIPTION: This one: need strong SQL ANY STATE/GOVERNMENT WILL BE A PLUS.
Responsibilities
Execute Data Validation Tests: Perform structured testing to ensure accurate migration of data from mainframe systems to modern platforms, using methods like record counts, field-level comparisons, and reconciliation reports
Leverage JCL and SORT Utilities: Use Job Control Language (JCL) and SORT tools to extract, manipulate, and validate data during migration cycles, supporting batch job testing and troubleshooting
Apply SQL for Data Verification: Run basic SQL queries to validate data integrity in target systems, ensuring correct mapping and transformation from legacy formats
Identify and Report Defects: Log discrepancies such as missing records, format mismatches, or transformation errors, and escalate issues to senior engineers or developers for resolution
Understand Migration Testing Methods: Apply foundational knowledge of data migration testing strategies, including pre-migration checks, post-migration validation, and rollback procedures