[Close] 

Oracle Developer

Company Name:
Open Systems Technologies
As part of a new initiative we are creating a central Datawarehouse integrating data from over hundreds of operational systems from across the globe, enrich them with golden master data and produce actionable metrics.
The solution is delivered via a data portal/Analytics platform built using cutting edge technologies to help reduce overall risk exposure to the Firm, increase balance sheet capacity and ultimately increase net income. It also opens up opportunities to improve productivity and increase overall operational efficiency.
Position:
We are looking for someone who has very strong database development experience with Oracle 10g/12C. The person must have very good experience with logical and physical data modeling, deep understanding of oracle database internals, preferably to the extent where he/she would be able to rationally discuss/debate with DBA and DB engineering teams in resolving performance/environment configuration issues. The role is NOT a DBA, but the expectation is that the person has comparable knowledge in oracle internals.
Functional Skills:
o 6+ Years of financial industry background is mandatory
o Person should have worked with operations, financial positions, transactions, benchmarking, corporate actions data
o Person should have worked on projects touching one or more areas of trading, accounting, back office operations and MIS
o Strong knowledge of Fixed Income and Equity Products
o Strong analytical and communication skills
o Good background working with quantitative data
Oracle and Database Skills (Minimum 6+ Years):
o Oracle Stored Procedures, PL/SQL and functions, Materialized views
o Experience in Data warehouse development, Star and snow-flake schemas
o Good understanding of OLAP concepts
o Strong UNIX and Shell scripting
o Experience using Erwin or ER Studio data modeling tools
o Good understanding of ETL process, dimensions and hierarchy data
o 5+ yrs of strong experience with Oracle 9i and/or 10g
o Ability to query the database using SQL
o Advanced level knowledge of using Excel for data analysis
Pluses
o Some exposure to ETL tool like Talend or Informatica
o Experience with No SQL and New SQL databases like VoltDB, Vectorwise etc.

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.

More Jobs

Informatica Powercenter Oracle
Jersey City, NJ AIC (part of ACS Group)
Associate Clinical Development Medical Directo...
East Hanover, NJ Ascent