- 7-10 years’ experience in Oracle Exadata, SQL, PL/SQL
- Implement ETL solutions for large volume of data by applying various data warehouse modeling techniques like Star Schema, Data partitioning, Data compression, Direct path loads etc. and that maximizes re-usable components and services that incorporate versioning, reconciliation and exception handling
- 2-3 years’ experience in SQL Performance tuning. Perform application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, AUTOTRACE and AWR Reports.
- Should have a clear understanding of Oracle Server Process Architecture and memory structures PGA (Program Global Areas) SGA (System Global Areas) to optimize memory usage.
- Knowledge about Oracle VPD
- Knowledge of Python is a desirable and a plus
- Strong coding, debugging, and analytical skills
- Knowledge about Oracle architecture and process
- Knowledge of computer science data structures and algorithms
- Experience with Analytic reporting tools like Tableau
- Analytical skills to perform technical and functional analysis with strong communication skills
- Experience working in regulatory projects is strongly desirable
- Experience working in Containers
Job Type: Full-time
Pay: $87,155.63 - $104,961.62 per year
Benefits:
- 401(k)
- Dental insurance
- Health insurance
Schedule:
- Day shift
- Monday to Friday
Security clearance:
Ability to Commute:
- Jersey City, NJ 07302 (Required)
Work Location: In person