Software Developer in Test; SDET – Database, SQL and SPROC Testing

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.

• 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 Wire Mock.
• Collaborate with development and Dev Ops teams to integrate database tests into CI/CD pipelines using Jenkins, Git Hub Actions, or Git Lab 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 Rest Assured.
• 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
  .

• 5+ years of experience in database and backend testing
  .
• Strong knowledge of SQL databases (MySQL, Postgre
  
  SQL, SQL Server, Oracle) and stored procedure testing.
• Proficiency in mocking techniques for database interactions using Mockito, JMock, Wire Mock, 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, Git Hub Actions, or Azure Dev Ops.
• Familiarity with API testing and backend validation using Postman, Rest Assured, 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, Rest Assured, or Karate.
• Proficiency in programming languages such as Java, Type Script, JavaScript, or Kotlin.
• Experience with performance testing of databases using JMeter or Gatling.
• Knowledge of No
  
  SQL databases (Mongo
  
  DB, 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).