Automation Test Engineer Backend

2 days ago

Chicago, IL, United States Advent Global Solutions, Inc. Full-time

Title:                                    Automation Test Engineer (Backend & Data Migration Testing)

Experience:                     10 + years

Location:                           Chicago, IL 60604 (Onsite Job)

Hiring Type:                     Video Interview

 

Key Responsibilities

Data Migration Testing

  • Develop and execute migration test strategies, plans, and validation approaches.
  • Validate source-to-target data mappings and transformation rules.
  • Perform data reconciliation before and after migration.
  • Verify completeness, accuracy, consistency, and integrity of migrated data.
  • Execute mock, dress rehearsal, and production migration validation cycles.
  • Support cutover, rollback, and migration readiness activities.
  • Identify and analyze data quality issues, duplicates, truncation, and transformation defects.

Automation Development

  • Build automated validation frameworks for data migration testing.
  • Develop scripts to compare source and target systems.
  • Automate record count validation, field-level validation, and business rule verification.
  • Automate reconciliation reports and exception handling processes.
  • Create reusable utilities for large-scale data verification.

  

Required Technical Skills

Automation & Programming

  • Python / Java
  • SQL Automation Scripting

Data Validation & Reconciliation