TriZetto logo

SDET Lead Automation Test Lead

TriZetto

Durham, NC
Full Time
Senior
115k-130k
10 days ago

Job Description

About the Role

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 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.
  • 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.
  • Perform performance testing of databases using JMeter or Gatling.
  • Work with NoSQL databases (MongoDB, Redis) and their testing approaches.
  • Utilize containerized environments with Docker and Kubernetes.
  • Apply security testing techniques for database vulnerabilities.
  • Understand cloud-based database solutions such as AWS RDS, Azure SQL, and Google Cloud SQL.

Requirements

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

Qualifications

  • N/A (not explicitly specified, but implied: relevant experience in database/backend testing and related skills)

Benefits & Perks

  • 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

Working at TriZetto

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.

Apply Now

Job Details

Posted AtJul 14, 2025
Job CategoryQA Engineering
Salary115k-130k
Job TypeFull Time
Work ModeHybrid
ExperienceSenior

Job Skills

AI Insights

Key skills identified from this job posting

Sign upto access all insights for this job

About TriZetto

Website

cognizant.com

Company Size

5001-10000 employees

Location

Durham, NC

Industry

Computer Systems Design and Related Services

Get job alerts

Set up personalized alerts for your job search and get tailored job digests for close matches