Please respond to gau...@itecsus.com *Position : *Data Modeler
*Location: *Wilmington, DE** *Duration :* Long Term Contract * * *Description** **:*** * * *After Telephonic Interview round Face to Face Interview round is Must . Client is not paying any kind of expenses for Face to Face Travelling .* * * *Responsibilities:* · The Data Modeler II is primarily responsible for defining business data requirements & translating those data requirements into logical & physical database models. · The design of the databases models will include operational databases, on-line transactional data stores, analytical data warehouses & specific data marts for both online analytical processing (OLAP) & on-line transactional processing (OLTP) used by individual departments to support specific software applications. · Additional responsibilities will include supporting Enterprise Data efforts to improve data accuracy, data quality, data security, data integrity, & data standards across the organization. · The Data Modeler II is expected to provide training & mentoring to other members of the Data Modeling team. *Essential Functions:* * * · Work with identified business users to define data requirements. · Define corporate metadata definitions for all Enterprise Data supported databases (operational source systems, data stores & data marts). · Develop logical & physical data models that document source data from multiple sources (Client’s internal data systems, external source data systems, 3rd Party Data, Prospect Lists, etc.). · Develop mapping spreadsheets that will provide the Data Warehouse Development (ETL) team with source to target data mapping. · Take a leadership role when working with the Data Warehouse Development (ETL) team to research & define existing source to target mapping for the corporate Data Warehouse. · Define & develop designs to support departmental & functional data marts. Provide input to data modeling & physical database development standards with the Data Modeling Team. Assist in the review of database structures of proposed business application purchases. · Work closely with analytical & reporting infrastructure teams to ensure operational & analytical data warehouses are able to support all business requirements for OLAP reporting across the organization. · Research & respond to Data Modeling Team assigned IT Service Requests within the required time-frame. · Assist in the design & administration of the corporate Metadata Repository. · Maintain Enterprise logical & physical data models, reflective of current environments * * *Experience & Qualifications:* * * · Experience working in a multiple team environment · Experience working with a Data Modeling Case Tool (Erwin, ERStudio, System Designer) · Knowledge of relational & multi-dimensional database architectures. · Knowledge of database full life cycle design & application development. · Must be a team-player & be able to work closely with technical teams & business users of the Data Warehouse. · Ability to quickly locate & analyze data. · Excellent communication ability. · Ability to work effectively on multiple priorities with strict deliverable dates. · Experience working with relational or multi-dimensional data in reporting or analytic infrastructures. · Proven experience working in a fast-paced, dynamic environment. * * *Education &/or Certifications:* * * · Bachelor’s Degree in related discipline (Business, Computer Science, & Communications) preferred. * * *Technical skills & abilities:* · 5 – 7 years experience with Erwin. · Understanding of Business Intelligence architectures. · General knowledge of the retail banking industry. · 10 - 15 years experience working with relational or multi-dimensional databases. · Basic knowledge of SQL & understanding of Oracle databases. Thanks & Regards, *Gaurav Seth* ITECS *IT & EBusiness Consulting Services Inc.* Ph: 516.499 6042 | Fax: 347 602 9084/866 515 6599 *gau...@itecsus.com* | www.itecsus.com -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To post to this group, send email to sap-basis@googlegroups.com. To unsubscribe from this group, send email to sap-basis+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sap-basis?hl=en.