Responsibilities:

• Guidewire CDA Integration: Utilize Guidewire Cloud Data Access (CDA) to extract, transform, and load (ETL) Guidewire data into downstream systems, ensuring data availability for reporting and analytics.

• Data Pipelines & ETL Development: Design, build, and maintain scalable and efficient ETL pipelines that integrate Guidewire data with data warehouses, data lakes, and other enterprise systems.

• Data Modeling & Architecture: Work closely with Data Architects to develop, optimize, and manage Guidewire data models and schema, ensuring high performance and scalability.

• Cloud Integration: Implement cloud-based data engineering solutions using platforms like AWS, Azure, or GCP, ensuring smooth integration of Guidewire data with cloud services.

• Data Quality & Governance: Ensure data integrity, accuracy, and compliance with data governance standards across all Guidewire-related data pipelines and integrations.

• Performance Tuning & Optimization: Optimize data processing workflows and queries to ensure high performance, minimizing delays in data availability.

• Collaboration: Collaborate with business analysts, data architects, and other IT teams to translate business requirements into effective data engineering solutions.

• Automation: Build and maintain automation processes for regular data loads, ensuring reliable data ingestion and processing with minimal manual intervention.

• Documentation & Best Practices: Maintain clear documentation of data engineering processes, data flows, and pipeline architecture, while adhering to industry best practices.

  Technical Skills:

• 10+ years of experience in data engineering or a similar role.

• 3+ years of experience with Guidewire Insurance Suite (PolicyCenter, BillingCenter, ClaimCenter).

• 2+ years of hands-on experience with Guidewire Cloud Data Access (CDA) for data extraction and integration.

• Proven experience in building ETL pipelines and integrating Guidewire data with cloud-based and on-premises systems.

• Strong SQL and PL/SQL skills for querying and transforming Guidewire data.

• Proficiency with data integration and ETL tools such as Informatica, PySpark etc.

• Experience with Azure cloud platforms for data storage, processing, and integration.

• Familiarity with big data technologies and modern data architecture.

• Hands-on experience with APIs and microservices for data integration.

  Knowledge of version control systems (e.g., Git) and CI