Full Description

Company Description With around a decade of experience founded in 2015, Codeworks Services has turned itself as a trusted provider of IT services for businesses across industries. Over the years, we have helped businesses spread across the US and UK by leveraging technology to drive efficiency and growth through custom software development, cloud app development, and effective web solutions.

Role Description We are looking for a detail-oriented Manual QA Engineer who can test a large, complex, data-centric enterprise application related to employee benefits domain. The role requires strong analytical thinking, ability to understand complex business rules, and hands-on experience with SQL queries for data validation. This is not a UI-only testing role. The system involves deep data validation, complex workflows, and scenario-based testing. A tester in this role will gradually build strong system knowledge (typically takes ~3–4 months).

Key Responsibilities Testing & Quality Assurance Understand complex business workflows related to employee benefits, policies, enrollments, and claims. Design end-to-end test scenarios covering multiple modules and data dependencies. Perform 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. Compare expected vs actual data across tables.

Verify: Calculations, Eligibility logic, Insurance rules, Policy mappings, 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 data validation. Scenario Creation

Generate complex test scenarios based on: Real business cases, Data combinations, Historical records, think from a real-world business perspective.

Required Skills 2–4 years' experience in Manual Testing Strong SQL skills (joins, subqueries, aggregations, data comparison) Experience testing data-heavy applications

Good understanding of

• Test case design
• Regression testing
• Data validation testing
• Strong analytical and logical thinking
• Ability to understand complex systems
• Good to Have
• Experience in Insurance domain, HRMS, Payroll, Benefits systems
• Experience with large enterprise applications
• Basic API testing knowledge

Experience with tools like

• Jira / Azure DevOps
• Test case management tools
• Understanding of relational databases (SQL Server preferred)