Sr Product Specialist - Tech

Facets Job Description :

Good understanding and hands on experience in Facets data model and Facets batch architecture.

Must be proficient in Facets Claims module along with either Member or Provider modules.

Able to write SQL queries, stored procedures to extract data from database.

Able to Analyse and design based on the business requirements.

Have understanding of US healthcare.

SSIS Job Description :

Create/maintain design related artifacts data models, Mapping documents, architecture diagrams, data flow diagrams.

Proficient with ETL tools such as Microsoft SSIS. Experience working with SSIS packages.

Designing and developing SSIS / SQL ETL solutions to acquire and prepare data from numerous upstream systems for processing.

Builds data transformations with SSIS including importing data from files, moving data from one database platform to another.

Experience in various logging and connection manager.

Debug and tune SSIS processes to ensure accurate and efficient movement of data.

Test and prepare ETL processes for deployment to production and non-production environments.

Technical Skills

SNo Primary Skill Proficiency Level * Rqrd./Dsrd.

1 Facets - Claims PL3 Required

2 Facets - Provider PL3 Required

3 Facets - Membership PL3 Required

4 ANSI SQL PL2 Required

5 Core Java PL3 Required

6 PL/SQL PL3 Required

Domain Skills

SNo Primary Skill Proficiency Level * Rqrd./Dsrd.

1 Medicare & Medicaid Claims NA Required

* Proficiency Legends

Proficiency Level Generic Reference

PL1 The associate has basic awareness and comprehension of the skill and is in the process of acquiring this skill through various channels.

PL2 The associate possesses working knowledge of the skill, and can actively and independently apply this skill in engagements and projects.

PL3 The associate has comprehensive, in-depth and specialized knowledge of the skill. She / he has extensively demonstrated successful application of the skill in engagements or projects.

PL4 The associate can function as a subject matter expert for this skill. The associate is capable of analyzing, evaluating and synthesizing solutions using the skill.

Schedule: Full-time

Shift: Day Job

Travel: No