Job Description – Facets MS SQL Developer
Band: C1
Experience: 10+ Years
Location: Chennai / Bangalore / Pune / Hyderabad / Greater Noida / Coimbatore

Job Description:

Looking for an experienced FACETS Technical Developer with strong expertise in Oracle PL/SQL, Advanced SQL and TriZetto FACETS. Candidates should have good knowledge of US Healthcare Payer processes, Claims, Membership, Enrollment, batch jobs, data extracts and production support.

Mandatory Skills:
Strong expertise in Oracle PL/SQL and Advanced SQL.
Hands-on experience with Stored Procedures, Functions, Packages, Triggers and Performance Tuning.
Solid experience in TriZetto FACETS application and data model.
Knowledge of FACETS Claims, Membership and Enrollment modules.
Experience with FACETS batch jobs, extracts and reports.




Strong understanding of US Healthcare Payer domain.
Knowledge of Claims Adjudication, Eligibility and Enrollment (834).
Experience in data validation, reconciliation and root cause analysis.
Production support, defect analysis and issue resolution.
Experience with SQL Developer / TOAD, Git / SVN and JIRA / ServiceNow.

Valuable to Have:
HIPAA EDI transactions: 837, 835, 834, 270/271 and 820.
EDI integration tools such as Rhapsody or Mirth.
Reporting tools and Data Warehousing exposure.

Robust FACETS application experience along with Oracle PL/SQL and US Healthcare domain knowledge is mandatory.

📌 Facets Ms Sql Developer Pune
🏢 Innovative Information Technologies
📍 Pune