Data Migration / Test Lead

Aet Federal•Danville, VA

1d•Hybrid

About The Position

AET Federal Inc. is seeking a Data Migration / Test Lead for an Enterprise Technology Management implementation for a municipal government client. The role owns two workstreams: 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. The position is full-time and hybrid, based out of the company's Tysons, Virginia office, with periodic travel to the client site in Danville, Virginia. The role includes assessing legacy data sources and data quality; developing migration strategy, source-to-target mappings, and cleansing rules; building and running migration loads; conducting mock migrations and reconciliations; and planning production cutover and validation. It also covers test planning and execution across unit, integration, regression, performance, and user acceptance testing; creating requirements-traceable test cases; building reusable regression tests with ServiceNow ATF; coordinating accessibility testing; facilitating UAT; managing defects; and reporting results and go-live readiness information. The position collaborates with the ServiceNow Architect, module specialists, City data owners, City staff, and the Project Manager. Deliverables include migration plans and mapping materials, migration and reconciliation reports, cutover documentation, a master test plan, test cases and 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 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 production cutover and obtain data validation sign-off.
Develop a master test plan for unit, system integration, regression, performance, and user acceptance testing.
Write test cases traceable 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 migration plans, source-to-target mapping and cleansing documentation, migration and reconciliation reports, cutover materials, testing documentation, regression tests, UAT results, defect logs, and accessibility test results.