Quality Analyst

Job Title – Quality Analyst

Exp – 5+ Years

Key Responsibilities:
• Understand business requirements and data flows to create comprehensive test plans and test cases for ETL jobs.
• Perform data validation and reconciliation between source systems, staging, and target data stores (DWH, data lakes, etc.).
• Develop and execute automated and manual tests to ensure data accuracy and quality.
• Work with SQL queries to validate data transformations and detect anomalies.
• Identify, document, and track defects and inconsistencies in data processing.
• Collaborate with data engineering and BI teams to improve ETL processes and data pipelines.
• Maintain QA documentation and contribute to continuous process improvements.

Must Have Skills:
• Strong SQL skills – ability to write complex queries for data validation and transformation testing.
• Hands-on experience in ETL testing – validating data pipelines, transformations, and data loads.
• Knowledge of data warehousing concepts – dimensions, facts, slowly changing dimensions (SCD), etc.
• Experience in test case design, execution, and defect tracking.
• Experience with QA tools like JIRA, TestRail, or equivalent.
• Ability to work independently and collaboratively in an Agile/Scrum environment.