Senior SDET: Database & Backend Testing (Remote)

Cognizant; Durham (NC); Remote; USD 96,000 - 165,000; Full time

Job summary

Cognizant is seeking an experienced Software Development Engineer in Test (SDET) focused on database testing, stored procedures, and mocking techniques. You will validate data integrity, backend functionality, and automate tests for database-driven applications.

You will design automated test frameworks, create test cases for procedures and functions, and integrate tests into CI/CD pipelines. Strong SQL skills and API testing experience are required.

Qualifications

• 5+ years of experience in database and backend testing.
• Proficiency with SQL databases (MySQL, PostgreSQL, SQL Server, Oracle) and stored procedure testing.
• Experience with mocking techniques for database interactions using Mockito, JMock, WireMock, or similar frameworks.
• Hands-on experience with unit testing frameworks such as JUnit, NUnit, or TestNG.
• Expertise in writing complex SQL queries, stored procedures, and triggers for test validation.
• Experience in CI/CD automation with Jenkins, GitHub Actions, or Azure DevOps.
• Familiarity with API testing and backend validation using Postman, RestAssured, or SoapUI.
• Strong problem-solving skills and ability to debug database-related issues.
• Experience with test data management and creating reusable test datasets.

Responsibilities

• Design, develop, and maintain automated test frameworks for database and backend testing.
• Create and execute test cases for stored procedures, triggers, and database functions to validate logic and data.
• Implement mocking techniques to simulate database interactions and isolate testing components.
• Develop and maintain unit and integration tests using Mockito/JMock/WireMock and frameworks like JUnit.
• Collaborate with development and DevOps teams to integrate database tests into CI/CD pipelines (Jenkins, GitHub Actions, GitLab CI).
• Perform SQL query validation to ensure data accuracy and consistency across environments.
• Work with API testing to validate database interactions using Postman or RestAssured.
• Identify and report performance bottlenecks in database queries and stored procedures.
• Implement data-driven and schema validation tests to verify database changes.
• Research and implement best practices for database testing, data virtualization, and test data management.

Skills

Database testing

Backend testing

SQL databases

Stored procedure testing

Mocking techniques

Unit testing frameworks

Test data management

CI/CD automation

API testing

Tools

Mockito

JMock

WireMock

JUnit

Postman

RestAssured

SoapUI

Job description

Cognizant is seeking an experienced Software Development Engineer in Test (SDET) focused on database testing, stored procedures, and mocking techniques. You will validate data integrity, backend functionality, and automate tests for database-driven applications.

You will design automated test frameworks, create test cases for procedures and functions, and integrate tests into CI/CD pipelines. Strong SQL skills and API testing experience are required.