Data Migration Test Automation Engineer
Title: Data Migration Test Automation Engineer
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 / JavaSQL Automation Scripting
- Data Validation & ReconciliationData Comparison Frameworks
- Large Dataset Validation
- Record-Level ReconciliationData Profiling
- Data Quality Assessment
- Database Technologies
- OracleSQL ServerMySQLSnowflake