What are the responsibilities and job description for the Automation Test Engineer Backend & Data Migration Testing position at Advent Global Solutions, Inc.?
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
Salary : $58