SQL Database Tester / Backend Testing Engineer - API Testing

About the Role

We are hiring an experienced SQL Database Tester / Backend Testing Engineer with strong hands-on experience in SQL query writing, backend database validation, data integrity testing and REST API testing.

This is primarily a SQL and database testing role, not a UI automation or Selenium-focused position.

The ideal candidate must be comfortable independently writing SQL queries, validating backend data, troubleshooting database mismatches and verifying end-to-end transactions.

Mandatory Skills

• Strong SQL: Hands-on experience writing SQL queries involving multiple table joins, subqueries, GROUP BY, HAVING, aggregations and complex filtering.
• Database Testing: Practical experience validating data integrity, accuracy, consistency, duplicates, null values, constraints and business rules.
• Backend Testing: Experience validating database transactions, application data flows and backend processing.
• Data Validation: Ability to compare expected and actual database values, perform data reconciliation and investigate discrepancies.
• Database Knowledge: Hands-on experience with relational databases. PostgreSQL experience is strongly preferred.
• API Testing: Experience validating REST API requests, responses and corresponding backend database records.

Key Responsibilities

1. Write and execute SQL queries to validate backend application data and business logic.
2. Perform database testing involving data integrity, referential integrity, record counts, duplicates, null values and constraints.
3. Validate data across multiple related database tables using SQL joins, subqueries and aggregations.
4. Compare REST API responses against database records to verify transaction accuracy and completeness.
5. Investigate backend data discrepancies and collaborate with development teams to identify root causes.
6. Validate insert, update and delete operations and expected database state changes.
7. Design and execute test cases for backend services, databases and API integrations.
8. Prepare test data, document validation results and report defects with appropriate SQL evidence.
9. Participate in functional, integration, regression testing and defect lifecycle activities.

Secondary / Good-to-Have Skills

• Postman for REST API testing
• SoapUI for SOAP web-service testing
• JUnit or other automation testing frameworks
• Apache JMeter for performance testing
• Python or Java scripting
• ETL testing, source-to-target validation or data reconciliation
• Jenkins, Jira and CI/CD exposure

Ideal Candidate Profile

We are particularly interested in candidates working as:

• Database Test Engineer / SQL Tester
• Backend QA Engineer / Backend Tester
• API & Database Tester
• Data Validation Test Engineer
• ETL Test Engineer with API testing experience
• SQL-focused Software Test Engineer