Must Have

• 5+ years of SQL developer preferably with experience in Hyperscale or eager to learn Hyperscale.

• Good to have knowledge of HIPAA, EDI, and EPIC.

• Healthcare Payer industry experience

• Worked with Enterprise customers in a customer facing role

Responsibilities

• Work with large volume of data (in TB)

• Ability to work independently in the Agile model

• Delete the duplicate records

• Union and union all

• Dynamic SQL

• Table variable and temp table

• Write the complex stored procedures –

• At least wrote in more than 200

• JSON

• Deadlock

• Index

• Query optimization -Know the medium to advance level

• Candidate worked in Sql server 2016 or after version it's added advantage

• handling the JSON data

Qualifications

• Bachelors in engineering

Good to have:

• Azure Cloud (SaaS, PaaS)

• Experience with the database (e.g. cosmos DB).

• SQL Servers, CosmosDB, typical 3-tier MVC framework apps

• Databricks & Data Factory

• EDI

• Azure Logic Apps