Role Description
Role Proficiency:Ensuring adherence to test practices and process to improve test coverage
Outcomes:
- Create Test Estimates and Schedules
- Identify business processes conduct risk analysis and ensure test coverage
- Ensure adherence of processes and standards
- Produce test results defect reports test logs and reports for evidence of testing
- Publish RCA reports and preventive measures
- Report progress of testing
- Contribute for Revenue savings for client by suggesting alternate method
- Quality of Deliverables
Measures Of Outcomes:
- Test Script Creation and Execution Productivity
- Defect Leakage Metrics (% of defect leaked % of UAT defects and % of Production defects)
- % of Test case reuse
- Test execution Coverage
- Defect Acceptance Ratio
- Test Review efficiency
Outputs Expected:
Test DesignDevelopment
Execution:
- Participate in review walkthrough demo and obtain sign off by stakeholder for Test Design
- Prepare Test summary report for modules/features
Requirements Management:
- Analyse Prioritize Identify Gaps and create workflow diagrams based on Requirements/User stories
Manage Project:
- Participate in Test management
Domain Relevance:
- Identify business processes conduct risk analysis and ensure test coverage
Estimate:
- Prepare Estimate Schedule Identify dependencies
Knowledge Management:
- Consume Contribute Review (Best Practices Lesson learned Retrospective)
Test Design
Execution:
- Test Plan preparation Test Case/Script Creation Test Execution
Test & Defect Management:
- Conduct root cause and trend analysis of the defects
Test Planning:
- Identify the test scenarios with understanding of systems interfaces and application
- Identify end-to-end business critical scenarios with minimal support
- Create/Review the test scenarios and prepare RTM
Skill Examples:
- Ability to create and manage a test plan
- Ability to prepare schedules based on estimates
- Ability to track and report progress
- Ability to identify test scenarios and prepare RTM
- Ability to analyse requirement/user stories and prioritize testing
- Ability to carry out RCA
- Ability to capture and report metrics
Knowledge Examples:
- Knowledge of Estimation techniques
- Knowledge of Testing standards
- Knowledge of identifying the scope of testing
- Knowledge of RCA Techniques
- Knowledge of Test design techniques
- Knowledge of Test methodologies
Additional Comments:
We are looking for a meticulous and proactive ETL Tester to ensure the accuracy, reliability, and performance of data pipelines built on Google Cloud Platform. This role involves validating ETL workflows, reconciling data across systems, and collaborating with developers and business stakeholders to uphold data quality standards. The ideal candidate will have experience in designing test strategies, creating reusable test assets, and automating validation processes. Key Responsibilities Design and implement comprehensive test plans, test cases, and test scenarios for ETL pipelines Create and maintain test certificates and validation documentation for audit and compliance purposes Perform data reconciliation and validation checks across multiple systems and sources Collaborate with developers to identify and resolve data mismatches and transformation issues Automate test execution using scripting tools and frameworks Conduct regression, integration, and performance testing for data workflows Document defects and track resolution through version control and issue tracking systems Support UAT and production validation efforts with business stakeholders Required Skills & Qualifications Strong experience in ETL testing and data validation Proficiency in SQL and Google BigQuery for data analysis and test design Familiarity with Python or other scripting languages for test automation Understanding of Apache Airflow and ETL orchestration tools Experience with GitHub or similar tools for version control and collaboration Excellent attention to detail and analytical thinking Strong communication skills and ability to work in cross-functional teams Nice to Have Exposure to CI/CD pipelines and DevOps practices Experience with cloud platforms like AWS, Azure, or GCP Familiarity with data warehousing and data governance principles
Skills
Etl Testing,SQL & BigQuery,Python,Github