Role & seniority: Manual QA Engineer (mid-level, ~2–4 years in manual testing); data-centric, enterprise scope.

Stack/tools: Manual testing of data-heavy apps; SQL querying for data validation; Jira or Azure DevOps; test case management tools; relational DBs (SQL Server preferred); basic API testing (bonus).

Top 3 responsibilities

Design and execute end-to-end test scenarios for complex employee benefits workflows (policies, enrollments, claims) and data dependencies.
Perform manual functional/regression testing and data validation; create detailed test cases and data; identify edge cases.
Validate system results with SQL queries, compare expected vs actual data, track and verify defects with reproducible steps.

Must-have skills

2–4 years of manual testing experience; strong analytical/logical thinking.
Proficient SQL skills (joins, subqueries, aggregations) and data validation across multiple tables.
Experience testing data-heavy, enterprise applications; ability to understand complex systems and business rules.

Nice-to-haves

Insurance, HRMS, payroll, or benefits domain experience; familiarity with large enterprise apps.
Basic API testing knowledge; familiarity with Jira/Azure DevOps and test case management tools.
Understanding of data transformations and production-like data validation.
Location & work type: Not specified; presumed full-time role with remote/onsite options depending on client needs.

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)

What Success Looks Like in This Role Ability to independently test complex flows Strong SQL-based data validation Catching logical and data-related bugs Creating meaningful scenarios Understanding system deeply Providing suggestions rather than just writing and executing test cases Strong data-driven tester focused on business logic and SQL validation, not just another UI-only QA.

Why Join Us Work on a mature enterprise product Deep domain learning (benefits/insurance) High ownership role Long-term stability Strong technical learning in data validation