Senior Automation Engineer (Backend Testing & Data Migration Testing) (Chicago)

• Title: Senior Automation Engineer (Backend Testing & Data Migration Testing)
• Skills: Data Migration Testing, Automation Development, Backend Testing, Data Validation, Database Technologies, etc
• Experience: 10 + years
• Location: Chicago, IL (Onsite Job)

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