QA Engineer – Database & SQL Testing

We are looking for a QA Engineer – Database & SQL Testing with strong expertise in AWS Data Warehousing to ensure the quality, accuracy, and reliability of data across our cloud platform. This role involves white box testing of complex SQL logic, validating database structures, and ensuring ETL processes and data pipelines built on AWS services meet business and technical requirements.

Key Responsibilities

• Perform white box testing of complex SQL logic, stored procedures, views, and data transformations.
• Test data pipelines and ETL processes on AWS (Redshift, Glue, Athena, S3).
• Write and execute advanced SQL queries to validate business logic and data accuracy.
• Conduct data quality checks: duplicates, null values, schema validation, row counts, referential integrity.
• Test Change Data Capture (CDC) pipelines using AWS DMS and Glue.
• Validate workflows implemented via AWS Step Functions and Lambda.
• Automate data testing using Python or frameworks like Great Expectations, dbt, or Pytest.
• Work with CI/CD pipelines, log issues, and report defects effectively.
• Ensure adherence to data governance, security, and compliance standards.

Requirements

• 3–6 years of experience in Database / ETL / Data Warehouse testing.
• Strong white box testing skills with the ability to understand and validate internal logic of SQL scripts and ETL components.
• Excellent command of SQL (joins, CTEs, window functions, aggregations, etc.).
• Hands-on experience with AWS services: Redshift, Glue, Athena, S3.
• Experience in automated data testing using Python, Pytest, or equivalent tools.
• Familiar with version control systems (Git) and CI/CD tools (e.g., Jenkins, GitHub Actions).
• Experience testing data workflows involving AWS Step Functions and Lambda.

Nice to Have

• Exposure to Snowflake, BigQuery, or Azure Synapse.
• Familiarity with BI tools: Tableau, Power BI, Amazon QuickSight.
• Experience working in Agile teams and using JIRA and Confluence.

Job Type: Full-time

Application Question(s):

• How would you rate your English communication skills (verbal and written)?
• How comfortable are you with writing complex SQL queries (joins, window functions, aggregations)?
• Which AWS services have you used specifically for data testing or validation?
• Which test automation frameworks have you used for data testing?
• Are you familiar with any CI/CD tools for test integration (e.g., Jenkins, GitHub Actions)?

Work Location: In person