SDET Lead / Automation Test Lead

Job Summary

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 perf

Responsibilities

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.

• 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 and 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.

• More than 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.

• Design develop and maintain automated test frameworks for mobile (Android) and web applications using Appium Selenium Playwright or similar tools.
• Develop and execute API test automation using tools like Postman RestAssured or Karate.
• Proficiency in programming languages such as Java TypeScript JavaScript or Kotlin.
• 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).

Salary and Other Compensation:

The annual salary for this position is between $115K - $130K depending on the experience and other qualifications of the successful candidate.

This position is also eligible for Cognizant's discretionary annual incentive program and stock awards, based on performance and subject to the terms of Cognizant's applicable plans.

Benefits: Cognizant offers the following benefits for this position, subject to applicable eligibility requirements:

* Medical/Dental/Vision/Life Insurance

* Paid holidays plus Paid Time Off

* 401(k) plan and contributions

* Long-term/Short-term Disability

* Paid Parental Leave

* Employee Stock Purchase Plan

Disclaimer: The salary, other compensation, and benefits information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.

Application accepted till 5/15/2025