ETL QA

Zohorecruit; United States; Remote; USD 90,000 - 120,000; Full time

Benefits offered by this job

Remote work

Health benefits

Flexible schedule

Job summary

Everest Technologies, Inc. is seeking a data-centric QA engineer for a remote backend modernization project. You will validate ETL pipelines, ensure data integrity, and automate data quality checks in collaboration with C# and Java developers.

The role focuses on migrating 30 disparate databases into a single MySQL instance, with emphasis on parity testing and scalable automation frameworks.

Qualifications

• 7+ years writing advanced SQL queries in MySQL/SQL Server.
• Experience testing large-scale database consolidations, data warehouse migrations, or complex ETL pipelines.
• Hands-on experience building automated data validation scripts using Python, C#, or specialized data testing tools.

Responsibilities

• Data Validation: Write complex SQL queries to validate ETL from legacy databases into the new MySQL instance.
• Migration Parity Testing: Design and execute automated reconciliation scripts to compare millions of rows, ensuring data integrity.
• Pipeline Automation: Build and maintain automated test frameworks for data pipelines with automated data quality checks.
• API Data Verification: Verify that APIs and Data Access Layers surface migrated data correctly.
• Defect Triage: Identify and troubleshoot data drift, truncation errors, mapping failures, and performance bottlenecks.

Skills

Deep SQL Expertise

ETL/Data Migration Testing

Test Automation

Backend Mindset

Parity Validation

Tools

Great Expectations

dbt tests

QuerySurge

Job description

ETech is a leading Information Technology solutions provider based in Hitec City, Hyderabad, India. We are a subsidiary of Everest Technologies Inc. based in Columbus, Ohio USA. We deliver top quality systems and software design, architecture, development, testing and implementation services to clients in a variety of industrial, commercial, and governmental environments. By focusing on achieving client successes, we have achieved success ourselves. Our reputation for providing creative and technically superior consulting services is built on our innovative use of leading technologies tailored to meet the individual needs of our clients.

Job Description

This is a remote position.

About the role

This role is critical to Client’s backend modernization and data consolidation effort, which involves migrating and merging 30 disparate databases into a single consolidated MySQL instance. This is not a standard functional UI testing role; it is a heavy backend, data-centric QA position. The engineer will validate ETL pipelines, ensure zero data loss or corruption during migration, and automate data parity checks between legacy systems and the new architecture.

What you will do

Data Validation: Write complex SQL queries to validate data extraction, transformation, and loading (ETL) from legacy SQL databases into the new consolidated MySQL instance.

Migration Parity Testing: Design and execute automated reconciliation scripts to compare millions of rows between source and target systems, ensuring data integrity and business rule alignment.

Pipeline Automation: Build and maintain automated test frameworks for data pipelines, replacing manual sampling with comprehensive automated data quality checks.

API Data Verification: Work alongside C# and Java developers to verify that the newly built APIs and Data Access Layers (DAL) are surfacing the migrated data correctly.

Defect Triage: Identify, log, and troubleshoot data drift, truncation errors, mapping failures, and performance bottlenecks.

Must have

Deep SQL Expertise: 7+ years of writing advanced SQL queries (Joins, CTEs, Window Functions, Stored Procedures) in MySQL and SQL Server.

ETL/Data Migration Testing: Proven experience testing large-scale database consolidations, data warehouse migrations, or complex ETL pipelines.

Test Automation: Hands-on experience building automated data validation scripts using Python, C#, or specialized data testing tools (e.g., Great Expectations, dbt tests, QuerySurge).

Backend Mindset: Strong understanding of database schemas, primary/foreign key relationships, indexing, and data mapping documents.

Parity Discipline: Proves data equivalence through automated reconciliation, not just manual spot-checking.

Nice to have (strong pluses)

API Testing Experience: Familiarity with Postman, REST Assured, or equivalent tools to test data payloads at the API level.

Code Reading Skills: Ability to read C# or Java code to understand how the Data Access Layer is transforming data.

Cloud & DevOps: Experience with Azure/AWS data services and CI/CD pipelines for automated test execution.