Senior SQL Developer WITH Azure ADF Guidewire ClaimCenter Data Migration

Job Title: Senior SQL Developer WITH Azure ADF Guidewire ClaimCenter Data Migration

Warren , NJ (Onsite)

Contract

Job Summary

We are seeking an experienced Azure Data Factory (ADF) Developer with strong SQL and Guidewire ClaimCenter data migration expertise. The candidate will play a key role in designing, developing, and executing data migration strategies to transition claims data from legacy systems into the Guidewire ClaimCenter platform within the Property & Casualty (P&C) insurance domain.

Key Responsibilities

• Design, build, and maintain Azure Data Factory (ADF) pipelines to support end-to-end data migration to Guidewire ClaimCenter.
• Develop and optimize SQL scripts, stored procedures, and data validation routines for migration workflows.
• Work with business and technical teams to define data mapping, transformation, and loading logic.
• Implement error handling, logging, and audit mechanisms within ADF processes.
• Perform data quality checks, reconciliation, and migration validation against source and target systems.
• Collaborate with domain SMEs to ensure alignment with Guidewire data models and ClaimCenter schemas.
• Document technical designs, mappings, and migration processes.
  
  

Required Skills

• Strong hands-on experience with Azure Data Factory (ADF) and Azure Data Services (Data Lake, Synapse, SQL DB).
• Advanced proficiency in SQL and T-SQL development.
• Solid understanding of Guidewire ClaimCenter data structures and integration patterns.
• Proven experience in data migration projects (preferably within P&C insurance).
• Strong analytical, problem-solving, and communication skills.
  
  

Preferred Skills

• Experience with Guidewire PolicyCenter or BillingCenter.
• Familiarity with Azure Logic Apps, Data Lake, or Synapse pipelines.
• Knowledge of ETL best practices, data governance, and compliance in insurance systems.