What are the responsibilities and job description for the Data Migration Test Automation Engineer position at Coforge?
- 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 / 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