Highlights
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.
Numbers & Facts
| Location | Cincinnati, OH |
| Industry | Management Consulting Services |
| Salary | $57.14 Per Hour |
| Company Size | 2,000 to 2,499 employees |
| Year Founded | 2000 |
| Website | https://www.iconma.com/ |
Description
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:
Requirements:
Why Should You Apply?
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
Benefits
401K, Employee Referral Program, Life Insurance
About Company
ICONMA is a global information consulting management firm providing Professional Staffing Services and Project-Based Solutions for organizations in a broad range of industries.
- Corporate Headquarters in Troy, Michigan; 20+ locations worldwide.
- Certified Woman-Owned Business Enterprise (WBE); certified by Women’s Business Enterprise National Council, National Women Business Owners Corporation (NWBOC); and California Public Utilities Commission (CPUC).
- Founded in 2000
- 2000+ Employees
The company was founded on the principle that success is derived from delivering high quality service and resources in the most responsive, flexible, and innovative way. ICONMA invests in people and resources with a single goal: To provide our customers with the highest quality service in the most responsive manner. Through its network of offices, ICONMA provides the resources to help clients maintain their competitive advantage.