Facets Claims & Informatica Developer / Consultant (5+ Years Long Term Contract)

Job Title: Facets Claims & Informatica Developer / Consultant

Location: Rochester, NY

Work Arrangement: Remote

Employment Type: Contract

Duration: 5+ Years Long Term Contract

Domain: Healthcare Payer

Pay Rate: $50.00/hr W2 | $60.00/hr C2C

Application Deadline: Oct 29th 2026

The information below covers the role requirements, expected candidate experience, and accompanying qualifications.

SKILLS REQUIRED

Primary (Must-Have):

• Facets

• Healthcare Claims Domain

• Informatica PowerCenter

• SQL

• PL/SQL

• Healthcare Payer Systems

• Data Analysis & Troubleshooting

Secondary (Good to Have):

• Enterprise Data Warehouse (EDW)

• Oracle Database

• Healthcare Membership & Enrollment

• Production Support

• Data Modeling

• Healthcare Reporting & Analytics

POSITION OVERVIEW

Seeking a Senior Consultant to join the Healthcare Payer Solutions division, reporting to the Technical Delivery Manager. The selected candidate will drive end-to-end data integration, optimize claims processing workflows, and enhance existing Facets system architecture. This role solves complex scalable data delivery challenges, ensuring seamless healthcare claims adjudication and regulatory alignment for the client.

ROLES & RESPONSIBILITIES

• Design, develop, support, and optimize Informatica ETL workflows, mappings, and complex SQL/PL/SQL queries daily.

• Provide deep subject matter expertise in Facets Claims processing, architecture, and system data structures.

• Support healthcare claims processing, adjudication, data integration, and investigate production issues.

• Analyze business requirements, perform impact analysis for system/regulatory changes, and collaborate with technical stakeholders.

• Maintain SDLC standards, conduct code reviews, deliver operational documentation, and mentor junior technical team members.

BENEFITS

Medical | Dental | Vision | 401(k)

EEOC Compliance:

We are an equal opportunity employer, and all qualified applicants will receive consideration for employment.

DISCLAIMER

AI Usage Policy: Pacer Group uses AI to assist in screening applications. xzgxqkn Final hiring decisions are made by human recruiters based on qualifications and experience.