Quick overview
Job description
Job Title: Senior Consultant - Facets Claims & Informatica
Location: Rochester, NY (Hybrid – Remote available)
Experience: 7-10 Years
Shift: Day Shift
Job Summary
We are seeking a highly experienced Senior Consultant with strong expertise in Facets, Healthcare Claims, Informatica, SQL, and PL/SQL. The ideal candidate will possess deep knowledge of healthcare payer systems, claims processing, and existing Facets architecture. The consultant will be responsible for supporting and enhancing data integration processes, analyzing claims data, troubleshooting application issues, and collaborating with business and technical teams to deliver scalable healthcare solutions.
Required Skills
- Facets
- Healthcare Claims Domain
- Informatica PowerCenter
- SQL
- PL/SQL
- Healthcare Payer Systems
- Data Analysis & Troubleshooting
Nice-to-Have Skills
- Enterprise Data Warehouse (EDW)
- Oracle Database
- Healthcare Membership & Enrollment
- Production Support
- Data Modeling
- Healthcare Reporting & Analytics
Key Responsibilities
- Provide subject matter expertise in Facets Claims processing and architecture.
- Analyze business requirements and translate them into technical solutions.
- Design, develop, and support Informatica ETL workflows and mappings.
- Develop and optimize complex SQL and PL/SQL queries, stored procedures, and database objects.
- Support healthcare claims processing, adjudication, and data integration requirements.
- Investigate and resolve production issues related to Facets, claims data, and ETL processes.
- Collaborate with business stakeholders, architects, analysts, and development teams.
- Perform impact analysis for system enhancements and regulatory changes.
- Ensure adherence to SDLC, coding standards, and data governance practices.
- Participate in code reviews, testing, deployment, and production support activities.
- Create and maintain technical and operational documentation.
- Mentor junior team members and provide technical guidance.
Preferred Qualifications
- Bachelor's degree in Computer Science, Information Technology, or related field.
- Strong understanding of Healthcare Payer operations and Claims lifecycle.
- Hands-on experience with Facets data structures and claims modules.
- Experience with Informatica PowerCenter development and support.
- Advanced SQL and PL/SQL programming skills.
- Experience working with large healthcare data environments.
- Strong analytical, troubleshooting, and communication skills.
Certifications (Preferred)
- Informatica PowerCenter Developer Certification
- Facets-related functional or technical certification
- Healthcare domain certifications
Similar jobs
- DS
Senior Systems Engineer with Security ClearanceRecently posted
Data Systems Analysts, Inc (DSA) · Fort Detrick, MD · Hybrid · Posted 17 Nov 2026 🇺🇸
Generative AILinuxNetwork AdministrationTechnology$130k - $140k/yr - CM
Software EngineerRecently posted
Computer Merchant, Ltd., The · Burlington, MA · Hybrid · Posted 17 Nov 2026 🇺🇸
DockerMongoDBSpring+11Technology$80 - $87/hr - IT

VDI/VMware Horizon Administrator with Security ClearanceRecently posted
ISPA Technology · Panama City Beach, FL · Hybrid · Posted 17 Nov 2026 🇺🇸
VMwareTechnologySalary not listed - LE

Senior Data Analyst with Security ClearanceRecently posted
Leidos · Englewood, CO · Hybrid · Posted 17 Nov 2026 🇺🇸
SQLMicrosoft ExcelMicrosoft Office+8Technology$92.3k - $166.8k/yr - TS

Full Stack Software Engineer with Security ClearanceRecently posted
The Swift Group · Herndon, VA · On-site · Posted 17 Nov 2026 🇺🇸
DockerNext.jsSQL+19Technology$5k/mo - DO

Cybersecurity Consultant / NIST CSF 2.0 SpecialistRecently posted
dotSolved · United States · Remote · Posted 16 Nov 2026 🇺🇸
SplunkTechnologySalary not listed - ES
Embedded C++ DeveloperRecently posted
ENIN SYSTEMS INC · San Diego, CA · Hybrid · Posted 16 Nov 2026 🇺🇸
SVNGitEmbedded Systems+8TechnologySalary not listed - DS
Junior Site Reliability Engineering (SRE)Recently posted
Decision Six Inc. · Alpharetta, GA · Hybrid · Posted 16 Nov 2026 🇺🇸
OracleShellAWS+8TechnologySalary not listed - GL
Java Developer - Plano, TX - W2Recently posted
Geopaq Logic · Plano, TX · Hybrid · Posted 16 Nov 2026 🇺🇸
OracleSQLSpring+11TechnologySalary not listed - SF

AVP iOS Software Development Engineer III - MySynchrony - Synchrony FinancialRecently posted
Synchrony Financial · Stamford, CT · On-site · Posted 17 Nov 2026 🇺🇸
SwiftSwiftUIUIKit+3Technology$100k - $170k/yr - SF

AVP iOS Software Development Engineer III - MySynchrony - Synchrony FinancialRecently posted
Synchrony Financial · West Chester, PA · On-site · Posted 17 Nov 2026 🇺🇸
SwiftSwiftUIUIKit+3Technology$100k - $170k/yr - SF

VP, AI Security Architect Lead - Synchrony FinancialRecently posted
Synchrony Financial · Alpharetta, GA · On-site · Posted 17 Nov 2026 🇺🇸
Generative AITechnology$130k - $210k/yr
