Job Description A major Foreign Bank Holding Company is looking for a Data Quality Oracle Developer in their New York City office.
Department Overview
They are looking for an individual with strong technical knowledge of Oracle RAC 11g databases in general, for the Risk and Finance Architecture group. The selected individual will initial work with the Data Quality team before moving On to the Information Team and assist in building the strategic Risk Finance Data warehouse. The Data Quality team Is developing a consolidated data quality datmart to serve as a single store for exceptions reported by all Front to back Functions. Data is sourced from multiple, enriched and distributed to multiple consumers, and provides a consistent View of the data. The ideal candidate would have hands-on-experience in high volume data warehouses and have a History of Oracle RAC database / data warehouse development experience in their past.
Responsibilities:
Develop database entities (tables, views, stored procedures) needed by the Data Quality / Information Management teams.
Code packages, functions, stored procedures, views in Oracle PL/SQL
Create Physical Data Models using Enterprise Architecture and ER Studio.
Ability to create functional and technical design documents.
Partner with UK , US and offshore build team
Code Review stored procedures and scripts written by other team members
Performance /Tuning of Oracle SQL
Skills Required Technical Skills:
Solid understanding of Oracle, 10g RAC / 11g from a Development perspective
Any prior DBA experience is a plus
Solid understanding of Data Warehouse and Data Mart concepts with proper experience
Expertise in SQL and PL SQL
Data Modeling
Star Scheme
Working with large databases – multi terabytes (3+ Terabytes)
Knowledge of Financial Products
Unix Skills
Data Modeling tools: ER/Studio, Erwin, Enterprise Architect
Any Netezza or other database appliance experience is a plus
Any BI (Business Intelligence) / QLAP experience is a plus
Java / .Net/C# is a plus
Market Risk, Credit Risk or Finance domain knowledge is a huge plus
In addition, the individual should meet the following requirements:
Strong inter-personal skills and ability to communicate effectively at all levels
Ability to work in a global team environment
Hard working and results oriented.
Salary Range This is a full time position for an Assistant Vice President and the salary is based on experience.
How to Apply Contact Tony Savoca at Momentum Resource Solutions at asavoca@momentumrs.
Tony Savoca Vice President Director of Financial Services Momentum Resource Solutions 1090 King Georges Post Road Edison, NJ 08837 732-738-4700 |
No comments:
Post a Comment