Data Modeller - Teradata

Soft tech Career Info system Pvt. Ltd
  • Bangalore
  • 10-30 lakh
  • 10-15 years
  • Views
  • 28 Jun 2017

  • IT/ Information Technology

  • IT/ Technology - Software/ Services
Job Description

3NF (Relational) Logical and Physical Modeling

- 5+years hands on experience with Logical Data Modeling (3NF)

- Comprehensive Knowledge of Bill Inmon's Data Modeling Concepts (Logical and Physical) including 3NF, Supertypes, Subtypes, Abstraction, Associative entities / tables

- Physical Modeling and Performance Tuning including Primary, Secondary index, JIs, AJIs, PPIs (SLPPI, MLPPI)

- Experience with ERWin

- Experience with Teradata Industry LDMs a big plus

Dimensional Modeling

- 8+ years hands on experience designing and implementing Star Schemas

- Comprehensive Knowledge of Ralph Kimball's Data Modeling Concepts including Transaction dimensions, conformed dimensions and facts, slowly changing dimension, multi-Star/ Snowflake Schema Modeling, different types of Fact tables

- Prior experience implementing DW presentation layer - including design and definition of logical tables, physical sources, dimensions, columns and aggregation rules a plus

- Candidate should be TD 14 certified

- Knowledge of Bus Architecture

- Experience with Software Development Life Cycle, including requirement gathering, documentation testing and knowledge transfer is required.

- Collaborates with business and technology resources to identify key business requirements for Business Intelligence (BI)

- Experience with Data Integration, Data Mapping, ETL

- Demonstrated ability to respond to changing priorities, multiple tasks and demands within short timeframes.

- Good written and oral communication

- Able to handle project independently and manage client expectations and deliverables in a timely manner

- Experience in working in offshore / onshore Model

- Experience in working in retail functional areas . i.e Loyalty, Campaigns, etc

Job Posted By

O.P. Chawla