Thursday, August 6, 2009

Data Modeling - Star / Snowflake Schema

Location:
Bengaluru/ Bangalore
Key Skills:
DBA Databases Data warehousing
Specialization:
Database Administration (DBA)
Job Function:
IT/Telecom - Software
Industry:
IT-Software
Qualification:
Post Graduation -
Others -Graduate/Bachelors (Others -Other)
Level:
Middle - Manager, Assistant Manager
Experience:
8 - 12 yrs.

Job Details:

Designs, implements, and maintains databases.
Maintains database dictionaries and ensures system integration.
Person at AM or above would be considered.
Should be conversant with ETL technologies with experience in Datastage, DB2, Oracle.
Key responsibilities include:
Review current data models to understand the as-is environment
Review report design documents to understand where data model structures can address requirements
Work with the key business representatives, data owners, end users, application designers and data architect to model the current data (where models do not already exist) and for the to be system
Create logical and physical data models for as-is and proposed to-be system
Create entity-relationship diagrams for relational systems and dimensional diagrams for the Data Warehouse, Data Marts and data cubes
Review, update and validate data model with key business representatives and end users
Work with the technical architect, data architect and database administrator to understand current data storage constraints and define to be needs with growth allocation
Work with data architect to define and create required metadata
Maintain data models continuously as modifications and enhancements are made
Create data model structures to enhance performance of the application by creating aggregation and summarization structures

Company Details:

Our Client is a global management consulting, technology services and outsourcing company. Committed to delivering innovation, the company collaborates with its clients to help them get and maintain an edge in the marker. With deep industry and business process expertise, broad global resources and a proven track record, our client mobilizes the right people, skills and technologies to enable their clients to improve their performance. With more than 152,000 people in 49 countries, the company generated net revenues of US$23.39 billion for the fiscal year ended Aug. 31, 2008.India is one of the fastest growing geographies of this company and it has multiple offices in 6 Locations.

Contact Details:

Address : 3rd Flr.,UCF Centre, Above Grafs Lifestyle,84/3, Hennur Main Rd., Lingarajpuram,
Bangalore-560 084

0 comments:

Post a Comment