Job description

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.

Requirements