Job description
REQUIREMENTS:
- Total experience 5+years.
- 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
Skills Required
Jira, Azure Devops, Power Bi, Etl