Start searching
Back to Jobs
Recently postedTechnology

Automation Test Engineer Backend & Data Migration Testing

Advent Global Solutions, Inc.Chicago, IL🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeOn Site
LocationChicago, IL, United States
MySQLOracleSQLSnowflakeJavaPythonSQL Server

Job description

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

  • Data Comparison Frameworks
  • Large Dataset Validation
  • Record-Level Reconciliation
  • Data Profiling
  • Data Quality Assessment

Database Technologies

  • Oracle
  • SQL Server
  • MySQL
  • Snowflake

Similar jobs

Apply