Start searching
Back to Jobs
Other

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

Vbeyond CorporationChicago, IL🇺🇸United States

Why this role stands out

This role offers a fantastic opportunity to elevate your career by architecting advanced automation frameworks for large-scale data migrations within a dynamic, high-impact environment. You will thrive here if you are a detail-oriented problem solver who enjoys mastering complex database technologies and building scalable validation solutions. Apply today to take the next step in your professional journey and contribute to cutting-edge data integrity initiatives.

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationChicago, IL, United States
MySQLOracleSQLETLSnowflakeAuditingJavaPythonReconciliationSQL Server

Job description

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

Similar jobs

Apply