ETL Consultant - Azure Data Factory, Guidewire

Key Responsibilities:

• Design, develop, and maintain robust ETL pipelines using

  Azure Data Factory (ADF)

  to support complex insurance data workflows.
• Integrate and extract data from various

  Guidewire

  modules (PolicyCenter, BillingCenter, ClaimCenter) ensuring data quality, integrity, and consistency.
• Build reusable components for data ingestion, transformation, and orchestration across Guidewire and Azure ecosystems.
• Optimize ADF pipelines for performance, scalability, and cost-efficiency while adhering to industry-standard DevOps and CI/CD practices.
• Collaborate with solution architects, data modelers, and Guidewire functional teams to translate business requirements into scalable ETL solutions.
• Conduct thorough unit testing, data validation, and error handling across all data transformation steps.
• Participate in end-to-end data lifecycle management, from requirement gathering through deployment and post-deployment support.
• Provide technical documentation, pipeline monitoring dashboards, and ensure production readiness. Support data migration projects involving legacy platforms to Azure cloud environments.
• Follow Agile/Scrum practices, contribute to sprint planning, retrospectives, and stand-ups with strong ownership of deliverables.

• 6+ years of experience in data engineering with strong command over

  Azure Data Factory

  ,

  Azure SQL

  , and related Azure services.
• Deep hands-on experience in building ADF pipelines integrating with

  Guidewire Insurance Suite

  .
• Proficiency in data transformation using

  SQL

  ,

  Stored Procedures

  , and

  Data Flows

  .
• Experience working on

  Guidewire data models

  , understanding of PC/Billing/Claim schema and business entities.
• Strong understanding of

  cloud-based data warehousing concepts

  , data lake patterns, and data governance best practices.

• Excellent debugging skills, with the ability to resolve complex data transformation and pipeline performance issues.

• Prior experience in

  Insurance (P&C preferred)

  domain or implementing

  Guidewire DataHub

  and/or

  InfoCenter

  .
• Familiarity with

  Power BI

  ,

  Databricks

  , or

  Synapse Analytics

  .
• Working knowledge of Git-based source control, CI/CD pipelines, and deployment automation.

Additional Requirements:

• Work Mode:

  100% Onsite - Hyderabad office (No remote/hybrid flexibility).
• Strong interpersonal and communication skills; must be capable of working with cross-functional teams and client stakeholders.
• Self-starter mindset with a high sense of ownership; must thrive under pressure and tight deadlines.