Quality Assurance (QA) Engineer -Database & API Automation

Department: Software Testing

Job Summary:

We are seeking a highly skilled and motivated QA Engineer with a strong focus on database testing, API validation, and automation. The ideal candidate will be responsible for ensuring the quality, reliability, and performance of our software products by developing, executing, and maintaining comprehensive test plans and automation scripts. This role requires a deep understanding of data integrity, system integrations, and the ability to work collaboratively in an agile environment.

Key Responsibilities:

• Database Testing:
  • Design and execute complex SQL queries to validate data integrity, accuracy, and consistency across various database systems (e.g., PostgreSQL, SQL Server, MongoDB).
  • Perform schema validation, data migration testing, and ETL (Extract, Transform, Load) testing.
  • Ensure data security and compliance with relevant regulations.
  • Validate the logic and data flow implemented in stored procedures, functions, and triggers.
• API Validation:
  • Develop and execute test cases for REST and/or SOAP APIs to validate functionality, performance, and security.
  • Utilize tools like Postman, SoapUI, or similar to perform manual and automated API testing.
  • Validate request/response payloads, status codes, and headers.
  • Understand and test various authentication and authorization mechanisms.
• Automation:
  • Execute and maintain existing automation test scripts, ensuring continuous integration and delivery (CI/CD) pipeline readiness.
  • Gain a thorough understanding of the logic implemented in automation frameworks and scripts (e.g., using Java, Python, JavaScript).
  • Debug and troubleshoot script failures, identifying root causes and collaborating with developers to resolve issues.
  • Contribute to the enhancement and maintenance of the automation test suite.
• Messaging Tools:
  • Test and validate data flow and message integrity using messaging queues and tools, with specific experience in Apache Kafka.
  • Monitor and analyze message logs to ensure data is correctly produced, consumed, and processed.
• General QA Activities:
  • Collaborate with product managers, developers, and other stakeholders to understand requirements and define test strategies.
  • Create detailed, comprehensive, and well-structured test plans and test cases.
  • Perform regression, system integration, and end-to-end testing.
  • Log, track, and manage defects in a defect tracking system (e.g., Jira, Azure DevOps).
  • Actively participate in agile ceremonies, including daily stand-ups, sprint planning, and retrospectives.

Required Skills and Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent practical experience.
• 5+ years of experience in Quality Assurance with a focus on back-end systems.
• Strong proficiency in writing complex SQL queries for data validation.
• Hands-on experience with API testing tools (e.g., Postman, SoapUI).
• Experience with a modern programming language (e.g., Java, Python, C#) for understanding and maintaining automation scripts.
• Familiarity with test automation frameworks (e.g., Cucumber, TestNG, JUnit, Pytest).
• Practical experience with messaging tools, especially Apache Kafka.
• Solid understanding of the Software Development Life Cycle (SDLC) and Agile methodologies.
• Excellent analytical, problem-solving, and communication skills.
• A meticulous and detail-oriented approach to testing.

Preferred Skills (Nice to have):

• Experience with cloud platforms like AWS, Azure, or Google Cloud Platform.
• Knowledge of performance and load testing tools (e.g., JMeter, Locust).
• Experience with CI/CD tools (e.g., Jenkins, GitLab CI).
• Certification in Quality Assurance (e.g., ISTQB).