QE Lead - Automation Data Migration

Chicago, IL, US • Posted 10 hours ago • Updated 8 hours ago
Contract Independent
Contract Corp To Corp
12 Months
No Travel Required
On-site
$50 - $55/hr
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • ETL
  • Test data extraction
  • transformation
  • loading processes
  • Python
  • Java
  • SQL
  • MySQL
  • Snowflake

Summary

The QE Lead - Automation Data Migration will lead testing and automation activities for enterprise data migration initiatives. The role is responsible for migration test strategy, automated source-to-target validation, data reconciliation, and ETL/ELT pipeline testing, with a strong focus on data quality, migration readiness, and production validation.

Scope of Work

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 the 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 reporting and exception-handling processes.

•       Create reusable utilities for large-scale data verification.

Database and 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 Skills and Experience

Automation and Programming

•       Strong programming and automation experience using Python and/or Java.

•       Strong SQL automation and scripting experience.

Data Validation and Reconciliation

•       Experience building or using automated data-comparison frameworks.

•       Strong experience validating large datasets.

•       Hands-on record-level reconciliation experience.

•       Experience with data profiling and data-quality assessment.

•       Strong understanding of source-to-target validation and migration-testing practices.

Database Technologies

•       Hands-on experience with Oracle.

•       Hands-on experience with SQL Server.

•       Hands-on experience with MySQL.

•       Hands-on experience with Snowflake.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: PTP0ovFhHnV4MPo
  • Position Id: GC3110
  • Posted 10 hours ago
Contact the job poster
DR

Divya Rawal

Recruiter @ NOVUS GLOBAL SERVICES LLC

Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.