Guidewire ClaimCenter Systems Integration Support Engineer XML/SQL

Responsible for monitoring and troubleshooting production integration failures, investigating Sonic and EDW validation errors, performing root-cause analysis, analyzing and remediating XML payloads, resolving data-quality issues, and validating successful downstream processing. Responsibilities: Push Developer with strong production support and application support experience across Guidewire ClaimCenter, Sonic integrations, EDW, MarkLogic, Claims Data Mart (CDM), and Snowflake.

Our client, an IT Services and Consulting company, is looking for a Guidewire ClaimCenter Systems Integration Support Engineer – XML/SQL for their Cincinnati, OH/Remote location.
 
Responsibilities:

• Push Developer with strong production support and application support experience across Guidewire ClaimCenter, Sonic integrations, EDW, MarkLogic, Claims Data Mart (CDM), and Snowflake.
• Responsible for monitoring and troubleshooting production integration failures, investigating Sonic and EDW validation errors, performing root-cause analysis, analyzing and remediating XML payloads, resolving data-quality issues, and validating successful downstream processing.
• Collaborates with business, application, integration, and data teams to restore impacted processing, resolve defects, support deployments, and maintain production stability.
• Provide production support for Claims Management applications and integrations, troubleshooting incidents involving ClaimCenter, Sonic, EDW, MarkLogic, CDM, and Snowflake.
• Investigate Sonic production failures, EDW validation errors, failed messages, and transactionprocessing issues using SQL Server Management Studio (SSMS).
• Perform rootcause analysis (RCA) for production defects and dataprocessing failures by tracing transactions across source and downstream systems.
• Research ClaimCenter claim, payment, reserve, check, exposure, and contact data to identify sourcedata and integration issues.
• Analyze problematic XML payloads and XSLT transformations, identify validation or EBIrelated issues, and perform payload corrections when remediation is required.
• Build, test, validate, and regenerate XML payloads using SoapUI to reproduce issues and confirm fixes.
• Use Beyond Compare and Notepad++ to compare payload versions, analyze XML/XSLT differences, and validate modifications.
• Review Guidewire and integration code using IntelliJ IDEA to assist with defect investigation and troubleshooting.
• Validate downstream processing across EDW, MarkLogic, Claims Data Mart (CDM), and Snowflake, including dataquality and sourcetotarget validation.
• Support the production incident lifecycle, including issue investigation, defect identification, remediation, testing, validation, and coordination with relevant technical and business teams.
• Assist with deployment and postdeployment validation, confirming that corrected transactions and messages are processed successfully through downstream systems.
• Track production incidents and operational activities through ServiceNow, including incidents, knowledge articles, access requests, and troubleshooting procedures.
• Maintain Excelbased operational trackers for Sonic errors, claims, Unique IDs, defects, remediation activities, testing results, and production issue status.
• Collaborate through Microsoft Teams with business, application, integration, and data teams during incident investigation, defect resolution, testing, and deployments.
• Create and maintain troubleshooting and productionsupport documentation and provide knowledge transfer and mentoring on Sonic error analysis and payloadremediation processes.
• Leverage GitHub Copilot and Microsoft Copilot to accelerate SQL development, payload analysis, technical research, documentation, and troubleshooting activities.

 
Requirements:

• Years of Experience: 12.00 Years of Experience

 
Why Should You Apply?

• Health Benefits
• Referral Program
• Excellent growth and advancement opportunities

Why Should You Apply?

• Health Benefits
• Referral Program