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.

Good to Have Skills:
• Experience with ETL tools like Informatica, Talend, DataStage, or Azure/AWS/GCP native ETL services (e.g., Dataflow, Glue).
• Knowledge of automation frameworks using Python/Selenium/pytest or similar tools for data testing.
• Familiarity with cloud data platforms – Snowflake, BigQuery, Redshift, etc.
• Basic understanding of CI/CD pipelines and QA integration.
• Exposure to data quality tools such as Great Expectations, Deequ, or DQ frameworks.
• Understanding of reporting/BI tools such as Power BI, Tableau, or Looker.