Senior Automation Engineer (Backend Testing & Data Migration Testing)
Posted
Summary
Senior automation engineer (onsite in Chicago) focused on backend and data migration testing: designing migration test strategies, building automated source-to-target validation and reconciliation frameworks, and scripting in Python/Java and SQL against Oracle, SQL Server, MySQL, and Snowflake. Requires 10+ years of experience.
Interested in this role You can find all the relevant information in the description below.
- 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. xuwmhxw
- 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