ETL tester_Guidewire/Insurance domain _KOLKATA ONLY

Role & responsibilities

• Test Planning and Strategy:

• Develop and document comprehensive test plans, test cases, and test scripts for ETL processes related to Guidewire implementations.
• Define testing strategies, methodologies, and best practices to ensure the reliability and integrity of data within the Guidewire framework.

• Guidewire Data Validation and Verification:

• Perform data validation to ensure that ETL processes involving Guidewire products (PolicyCenter, BillingCenter, ClaimCenter) are functioning as expected.
• Verify that data is accurately extracted from Guidewire systems, transformed correctly, and loaded into the target data warehouse or data marts.

• Test Execution:

• Execute test cases and scripts to identify defects, inconsistencies, and issues in the ETL processes related to Guidewire data.
• Conduct functional, integration, regression, and performance testing on Guidewire-related ETL processes.

• Defect Management:

• Identify, document, and track defects and inconsistencies specific to Guidewire data.
• Collaborate with ETL developers and data engineers to resolve identified issues.

• Automation:

• Develop and maintain automated test scripts using appropriate testing tools and frameworks.
• Implement and manage automated testing processes to enhance efficiency and coverage, with a focus on Guidewire-related data.

• Analysis and Reporting:

• Analyze test results and provide detailed reports on testing activities, including metrics and KPIs related to Guidewire data.
• 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.
• Participate in design and code reviews to provide insights from a testing perspective, especially for Guidewire implementations.

• Compliance and Quality Assurance:

• Ensure that ETL processes comply with data governance and quality standards.
• Continuously improve testing processes and methodologies to enhance quality and efficiency, particularly for Guidewire data.

Preferred candidate profile

• 3+ years of experience in 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.
• Experience 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.

Location: PAN India