About the Role :
We are seeking a skilled and detail-oriented Guidewire ETL Developer with deep expertise in Cloud Data Access (CDA) and Azure DevOps to drive complex data migration and integration efforts for Guidewire InsuranceSuite products, including PolicyCenter, BillingCenter, and ClaimCenter. This role involves building robust ETL pipelines, managing data flows from legacy systems to Guidewire applications, and ensuring accuracy, performance, and governance throughout the process.
Key Responsibilities :
Design and Implement ETL Solutions :
- Develop scalable and optimized ETL workflows using Guidewire Cloud Data Access (CDA) to support structured data migration from legacy insurance systems into Guidewire InsuranceSuite.
Data Mapping and Transformation :
Interpret data schemas and perform source-to-target mapping, transformation logic, cleansing, validation, and enrichment activities using SQL and scripting tools.CI / CD Pipeline Development :
Build and manage Azure DevOps Pipelines (YAML / classic) for automating ETL deployment, configuration, validation, and monitoring processes.Integration Collaboration :
Work closely with configuration, integration, data modeling, and QA teams to align data ingestion with Guidewire schema, business rules, and release and Troubleshooting :Proactively monitor ETL pipelines and jobs for performance, throughput, and data quality. Investigate and resolve failures and bottlenecks using logs and telemetry.Documentation and Governance :
Maintain detailed documentation for technical specifications, migration strategies, transformation rules, and validation procedures. Support audit and compliance needs.Required Skills and Qualifications :
Guidewire CDA Expertise :
Hands-on experience designing and deploying data migration workflows using Guidewire Cloud Data Access (CDA).Guidewire Data Model Knowledge :
Solid understanding of Guidewire's canonical data models for PolicyCenter (PC), BillingCenter (BC), and ClaimCenter (CC).Azure DevOps Proficiency :
Experience in building and managing CI / CD pipelines using Azure DevOps (Pipelines, Repos, Artifacts), including branching strategies and automation.SQL and Data Engineering :
Strong command over SQL, relational data structures, data profiling techniques, performance tuning, and bulk loading operations.ETL Best Practices :
Proven experience in implementing data quality checks, error handling, incremental loading, and reconciliation strategies for large-scale ETL processes.Project Experience :
Participation in at least one full-cycle Guidewire data migration project involving legacy-to-Guidewire transition.(ref : hirist.tech)