Loading, Please wait..!!
Sr Consultant
-
Posted on: Nov 16, 2026
-
Rochester, New York
-
Salary: $53 per hour
-
Remote
-
Full-time
Curious about compensation?
Explore the historical salary trends, average pay, and estimated compensation for Sr Consultant roles in New York.
View Salary Guide →Find your match !
Job Title :
Sr Consultant
Job Type :
Full-Time
Job Location :
Rochester New York United States
Remote :
Yes
Job Description :
Location: Rochester, NY
Duration: 6 Months
Job Type: Temporary Assignment
Work Type: Remote
- 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.
- 7-10 Years
- Facets
- Healthcare Claims Domain
- Informatica PowerCenter
- SQL
- PL/SQL
- Healthcare Payer Systems
- Data Analysis & Troubleshooting
- Enterprise Data Warehouse (EDW)
- Oracle Database
- Healthcare Membership & Enrollment
- Production Support
- Data Modeling
- Healthcare Reporting & Analytics
- 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.
- 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.
- Informatica PowerCenter Developer Certification
- Facets-related functional or technical certification
- Healthcare domain certifications
- This version aligns much better with the actual request: "strong Facets knowledge in claims subject area, existing architecture, Informatica, SQL, and PL/SQL", and will help vendors source the right candidates quickly.
- 12.00 Years of Experience
Position Details
Posted:
Nov 16, 2026
Reference Number:
52682-12690
Employment:
Full-time
Salary:
$53 per hour
City:
Rochester
Job Origin:
CIEPAL_ORGANIC_FEED
Share this job:
Please wait..!!

