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:

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

The Cognizant community:
We are a high caliber team who appreciate and support one another. Our people uphold an energetic, collaborative and inclusive workplace where everyone can thrive.

• Cognizant is a global community with more than 300,000 associates around the world.
• We don’t just dream of a better way – we make it happen.
• We take care of our people, clients, company, communities and climate by doing what’s right.
• We foster an innovative environment where you can build the career path that’s right for you.

About us:
Cognizant is one of the world's leading professional services companies, transforming clients' business, operating, and technology models for the digital era. Our unique industry-based, consultative approach helps clients envision, build, and run more innovative and efficient businesses. Headquartered in the U.S., Cognizant (a member of the NASDAQ-100 and one of Forbes World’s Best Employers 2025) is consistently listed among the most admired companies in the world. Learn how Cognizant helps clients lead with digital at www.cognizant.com

Cognizant is an equal opportunity employer. Your application and candidacy will not be considered based on race, color, sex, religion, creed, sexual orientation, gender identity, national origin, disability, genetic information, pregnancy, veteran status or any other characteristic protected by federal, state or local laws.

If you have a disability that requires reasonable accommodation to search for a job opening or submit an application, please email CareersNA2@cognizant.com with your request and contact information.

Disclaimer:
Compensation 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.

Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.