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

What you'll do

• 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.
• Implement mocking techniques to simulate database interactions and isolate testing components.
• Develop and maintain unit and integration tests using frameworks like Mockito, JMock, or WireMock.
• Perform SQL query validation to ensure data accuracy and consistency across multiple environments.
• Integrate database tests into CI/CD pipelines using tools like Jenkins, GitHub Actions, or GitLab CI.
• Conduct API testing to validate database interactions using Postman or RestAssured.
• Implement data-driven and schema validation tests to verify database changes.

What we're looking for

• Applicants must be currently authorized to work for any employer in the United States.
• 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.