Job SummaryWe 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 ResponsibilitiesWe 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 PlanDisclaimer: 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 7/15/2025
What we offer
- The chance to work with impact. Here, you’re empowered to bring your biggest thinking to help our company and clients improve everyday life.
- Ownership over your career. Stay at the top of your game through our award-winning learning and development ecosystem. And when your ambitions change or we offer new opportunities, we help you pivot by providing reskilling, on-the-job learning and guidance to find new roles that might be a better fit.
- The opportunity to thrive on a high caliber team with heart. We celebrate each other’s experiences and perspectives and promote a sense of belonging through our affinity groups and diversity and inclusion initiatives.
- A comprehensive total rewards package, including a competitive salary and pension plan with matching contributions.
- Flexible health and financial benefits to support you and your eligible dependents—from day one.
- True work-life balance. Be at your best through paid time off, flexible work arrangements, volunteering opportunities, social events, and so much more.
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 2024) is consistently listed among the most admired companies in the world. Learn how Cognizant helps clients lead with digital at www.cognizant.com.
Other employment-related information
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, provincial or local laws.
If you have a disability that requires reasonable accommodation to search for a job opening or submit an application, please email [email protected] with your request and contact information.
While our system allows applications in all languages, job required language(s) and proficiency level(s) vary. However, basic English proficiency is required for Company-wide communications purposes. Further, for roles located in Quebec, professional English proficiency is required to communicate with our global clients.