Data Migration / Test Lead

AET FEDERAL INC

Danville (VA)

Hybrid

USD 120,000 - 165,000

Full time

6 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Paid time off
Vision insurance
401(k)
401(k) matching
Dental insurance

Job summary

AET FEDERAL INC. seeks a Data Migration / Test Lead to manage two critical streams on an Enterprise Technology Management implementation for a municipal government client. The role covers data migration to ServiceNow and rigorous testing before go-live, with a focus on data quality and traceability.

The position is full-time, hybrid, based in Tysons, VA with periodic travel to Danville, VA. Candidates should bring extensive ServiceNow migration and ATF testing experience and a strong data

Qualifications

  • 6+ years of data migration and QA experience, including ServiceNow projects.
  • Strong SQL and Excel skills for profiling, cleansing, and reconciliation.
  • Experience with ServiceNow Import Sets, Transform Maps, and ATF.
  • CSA certification required; ISTQB or similar testing cert a plus.
  • Willingness to travel to Danville, VA as required.

Responsibilities

  • Own data migration and testing workstreams for the ServiceNow rollout.
  • Develop 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 ETL tools.
  • Run mock migrations, reconcile counts, and resolve data defects.
  • Lead UAT, coordinate accessibility testing, and report results to project leadership.

Skills

Data migration
Software QA
SQL
Excel
Attention to detail
Travelability

Education

ServiceNow CSA certification
Bachelor's degree or equivalent experience

Tools

ServiceNow Import Sets
Transform Maps
Automated Test Framework (ATF)
WCAG accessibility testing tools

Job description

Benefits:


  • Paid time off

  • Vision insurance

  • 401(k)

  • 401(k) matching

  • Dental insurance



We are seeking a Data Migration / Test Lead to join the team! This role owns two critical workstreams on an Enterprise Technology Management implementation for a municipal government client: moving the City's existing help desk tickets, asset inventories, software licenses, and project records into ServiceNow, and proving through structured testing that the configured solution works before go-live. This is a full-time, hybrid position based out of our Tysons, VA office with periodic travel to the client site in Danville, VA.



Responsibilities

Data Migration


  • Inventory the City's legacy data sources (e.g., current help desk tool, asset spreadsheets, license records, 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 data validation sign-off


Testing & Quality Assurance


  • Develop the master test plan covering unit, system integration, regression, performance, and user acceptance testing (UAT)

  • Write test cases traced to City requirements and acceptance criteria

  • Use the ServiceNow Automated Test Framework (ATF) to build reusable regression tests

  • Coordinate accessibility testing against Section 508 / 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


Collaboration


  • 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



Deliverables


  • Data Migration Plan, source-to-target mapping workbook, and data cleansing rules

  • Mock migration and reconciliation reports

  • Cutover plan and runbook

  • Master Test Plan, test cases, and requirements traceability matrix

  • ATF regression suite, UAT results, and defect log

  • Accessibility test results



Qualifications


  • Bachelor's Degree or higher (or equivalent experience)

  • 6+ years of experience in data migration and/or software QA, with 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) required; ISTQB or similar testing certification a plus

  • Familiarity with Section 508 / WCAG 2.1 accessibility testing tools a plus

  • Excellent attention to detail and organization

  • Ability to travel to Danville, VA as required

  • Ability to pass a criminal background check required by the client contract



Salary- $120,000–$165,000


We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.



Flexible work from home options available.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

ServiceNow Specialist - Service Desk
ServiceNow Specialist - Service Desk

AET Federal Inc. • Danville (VA)

Hybrid
USD 110,000 - 140,000
Flexible work from home
ServiceNow Specialist - Portfolio & Intake
ServiceNow Specialist - Portfolio & Intake

AET Federal Inc. • Danville (VA)

Hybrid
USD 115,000 - 140,000
Health insurance
Paid time off
Vision insurance
+4
ServiceNow Architect
ServiceNow Architect

AET FEDERAL INC • Danville (VA)

Hybrid
USD 130,000 - 160,000
Health insurance
Paid time off
Vision insurance
+2
ServiceNow Architect
ServiceNow Architect

AET Federal Inc. • Danville (VA)

Hybrid
USD 130,000 - 160,000
Health insurance
Paid time off
Vision insurance
+2
ServiceNow ITSM Developer
ServiceNow ITSM Developer

AET FEDERAL INC • Danville (VA)

Hybrid
USD 120,000 - 150,000
Flexible work from home options
ServiceNow ITAM / SPM Specialist
ServiceNow ITAM / SPM Specialist

AET FEDERAL INC • Danville (VA)

Hybrid
USD 115,000 - 145,000
Health insurance
Paid time off
Vision insurance
+2
ServiceNow QA Tester (IT Customer Support Services)
ServiceNow QA Tester (IT Customer Support Services)

G2it, Llc. • Quantico (VA)

Hybrid
USD 70,000 - 80,000
Lead ITSM/ITIL Consultant (SME)
Lead ITSM/ITIL Consultant (SME)

Northramp LLC. • Washington

Hybrid
USD 180,000 - 240,000
Health Care Plan
Retirement Plan (401k, IRA)
Life Insurance
+7
Senior ServiceNow Developer (ITAM, HAM, CMDB)
Senior ServiceNow Developer (ITAM, HAM, CMDB)

Dysrupit • United States

Remote
USD 120,000 - 180,000
Remote work arrangement
Competitive compensation
Lead ITSM/ITIL Consultant (SME)
Lead ITSM/ITIL Consultant (SME)

Northramp LLC • United States

Hybrid
USD 170,000 - 210,000
Health care plan
Retirement plan (401k, IRA)
Life insurance
+3