IT Testing & Quality Analyst-CW

Description: Conduct source-to-target data mapping validation based on business logic and technical specifications

Write and execute complex SQL queries (including JOIN operations, aggregate functions, subqueries, and window functions) to validate data completeness, transformation accuracy and integrity

Validate data constraints, default values, schema transformations, and boundary conditions

Compare large datasets to identify truncation, duplicated records, mismatched data types, or dropped records during ETL runs

Author, maintain, and execute structured test cases, test scripts, and test data sets in accordance with standard QA practices.

Participate in functional, regression, smoke, and integration testing cycles within Agile/Scrum delivery cadences

Attend daily standups, actively participate in scrum ceremonies (sprint planning, refinements sessions, sprint reviews ect.)

Document, log, and track data anomalies and bugs

Collaborate closely with ETL developers, business analysts and QA leads to investigate root causes and verify bug fixes

Contribute to status reports, test execution metrics, and QA sign-off documentation

Requirements : High school diploma

1-5 yrs of related experience

1-5 yrs of QA

1-5 yrs of SQL

Preference Related certifications

1-5 yr of HC knowledge

Previous experience