Automation Test Engineer Backend & Data Migration Testing

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