Previous Job
Previous
PL/SQL Developer
Ref No.: 24-00502
Location: Iselin, New Jersey
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