Senior Automation Engineer (Backend Testing & Data Migration Testing) (Chicago)
Posted Updated
Summary
Coforge is hiring a Senior Automation Engineer (onsite in Chicago) to design and run data migration test strategies, building automated validation and reconciliation frameworks that compare source and target data. Core stack: Python/Java, SQL automation, and Oracle, SQL Server, MySQL, and Snowflake; requires 10+ years of experience.
- 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