*Mail me: [email protected]* * *
*Data Modeler :: Raleigh, NC :: 6 Month contract * Candidates must have knowledge of fixed income, equity, listed derivatives, loans & deposits, money markets, FX, and OTC products, and Relational data modeling best practices. Dimensional modeling and Erwin. *Rate: $50/HR* *Data Modeling Description: * Main responsibilities include ownership of the data modeling function for DART, a large scale, global data warehouse that consists of an Oracle 10g RAC implementation, Unix-based batch and intraday job streams that source data from various systems, a custom .NET C# & C++ middleware that enables ad hoc user queries, and several Excel-based and web-based front-end applications. *Functional Responsibilities: * - Define, document, and articulate design goals and standards. - Maintain the data model, both logical and physical, inclusive of version control. - Analyze and consolidate business requirements across a multitude of data sourcing projects to design a common dimensional data model with conformed dimensions and facts. - Collaborate with the middleware team to prototype and define data access meta-models that drive the ad-hoc SQL generation. - Support developers in ETL design and documentation of data flows and interfaces. - Design partitioning and indexing strategies for high performance. - Perform volumetrics analysis for capacity planning. - Employ best practices in data profiling and designing solutions for handling data quality issues. *SKILLS: * - Knowledge of fixed income, equity, listed derivatives, loans & deposits, money markets, FX, and OTC products - Relational data modeling best practices - Dimensional modeling (Ralph Kimball) - ERWin *Desired Skills: * - Knowledge of P&L reporting and financial accounting - Partitioning and indexing strategies in Oracle 10g or later version - Query plan analysis *Andy* Resource Manager *West Coast Consulting* <http://www.westcoastllc.com/> 9233 Research Drive, Irvine, CA 92618, USA *Work:* 949-743-0065 Ext. 208 *Fax:* 714 844 9091 *Email:* [email protected] *IM:* andy_westcoastll (Yahoo) *Professional Profile* <http://www.linkedin.com/pub/4/2bb/917> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle-USA" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-USA -~----------~----~----~----~------~----~------~--~---
