Oracle PL/SQL

Role
PLSQL Database Lead with Postgres Experience

Location
NYC, NY (Hybrid Model)

Type of Hire - Contract/ C2H
6 Months Contract to Hire (Client Hire)

Rate (Max)
$75/Hr is the MAX

Duration
6+ Months

Number of Interviews
L1+HR+Client

In person interviews Yes/No
No

Client Interview Yes/No
Yes

No of submission (example not more than 3 resumes)
3 Submissions

Timeline for submission
2 hours

Position requirements (Remote/ Hybrid/Fully onsite)
Remote

Job Description

12 to 15 years of experience is required not more than 15 Years.

Experience in data profiling, Strong experience in SQL analytic functions.

Hands on experience in Writing SQL Procedures, Functions and View.

Strong Knowledge in PostGres SQL Conncepts, experience in Postgres JSON management.

Hands on Experience in Data Modeling and strong knowledge in Database Design principles

Knowledge on ETL concepts and Source to Target Mappings (STTM's)

Data Quality Rules and Validations - Compare the Business Rules to what is actually in the system, evaluate the over quality of data and gaps

ETL should automate this but you can start after profiling

Knowledge in Data Security and Data Management

Experience in legacy system migration and/or a data integration project

Healthcare experience (Payer or Provider)

A plus to have a knowledge around Provider / Claims space.

Knowledge on CI/CD process