Manual QA Engineer (Data-Centric / SQL-Heavy Applications)

Company DescriptionWith 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 DescriptionWe 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 ~34 months).Key ResponsibilitiesTesting & Quality AssuranceUnderstand 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 TestingValidate 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 TrackingIdentify, document, and track defects clearly.Provide reproducible steps and data scenarios.Verify bug fixes with data validation.Scenario CreationGenerate complex test scenarios based on: Real business cases, Data combinations, Historical records, think from a real-world business perspective.Required Skills24 years' experience in Manual TestingStrong SQL skills (joins, subqueries, aggregations, data comparison)Experience testing data-heavy applicationsGood understanding of:Test case designRegression testingData validation testingStrong analytical and logical thinkingAbility to understand complex systemsGood to HaveExperience in Insurance domain, HRMS, Payroll, Benefits systemsExperience with large enterprise applicationsBasic API testing knowledgeExperience with tools like:Jira / Azure DevOpsTest case management toolsUnderstanding of relational databases (SQL Server preferred)What Success Looks Like in This RoleAbility to independently test complex flowsStrong SQL-based data validationCatching logical and data-related bugsCreating meaningful scenariosUnderstanding system deeplyProviding 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 UsWork on a mature enterprise productDeep domain learning (benefits/insurance)High ownership roleLong-term stabilityStrong technical learning in data validation .