SR CONSULTANT

TechDigital Group

City of Rochester (NY)

Remote

USD 110,000 - 150,000

Full time

8 days ago

Get a reply from this recruiter

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

TechDigital Group is seeking a Senior Consultant with deep expertise in Facets Claims processing, Informatica, and SQL/PLSQL to support and enhance data integration for healthcare payer systems. The role involves troubleshooting, impact analysis, and collaboration with business and technical teams in a remote-capable setup.

The ideal candidate will design and optimize ETL workflows, analyze claims data, and mentor junior staff while ensuring SDLC compliance and robust data governance.

Qualifications

  • Strong knowledge of Facets claims processing and architecture.
  • Experience with healthcare payer systems and data integration.

Responsibilities

  • Provide SME 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 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.

Skills

Facets
Healthcare Claims
Informatica PowerCenter
SQL
PL/SQL
Healthcare Payer Systems
Data Analysis
Troubleshooting

Education

Bachelor's degree

Tools

Oracle Database

Job description

Job Description –

Job Title

Senior Consultant - Facets Claims & Informatica


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.


Experience - 7-10 Years

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


Work Model - Remote

Client Location - Rochester, NY

Shift - Day Shift

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


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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Consultant - Facets Claims & Informatica
Senior Consultant - Facets Claims & Informatica

TechDigital Group • City of Rochester (NY)

On-site
USD 120,000 - 170,000
Senior Facets & Informatica Claims Consultant
Senior Facets & Informatica Claims Consultant

TechDigital Group • City of Rochester (NY)

On-site
USD 120,000 - 170,000
Sr Consultant
Sr Consultant

TechDigital Group • Durham (NC)

Hybrid
USD 90,000 - 120,000
Senior Facets Claims Architect - Remote ETL Expert
Senior Facets Claims Architect - Remote ETL Expert

TechDigital Group • City of Rochester (NY)

Remote
USD 110,000 - 150,000
Remote Senior Facets Product Consulting Lead
Remote Senior Facets Product Consulting Lead

Compunnel Inc. • Bridgewater Township (NJ)

Hybrid
USD 90,000 - 130,000
Facets Developer
Facets Developer

SysMind, LLC • Durham (NC)

On-site
USD 110,000 - 140,000
Healthcare Configuration Consultant / Analyst (Facets & SQL)
Healthcare Configuration Consultant / Analyst (Facets & SQL)

Azaaki LLC • Mason (OH)

Hybrid
USD 80,000 - 100,000
Facets – Technical Consultant with Healthcare Exp
Facets – Technical Consultant with Healthcare Exp

Tektree Systems Inc. • United States

On-site
USD 110,000 - 170,000
Facets Product Configuration Analyst
Facets Product Configuration Analyst

Consulting Solutions • United States

On-site
USD 120,000 - 160,000
Facets Configuration Analyst
Facets Configuration Analyst

Tegria Services Group - US • United States

Remote
USD 90,000 - 140,000
Health insurance
Dental insurance
Vision insurance
+3