Database Testing SME (Data Integrity, Batch/ETL, Stored Procedures) Job at SDET Tech

Job Description

The QA will work closely with Engineering, SRE, and cross-functional teams to validate data pipelines, database changes, and batch processing workflows. The role focuses on ensuring data accuracy, reconciliation, stored procedure validation, trigger testing, incremental and delta processing, exception handling, and operational resilience across multiple integrated systems. This is a database-focused QA role, not a DBA or UI testing position

Job Responsibility

Own end-to-end data validation for pipelines, integrations, migrations, and database changes
Design and execute database-centric test plans for batch jobs, ETL processes, and data feeds
Create and maintain reconciliation checks, completeness checks, anti-joins, key-level comparisons, and anomaly detection validations
Validate and regression test stored procedures, triggers, functions, and business transformation logic
Develop test cases for edge cases, malformed data, exception handling, and correction workflows
Validate restart safety, reprocessing scenarios, idempotency, and recovery from partial failures
Test and analyze locking, deadlock, contention, and transaction handling scenarios
Support troubleshooting activities using logs, monitoring data, timestamps, and operational signals
Document testing approaches, validation evidence, defects, and risk assessments
Collaborate with Engineering and SRE teams to identify and mitigate data-related risks

Requirements

Strong SQL expertise with complex queries, joins, aggregations, window functions, CTEs, and data validation
Hands-on experience in Database Testing, ETL/ELT Testing, and Data Quality Validation
Experience testing Stored Procedures, Functions, Triggers, and transformation logic
Strong understanding of Batch Processing, Incremental Loads, Delta Processing, and Reprocessing
Experience creating reconciliation checks, data comparison scripts, and validation frameworks
Knowledge of transactions, isolation levels, locking, deadlocks, and concurrency testing
Experience with defect tracking and documentation tools such as Jira and Confluence
Strong analytical, troubleshooting, and communication skills
4 to 8 years of experience

Nice to have

Experience with SQL Server, PostgreSQL, Oracle, or MySQL
API Testing using Postman, REST Assured, or similar tools
Performance and Load Testing related to database workloads
Familiarity with CI/CD tools such as Jenkins and GitHub Actions
Experience with data pipeline tools like SSIS, Informatica, Airflow, dbt, or Azure Data Factory
Experience validating reporting, analytics, data marts, and dashboard data
Basic scripting knowledge using Python, Java, or similar languages

SDET Tech - All Job Offers

Select Country

Database Testing SME (Data Integrity, Batch/ETL, Stored Procedures)

Job Description

Job Responsibility

Requirements

Nice to have

Looking for more opportunities?

Database Testing SME (Data Integrity, Batch/ETL, Stored Procedures)

Social Worker – Fostering - Family and Friends Team

Spanish Speaking Caregiver

Early Years Consultant

Head of Internal Audit

Caregiver

Social Worker – Under 16s Team

Solutions Engineer

Principal Security Analyst, Special Projects

Our AI answers in your language