Search by job, company or skills

5-7 Years
Not Disclosed
Early Applicant
  • Posted 2 days ago
  • Be among the first 10 applicants

Job Description

Role Overview

Seeking a Senior Data QA professional with 5+ years of experience, strong P&C Insurance domain knowledge, and hands-on expertise in Guidewire Data Studio & Explore. The candidate should have strong skills in SQL, data validation, ETL/ELT, data warehousing, reconciliation, and reporting analytics, with the ability to independently manage end-to-end data testing across Guidewire and integrated data platforms.

Key Responsibilities

  • Validate Guidewire Data Studio datasets, data models, transformations, and data pipelines.
  • Test Guidewire Explore reports, dashboards, KPIs, aggregations, and business calculations.
  • Perform end-to-end data validation and reconciliation across Guidewire PolicyCenter, BillingCenter, ClaimCenter, and downstream analytical systems.
  • Validate ETL/ELT processes, source-to-target mappings, incremental loads, and data transformations.
  • Perform data quality, integrity, and reconciliation checks across data lake, data warehouse, and reporting layers.
  • Validate dimensional models, historical data, business rules, and insurance-specific metrics.
  • Develop complex SQL queries for data validation, reconciliation, and defect analysis.
  • Perform reporting validation, regression testing, defect management, and root-cause analysis.
  • Collaborate with Guidewire, data engineering, and reporting teams to ensure data accuracy and reliability.

Required Skills & Experience

  • 5+ years in Data QA, including ETL/ELT, data warehouse, and reporting testing.
  • Hands-on experience with Guidewire Data Studio & Explore.
  • Strong P&C Insurance domain knowledge across policy, billing, and claims.
  • Advanced SQL skills for data validation, transformations, and reconciliation.
  • Experience in data pipelines, data modeling, data quality, and source-to-target validation.
  • Experience testing analytical datasets, BI reports, dashboards, and KPIs.
  • Ability to independently own testing activities and troubleshoot complex data issues.

Good-to-Have Skills

  • Exposure to Snowflake, Databricks, Azure Data Lake, AWS, or similar platforms.
  • Python/SQL-based test automation.
  • Power BI, Tableau, or similar reporting tools.
  • Dimensional modeling, data marts, and data migration validation.

More Info

Job Type:
Industry:
Function:
Employment Type:

Key Skills

data pipelines

analytical datasets

Guidewire Data Studio

Guidewire Explore

KPIs

source-to-target validation

Similar Jobs

8-10 yrs
Hyderabad, India
Skills:
data qa , Structured Query Language (SQL), Excel, Python, Data Analysis
5-8 yrs
Hyderabad, Chennai
Skills:
AWS, Azure, Python, Spark, Databricks, Etl, Data Quality Analyst
8-10 yrs
Hyderabad, India
Skills:
Azure DevOps Server, SSIS 2022, SSAS 2017, SQL Server Agent, metadata management practices, SSRS 2014, CI CD, Microsoft SQL Server 2022, data governance frameworks