Background
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
Experience
4 to 8 years
Mandatory Skills
- 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
Key Responsibilities
- 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.
Optional Skills
- 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
Additional Details
- Working in Shifts
- No
- Qualification
- BE, B-Tech
- Time to Fill
- Immediate