ETL QA

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.