JobCubby JobCubby
Sign up
Everest Technologies

ETL QA

Everest Technologies

IT Services and IT Consulting · 501-1,000 employees

14 h ago
Remote qa Senior (5-10 yrs) Full-time
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

The engineer will validate complex ETL pipelines and perform large-scale data migration from legacy systems to a consolidated MySQL instance. Responsibilities include building automated reconciliation scripts to ensure data parity and verifying data integrity across APIs and backend layers.

What they look for

SQL ETL Data Migration MySQL Python C# Java Data Validation Test Automation Great Expectations dbt QuerySurge API Testing Data Integrity Database Schemas CI/CD

Requirements

Candidates must have 7+ years of advanced SQL expertise and proven experience in large-scale database consolidations or ETL testing. Proficiency in building automated test frameworks using Python, C#, or specialized data testing tools is required.

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

Similar roles