Senior Oracle Data Warehouse Developer
Jersey city Duration-6months We are looking for 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 Warm Regards, Priya Altech Star, Inc Princeton, NJ 08540 609-520-9000 X 18 Fax: 609-520-9005 <mailto:[email protected]> [email protected]
