Software Developer in Test (SDET) – Database, SQL and SPROC Test

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

"Applicants must be currently authorized to work for any employer in the United States. The company is unable to provide employment-based immigration sponsorship for this position"

Job Title

Software Developer in Test (SDET) – Database, SQL and SPROC Testing

Location

Remote (On-shore preferably EST or CST timezones)

Job Type

Contract

Experience Level

Mid-Level/Senior-Level

Job Description

We are seeking a skilled Software Development Engineer in Test (SDET) with expertise in database testing, stored procedure testing, and mocking techniques. This role involves ensuring data integrity, validating backend functionality, and implementing automated tests for database-driven applications. The ideal candidate should have experience in mocking database interactions, automating tests for stored procedures, and working with complex SQL queries to validate data consistency and system performance.

Key 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.

Required Skills & 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.
• Strong problem-solving skills and ability to debug database-related issues.
• Experience with test data management and creating reusable test datasets.

Nice To Have

• Experience with performance testing of databases using JMeter or Gatling.
• Knowledge of NoSQL databases (MongoDB, Redis) and their testing approaches.
• Exposure to containerized environments with Docker and Kubernetes.
• Familiarity with security testing techniques for database vulnerabilities.
• Understanding of cloud-based database solutions (AWS RDS, Azure SQL, Google Cloud SQL).