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

: Looking for an experienced FACETS Technical Developer with solid 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
Robust expertise in Oracle PL/SQL and Advanced SQL.
Hands-on experience with Stored Procedures, Functions, Packages, Triggers and Performance Tuning.
Strong 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.

Positive 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.

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

📌 Facets Ms Sql Developer Pune (India)
🏢 Innovative Information Technologies
📍 India