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 Design
Development
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:

Guidewire ETL QA "Mandatory Skills - Guidewire, ETL QA Guidewire, ETL QA with strong SQL. 5-8 years exp "strong Guidewire ETL QA with strong SQL and Data exp. Responsibilities: Test Planning and Strategy: o Develop and document comprehensive test plans, test cases, and test scripts for ETL processes related to Guidewire implementations. o Define testing strategies, methodologies, and best practices to ensure the reliability and integrity of data within the Guidewire framework. Guidewire Data Validation and Verification: o Perform data validation to ensure that ETL processes involving Guidewire products (PolicyCenter, BillingCenter, ClaimCenter) are functioning as expected. o Verify that data is accurately extracted from Guidewire systems, transformed correctly, and loaded into the target data warehouse or data marts. Test Execution: o Execute test cases and scripts to identify defects, inconsistencies, and issues in the ETL processes related to Guidewire data. o Conduct functional, integration, regression, and performance testing on Guidewire-related ETL processes. Defect Management: o Identify, document, and track defects and inconsistencies specific to Guidewire data. o Collaborate with ETL developers and data engineers to resolve identified issues. Automation: o Develop and maintain automated test scripts using appropriate testing tools and frameworks. o Implement and manage automated testing processes to enhance efficiency and coverage, with a focus on Guidewire-related data. Analysis and Reporting: o Analyze test results and provide detailed reports on testing activities, including metrics and KPIs related to Guidewire data. o Communicate findings, risks, and recommendations to stakeholders. Collaboration: Work closely with data architects, data analysts, developers, and business stakeholders to understand data requirements and ensure alignment with business goals. o Participate in design and code reviews to provide insights from a testing perspective, especially for Guidewire implementations. Compliance and Quality Assurance: o Ensure that ETL processes comply with data governance and quality standards. o Continuously improve testing processes and methodologies to enhance quality and efficiency, particularly for Guidewire data. Mandatory Skill Sets: 5+ years of experience in Guidewire, ETL testing, data warehousing, and data integration. Proficiency in SQL and experience with database technologies (e.g., Oracle, SQL Server, MySQL). Strong understanding of ETL concepts, tools (e.g., Informatica, Talend, SSIS), and data warehousing. Knowledge with Guidewire Insurance Suite applications (PolicyCenter, BillingCenter, ClaimCenter). Excellent analytical, problem-solving, and debugging skills. Strong attention to detail and ability to work in a fast-paced environment. Familiarity with JIRA for issue tracking and project management. Familiarity with Confluence for documentation and collaboration. Preferred Skill Sets: Experience with any cloud-based data platforms (e.g., AWS Redshift, Google BigQuery, Azure Synapse). Knowledge of any programming languages such as Python or Java. Familiarity with BI tools (e.g., Tableau, Power BI). Certification in testing or data-related fields (e.g., ISTQB, Certified Data Management Professional). Guidewire certification or relevant training in Guidewire products. Experience with automation testing tools and frameworks (e.g., Selenium, QTP, JUnit)."