Automation Data Migration Testing || Chicago, IL || Onsite Day 1

Key Responsibilities

Automation 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.

Database & ETL Validation

• Validate ETL/ELT workflows and data pipelines.
• Test data extraction, transformation, and loading processes.
• Verify schema changes, stored procedures, jobs, and data movement processes.
• Perform auditing and lineage validation across systems.

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