Oracle Data Modeler recruitment
Key activities for a Data Modeler may include the following:
• Design and development of various types of data models (business / contextual; system; logical; physical; etc.)
• Communication of physical database designs to the database administrator
• Participation in design reviews
• Ensuring designs follow all relevant standards
• Creation of design documentation
Key deliverables for a Data Modeler may include the following:
• Data model
• Scripts
• Technical Documentation
Requirements:
- Experience in managing logical and physical data models for enterprise applications, converting logical to physical models, analyzing conceptual models
- Experience in designing Relational OLAP (Star Snowflake Schema Design) for enterprise data warehouse
- Experience in at least 1 data modeling tool to manage physical design, forward and reverse engineer data models (preferred: Toad Data Modeler, Visual DB Architect, Sybase Power Designer)
- Experience in Physical database design, forward/reverse engineering, use best practices in code and environment promotion strategies
- Experience in developing, managing Oracle database solutions (Stored Procedures, view development, Materialized view)
- Experience in designing OLAP/MOLAP solutions, or developing enterprise data marts with Cubes
- Experience in dimensional and relation data modeling
- Business focus (knowledge of finance industry, particularly Fixed Income)
- Excellent information gathering skills
- Ability to translate business needs into technical solutions
- Excellent conceptual, communications, and technical skills
- Knowledge of various types of models (business/contextual; system; logical; physical; etc)
- Evolves models to meet new and changing business requirements
- Able to understand ETL process flow designs
- Experience maintaining models in a 'run the shop / change the shop' environment
- Understanding of modeling techniques for OLTP, Hub-and-Spoke DW, Bus-DW
- Can demonstrate normalization and denormalization (at least to 3NF)
- Proficiency in a data modelling tool. Preferably Embarcadero E/R Studio Data Architect
- Understanding of OLAP/MOLAP/ROLAP
- Experience capturing and maintaining metadata from all data warehousing components
- Communicates physical database designs to database administrator
- Knowledge of Materialized Views, Triggers, Functions, PL/SQL and other Oracle Objects
March 2, 2011
• Tags: Accounting & Finance careers in the USA, Oracle Data Modeler recruitment • Posted in: Financial