Manual QA Engineer

Codeworks Services is seeking a detail-oriented Manual QA Engineer to join our team in Ahmedabad, India. You will be responsible for testing a large, complex, data-centric enterprise application within the employee benefits domain. This role demands strong analytical thinking, the ability to grasp complex business rules, and practical experience with SQL queries for data validation. This is more than just a UI testing position; it involves in-depth data validation, intricate workflows, and scenario-based testing. As a tester in this role, you will gain comprehensive system knowledge over an estimated 3-4 months.

Key Responsibilities

• Testing & Quality Assurance: Understand complex employee benefits workflows, including policies, enrollments, and claims. Design end-to-end test scenarios encompassing multiple modules and data dependencies. Conduct manual functional testing, regression testing, and data validation. Create detailed test cases, test scenarios, and test data. Identify edge cases and complex real-world business scenarios.
• Data Validation & SQL Testing: Validate system results using SQL queries, comparing expected versus actual data across tables. Verify calculations, eligibility logic, insurance rules, policy mappings, and data transformations. Analyze production-like data to ensure accuracy.
• Defect Tracking: Identify, document, and track defects clearly. Provide reproducible steps and data scenarios. Verify bug fixes with thorough data validation.
• Scenario Creation: Generate complex test scenarios based on real business cases, diverse data combinations, and historical records, approaching testing from a practical business perspective.

Required Skills

• 2-4 years of experience in Manual Testing.
• Proficient SQL skills, including joins, subqueries, aggregations, and data comparison.
• Experience testing data-heavy applications.
• Solid understanding of test case design, regression testing, and data validation testing.
• Strong analytical and logical thinking abilities.
• Capacity to understand complex systems.

Beneficial Skills

• Experience in the Insurance domain, HRMS, Payroll, or Benefits systems.
• Experience with large enterprise applications.
• Basic API testing knowledge.
• Familiarity with tools such as Jira/Azure DevOps and test case management tools.
• Understanding of relational databases, with SQL Server experience being a plus.

What Success Looks Like

• Independent testing of complex workflows.
• Proficient SQL-based data validation.
• Identification of logical and data-related bugs.
• Creation of insightful test scenarios.
• Deep system understanding.
• Proactive suggestions for improvement beyond test execution.
• A strong data-driven approach focused on business logic and SQL validation.

Why Join Us

• Work on a mature enterprise product.
• Gain deep domain knowledge in benefits and insurance.
• A role offering high ownership.
• Long-term career stability.
• Significant technical learning opportunities in data validation.