← Back to jobsJob ID col-cmwjhl5450i6v89hq1ydr6shc

Ztek ConsultingPosted 4 days ago

Senior Consultant - Facets Claims & Informatica

Full-time
Remote
7–10 years
Competitive
Posted 4 days ago

Ztek Consulting is seeking a Senior Consultant to support and enhance healthcare claims and data integration processes. The role focuses on Facets claims processing, Informatica ETL, SQL and PL/SQL development, troubleshooting, and collaboration with business and technical teams.

Posted
4 days ago
Source
linkedin.com
Sector
Electrical Engineering

Opens the employer's application page in a new tab

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

Qualifications

  • strong expertise in Facets, Healthcare Claims, Informatica, SQL, and PL/SQL
  • deep knowledge of healthcare payer systems, claims processing, and existing Facets architecture
  • 7-10 Years
  • Data Analysis & Troubleshooting

Preferred

  • Enterprise Data Warehouse (EDW)
  • Healthcare Membership & Enrollment
  • Healthcare Reporting & Analytics
  • 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
  • Bachelor's Degree in Computer Science
  • Large Healthcare Data Environments

Required skills

Data ModelingEnterprise Data WarehousingFacetsHealthcare ClaimsHealthcare Membership and EnrollmentHealthcare Payer SystemsHealthcare Reporting and AnalyticsInformatica PowerCenterOracle DatabasePL/SQLSQL

Nice to have

Enterprise Data Warehouse (EDW)Healthcare Membership & EnrollmentHealthcare Reporting & AnalyticsHealthcare domain certificationsProduction Support

Full job description

Ztek Consulting is seeking a Senior Consultant to support and enhance healthcare claims and data integration processes. The role focuses on Facets claims processing, Informatica ETL, SQL and PL/SQL development, troubleshooting, and collaboration with business and technical teams.

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

  • Enterprise Data Warehouse (EDW)
  • Oracle Database
  • Healthcare Membership & Enrollment
  • Production Support
  • Data Modeling
  • Healthcare Reporting & Analytics
  • 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
  • Enterprise Data Warehousing
  • Healthcare Membership
  • Enrollment
  • Healthcare Reporting
  • Bachelor's Degree in Computer Science
  • Healthcare Payer Operations
  • Claims Lifecycle
  • Facets Data Structures
  • Facets Claims Modules
  • Informatica PowerCenter Development
  • Informatica PowerCenter Support
  • Advanced SQL
  • PL/SQL Programming
  • Large Healthcare Data Environments
  • Facets Functional
  • Technical Certification
  • Healthcare Domain Certifications
  • Analytical Skills
  • Communication

Company

  • Talent management, technology consulting, and cybersecurity advisory services
  • Atlanta, Georgia, USA
  • http://ztek-inc.com/
  • Founded in 2001
  • 201-500 employees

Qualifications

  • strong expertise in Facets, Healthcare Claims, Informatica, SQL, and PL/SQL
  • deep knowledge of healthcare payer systems, claims processing, and existing Facets architecture
  • 7-10 Years
  • Facets
  • Healthcare Claims Domain
  • Informatica PowerCenter
  • SQL
  • PL/SQL
  • Healthcare Payer Systems
  • Data Analysis & Troubleshooting
  • Strong expertise in Facets, Healthcare Claims, Informatica, SQL, and PL/SQL
  • Deep knowledge of healthcare payer systems, claims processing, and existing Facets architecture
  • Enterprise Data Warehouse (EDW)
  • Oracle Database
  • Healthcare Membership & Enrollment
  • Production Support
  • Data Modeling
  • Healthcare Reporting & Analytics
  • 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

Required skills

  • Data Modeling, Enterprise Data Warehousing, Facets, Healthcare Claims, Healthcare Membership and Enrollment, Healthcare Payer Systems, Healthcare Reporting and Analytics, Informatica PowerCenter, Informatica PowerCenter Developer Certification, Oracle Database, PL/SQL, SQL

Preferred skills

  • Advanced SQL and PL/SQL programming skills, Data Modeling, Enterprise Data Warehouse (EDW), Experience working with large healthcare data environments, Facets-related functional or technical certification, Healthcare Membership & Enrollment, Healthcare Reporting & Analytics, Healthcare domain certifications, Oracle Database, Production Support, Strong analytical, troubleshooting, and communication skills

Experience

  • 7-10 years

Job details

Employment type

Full-time

Seniority level

7–10 years

Date posted

Nov 16, 2026

Work mode

Remote

Job source

linkedin.com

Company

Ztek Consulting

Electrical Engineering

Talent management, technology consulting, and cybersecurity advisory services

See all 2 jobs from Ztek Consulting →
  • Atlanta, Georgia, USA
  • Electrical Engineering
  • 201-500 employees
  • Founded 2001
  • ztek-inc.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Systems Integration Engineer jobs

Dice

4d ago

Only W2- Facets Claims & Informatica Consultant

TemporaryRemoteUnited StatesCompetitive

Dice is recruiting for a Senior Consultant role focused on Facets claims processing and healthcare payer systems.

Why similarSame roleData ModelingEnterprise Data Warehousing

Toptal

4d ago

Senior SAP Business One & Power BI Consultant

TemporaryRemoteUnited StatesCompetitive

Responsibilities Conduct a comprehensive health check of the existing SAP Business One environment Review SAP B1 configurations, approval procedures, alerts, and relevant system workflows Map and harmonize master data across four different systems Define…

Why similarSame role

Just Appraised

Today

New

Product Engineer

Full-timeRemoteUnited StatesCompetitive

Alltus is hiring a Product Engineer to build and shape workflows, automation, and AI-powered experiences for local government.

Why similarSame role

Get new Systems Integration Engineer jobs by email

Create job alert

Senior Consultant - Facets Claims & Informatica

Ztek Consulting · Competitive

Apply on company site