Hands-on experience in ETL Testing and Manual Testing
Strong knowledge of ETL Concepts and data movement processes.
Expertise in SQL with the ability to write and understand complex queries (Joins, Window Functions, Aggregations, Subqueries).
Familiarity with Data Warehousing principles and Dimensional Modeling (Star and Snowflake schemas).
Proficiency in Power BI for report and dashboard validation.
Experience working in Agile/Scrum development environments.
Experience with defect management tools such as JIRA, Azure DevOps, etc.
Knowledge of Python for scripting and automation tasks.
Write and maintain comprehensive test cases and test scenarios for data and report validation.
Excellent communication and documentation skills.
RESPONSIBILITIES:
Understanding the projects functional and non-functional requirements and the business context of the application being developed. Understanding and documenting requirements validated by the SMEs
Interacting with clients to identify the scope of testing, expectations, acceptance criteria and availability of test data and environment. Working closely with product owner in defining and refining acceptance criteria.
Preparing test plan/strategy
Estimating the test effort and preparing schedules for testing activities, assigning tasks, identifying constraints and dependencies
Risk management identifying, mitigating and resolving business and technical risks. Determines the potential causes of problems and analyses multiple alternatives.
Designing and developing a framework for automated testing following the project's design and coding guidelines. Set up best practices for test automation.
Preparing test reports to summarize the outcome of the testing phase and recommending whether the application is in a shippable state or not
Communicating measurable quality metrics, with the ability to highlight problem areas and suggest solutions
Participating in retrospective meetings, helping identify the root cause of any quality related issue and identifying ways to continuously improve the testing process
Conducting demos of the application for internal and external stakeholders
Reviewing all testing artifacts prepared by the team and ensuring that defects found during the review are tracked to closure
Working with team and stakeholders to triage and prioritize defects for resolution
Giving constructive feedback to the team members and setting clear expectations
