QA Manual Testing

Role Overview: As a QA Manual Tester for the position located in Pune & Gurgaon (Hybrid), your main responsibility will be to understand business requirements and data flows in order to create comprehensive test plans and test cases for ETL jobs. You will be expected to perform data validation and reconciliation between source systems, staging, and target data stores, such as DWH and data lakes. Additionally, you will need to develop and execute both automated and manual tests to ensure data accuracy and quality. Working with SQL queries to validate data transformations and detect anomalies will also be a key part of your role. Identifying, documenting, and tracking defects and inconsistencies in data processing will be crucial, along with collaborating with data engineering and BI teams to improve ETL processes and data pipelines. Maintaining QA documentation and contributing to continuous process improvements will also be part of your responsibilities. 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. Qualification Required: - Strong SQL skills with the ability to write complex queries for data validation and transformation testing. - Hands-on experience in ETL testing, including validating data pipelines, transformations, and data loads. - Knowledge of data warehousing concepts like 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. Additional Details: No additional details provided in the job description.,