SDET Lead / Automation Test Lead
$115k/y-$130k/y
18 days ago
Highlight
OnsiteFull-timeSenior
Summary
Cognizant is seeking a skilled SDET Lead / Automation Test Lead to join their team in Mangum, NC. The role focuses on database testing, stored procedure testing, mocking techniques, and ensuring data integrity and backend functionality through automated tests.
About the Role
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 and consistency across environments. Work with API testing tools like Postman or RestAssured to validate database interactions. 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.
About You
Required:
- 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.
Preferred:
- Experience designing and maintaining 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).
Benefits
- Medical, Dental, Vision, and Life Insurance
- Paid holidays plus Paid Time Off
- 401(k) plan and contributions
- Long-term and Short-term Disability
- Paid Parental Leave
- Employee Stock Purchase Plan
Cognizant (Nasdaq-100: CTSH) engineers modern businesses. We help our clients modernize technology, reimagine processes and transform experiences so they can stay ahead in our fast-changing world. Together, we’re improving everyday life. See how at www.cognizant.com or @cognizant.
Mangum, NC