Software Developer in Test (SDET) - Database, SQL and SPROC Testing

Cognizant
Durham, NC
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). Cognizant is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.
Posted 2025-12-05

Recommended Jobs

Caregiver

Senior Helpers of Central NC
Yadkinville, NC

It’s more than just a job! We are looking for YOU to make a difference in someone's life! Come join us! We are Great Place to Work Certified! Senior Helpers of Central NC to help seniors age with di…

View Details
Posted 2025-09-30

Strategy Analyst

FMI
Raleigh, NC

Overview FMI’s Strategy Practice is seeking a high-energy, self-motivated Analyst to join its growing team. FMI’s Strategy Practice focuses on strategic planning, business development, and go-to-m…

View Details
Posted 2025-11-22

Staff Nurse - Day Shift

UNC Health Care
Kinston, NC

**Description** Become part of an inclusive organization with over 40,000 teammates, whose mission is to improve the health and well-being of the unique communities we serve. Summary: + Operates as a …

View Details
Posted 2025-12-11

Certified Tumor Registrar - Remote or Onsite

Odell Medical Search
Raleigh, NC

Cancer Network in the Raleigh-Durham, NC area is seeking several Onsite or Remote Certified Tumor Registrars to join their team. ~ Full-time Benefits: ~ Relocation assistance ~ Tuition assi…

View Details
Posted 2025-10-21

Logistics Coordinator III

SGS Consulting
North Carolina

Job Responsibilities: Maintain all U.S., Canadian trade compliance work instructions and procedures policies. Ensure all U.S. and Canadian sites comply with applicable regulatory requirements a…

View Details
Posted 2025-12-02

Lead Digital Product Manager

Motion Recruitment Partners
Charlotte, NC

Lead Digital Product Manager Charlotte, North Carolina **Open to Remote** Contract $53.09/hr - $59.82/hr Outstanding contract opportunity! A well-known Financial Services Company is looking for a Digi…

View Details
Posted 2025-11-14

Principal Software Engineer - Java

Veeva Systems
Raleigh, NC

As a pioneer in industry cloud and one of the fastest-growing enterprise SaaS companies (surpassing $2B in revenue last year), Veeva is on a mission to help life sciences companies accelerate the del…

View Details
Posted 2025-11-13

Greeter - Full Time

BrickTop's
Charlotte, NC

Upscale American contemporary cuisine. Fresh seafood, delicious steaks, and excellent service! Looking for a full-time greeter with experience. Our greeters present a positive first impression of Bri…

View Details
Posted 2025-08-09

Chemical PSM Leader

Greenville, NC

Our Eastern NC client, a global chemical leader, has multiple openings for experienced PSM Engineers.  The PSM program responsibilities will include implementing all aspects of plant-wide strategies,…

View Details
Posted 2025-12-12

Sales Consultant

Subaru South Charlotte
Charlotte, NC

Automotive Sales ConsultantSubaru South Charlotte | Charlotte, NC“Whatever it takes to stand above the rest.” Are you motivated, customer-focused, and ready to build a rewarding career in automotive…

View Details
Posted 2025-10-21