Job ID :
38720
Company :
Internal Postings
Location :
Trenton, NJ
Type :
Contract
Duration :
11 Months
Salary :
DOE
Status :
Active
Openings :
1
Posted :
04 Nov 2022
Job Seekers, Please send resumes to resumes@hireitpeople.com

Duties/Responsibilities:

  • Design Physical Data Model
  • Design Induces to ensure optimal performance
  • Design Reconciliation Procedures
  • Design Threshold Validation Procedures
  • Build Replica Tables
  • Create SQLLDR Jobs
  • Create merge procedures
  • Create Aggregation Jobs
  • Create Reconciliation Procedures
  • Integration testing
  • Training
  • Document ETLs
  • Documentation for Procedures
  • User Acceptance Testing

Required Skills:

  • Oracle 10 years
  • Data Modelling 10 years
  • SQL 6 years
  • Oracle View creation 5 years
  • Create and testing Join conditions 5 years
  • ETLs 6 years

Experience required: 10-15 Years