Data Migration / Test Lead

AET FEDERAL INC•Danville, VA

2d•$120,000 - $165,000•Hybrid

About The Position

The Data Migration / Test Lead owns two critical workstreams for an Enterprise Technology Management implementation for a municipal government client: migrating the City's existing help desk tickets, asset inventories, software licenses, and project records into ServiceNow, and conducting structured testing to verify the configured solution before go-live. This is a full-time, hybrid position based out of the employer's Tysons, Virginia office, with periodic travel to the client site in Danville, Virginia. The role develops and executes data migration strategy, mapping, cleansing, migration loads, mock migrations, reconciliation, production cutover, and validation. It also leads quality assurance and testing across unit, integration, regression, performance, and user acceptance testing; creates traceable test cases; builds reusable ServiceNow ATF regression tests; coordinates accessibility testing; and reports readiness and results to the Project Manager. The position collaborates with the ServiceNow Architect, module specialists, City staff, and data owners. Deliverables include migration plans and mapping materials, reconciliation reports, a cutover runbook, test plans and cases, a traceability matrix, an ATF regression suite, UAT results, a defect log, and accessibility test results.

Requirements

Bachelor's degree or higher, or equivalent experience.
At least 6 years of experience in data migration and/or software QA, including at least 3 years on ServiceNow implementations.
Hands-on experience with ServiceNow Import Sets, Transform Maps, and Automated Test Framework (ATF).
Strong SQL and Excel skills for data profiling, cleansing, and reconciliation.
ServiceNow Certified System Administrator (CSA) certification required.
Excellent attention to detail and organization.
Ability to travel to Danville, Virginia, as required.
Ability to pass a criminal background check required by the client contract.

Nice To Haves

ISTQB or similar testing certification.
Familiarity with Section 508 / WCAG 2.1 accessibility testing tools.

Responsibilities

Inventory the City's legacy data sources, such as the current help desk tool, asset spreadsheets, license records, and project trackers, and assess data quality.
Develop the data migration strategy, source-to-target mapping, and cleansing rules with City data owners.
Build and run migration loads using ServiceNow Import Sets, Transform Maps, and IntegrationHub ETL.
Run mock migrations, reconcile record counts, and resolve data defects.
Plan and execute the production cutover and obtain data validation sign-off.
Develop the master test plan covering unit, system integration, regression, performance, and user acceptance testing.
Write test cases traced to City requirements and acceptance criteria.
Use ServiceNow Automated Test Framework (ATF) to build reusable regression tests.
Coordinate accessibility testing against Section 508 and WCAG 2.1 AA to support the VPAT/ACR.
Facilitate UAT with City staff, manage the defect log, and report test results to the Project Manager.
Work with the ServiceNow Architect and module specialists on target data structures and fixes.
Provide go/no-go readiness data for the go-live decision.
Produce the Data Migration Plan, source-to-target mapping workbook, data cleansing rules, mock migration and reconciliation reports, cutover plan and runbook, Master Test Plan, test cases, requirements traceability matrix, ATF regression suite, UAT results, defect log, and accessibility test results.