TrentonRecruiter Since 2001
the smart solution for Trenton jobs

Sr Oracle Developer

Company: Sunrise Systems Inc
Location: Trenton
Posted on: November 26, 2022

Job Description:

Job Title - -Sr Oracle Developer

Location - Trenton, NJ or Hybrid Schedule

Duration - 12 months contract

Type - W2 or C2C



Summary

The Sr Oracle Developer will be responsible for Designing the Physical Data Model, Reconciliation processes, Design Threshold processed, Replica Tables, developing queries and building tables for the Departmental Data Lake project.

The Sr. Oracle Developer will be responsible for Designing the Physical Data Model, Reconciliation processes, Design Threshold processed, Replica Tables, developing queries and building tables for the Information Architecture Strategy/ Departmental Data Lake project. This project is looking at the multiple data sources in the Department of Labor and bringing them in to a single repository.



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



Knowledge & Experience:

---Oracle - 10 years

---Database design - 10 years

---SDLC - 10 years

---Salesforce - 2 years



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



Desired Skills:

---Excellent verbal and written skills, with the ability to communicate with both technical and program area staff - 5 years

---Salesforce



Required Education:

Bachelor's Degree or equivalent certification



Contact

Sanjana Shanbhog

Email: - - Direct: 732-401-9833

-Or

Jayabalaji - -Delivery Manager - Staffing Services

Mobile: 908-440-1557 - Email: - jayabalaji.s@sunrisesys.com

-

Keywords: Sunrise Systems Inc, Trenton , Sr Oracle Developer, IT / Software / Systems , Trenton, New Jersey

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Log In or Create An Account

Get the latest New Jersey jobs by following @recnetNJ on Twitter!

Trenton RSS job feeds