Senior SDET - Database & Stored Proc Testing (Remote)

Cognizant Technology Solutions Corporation; Mangum (NC); Remote; USD 69,000 - 103,000; Part time

Job summary

Cognizant is seeking a Software Development Engineer in Test (SDET) focused on database and backend testing. You will validate data integrity, test stored procedures, and implement automated tests for database-driven applications.

Responsibilities include designing automated test frameworks, creating test cases for procedures and triggers, and using mocking frameworks to isolate components. Strong SQL, API testing, and CI/CD experience are required.

Qualifications

• 5+ years of experience in database and backend testing.
• Strong knowledge of SQL databases (MySQL, PostgreSQL, SQL Server, Oracle) and stored procedure testing.
• Proficiency in 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 tools like Jenkins, GitHub Actions, or Azure DevOps.
• Familiarity with API testing and backend validation using Postman, RestAssured, or SoapUI.

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 business logic and data consistency.
• Implement mocking techniques to simulate database interactions and isolate testing components.
• Develop and maintain unit and integration tests using mocking frameworks such as Mockito, JMock, or WireMock.
• Collaborate with development and DevOps teams to integrate database tests into CI/CD pipelines using Jenkins, GitHub Actions, or GitLab CI.
• Perform SQL query validation to ensure data accuracy, integrity, and consistency across multiple environments.
• Work with API testing to validate database interactions using tools like 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

SQL

Mocking techniques

JUnit

NUnit

TestNG

APIs testing

CI/CD

Debugging

Tools

Mockito

JMock

WireMock

Postman

RestAssured

SoapUI

Jenkins

GitHub Actions

Azure DevOps

Job description

Cognizant is seeking a Software Development Engineer in Test (SDET) focused on database and backend testing. You will validate data integrity, test stored procedures, and implement automated tests for database-driven applications.

Responsibilities include designing automated test frameworks, creating test cases for procedures and triggers, and using mocking frameworks to isolate components. Strong SQL, API testing, and CI/CD experience are required.