Detailed description of req..
DO NOT reply with any candidate with less than 10 years of experience-All candidates must be willing to attend an In-person interview in NYC with the Client. Location: Manhattan, NYC, NY Duration: 6++ months Risk Finance Data Warehouse Senior Oracle Data Warehouse Developer Client needs an individual with strong technical knowledge of Oracle RAC 10g/11g with solid SQL tuning experience and 10+ years of experience, for the Risk and Finance Architecture group to work on building the strategic Risk Finance Data warehouse. The team is developing a consolidated data warehouse that serves as a single store for all risk and finance data. Data is sourced from multiple systems, 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: · Create Physical data models using industry standard tools, e.g. ER/Studio · Code packages, functions, stored procedures, views in Oracle PL/SQL · String SQL Performance tuning background preferably in the data warehouse space · Physical architecture of database tables, partitions, load-balancing, parallel queries, etc. · Code Review stored procedures and scripts written by other team members · Performance/Tuning of Oracle SQL Technical skills: · Solid understanding of Oracle 10g RAC / 11g from a Development perspective · Solid understanding of Data Warehouse and Data Mart concepts with proven experience in both. · Expertise in SQL and PL SQL · Strong Data modeling background with emphasis on Physical modeling · Star schema · physical architecture (partitioning, cluster) · working with large databases - multi terabytes (3+ Terabytes) · Knowledge of financial products · Unix skills · Data Modeling tools: ER/Studio, ERWin, Enterprise Architect · Any BI (Business Intelligence) / OLAP exp is a plus · Java is a plus · MQ / Tibco EMS messaging experience is a plus In addition, the individual should meet the following requirements: * strong inter-personal skills and ability to communicate effectively with the team * ability to work in a global team environment * hard working and results oriented .
