Sign In
 [New User? Sign Up]
Mobile Version

Data Modeller

Bengaluru, KA
Job Code:
  • IT
Applying for this job will take you to an external site
  • Shortlist
  • Email Friend
  • Print

Job Details

Define and govern Teradata FSLDM logical model and Physical Data model, good knowledge with data warehouse best practices and standards to include software development practices, design styles and software deployment. Expert in selective denormalization of integrated layer based on Analytical needs. Knowledge of building data model for Analytics. Knowledge of building star schema for reporting. Facilitate the discovery of entities, attributes, relationships, and business rules from the functional experts and the user community. Develop and manage data models in Erwin and associated metadata for the enterprise. Responsible for developing and enhancing the Common Data Model and Analytical Data model (ADM) to meet UR / Project level business reporting requirements. Liaise & provide inputs to Data Management on enterprise level metadata management. Define and enforce best practices for standard naming conventions and coding practices to ensure consistency of data models. Responsible for defining the analytical presentation layers to ensure optimal data storage and to eliminate data redundancy. Responsible for review of physical data models. Analyse reference codes from various sources and maintain the master and reference tables. Architect and implementing data warehouse solutions using Teradata.Requirements Knowledge of products in Banking and Financial Services. Ability to write clear documentation of procedures, and ability to write specifications for data models to be developed. Detail-oriented and able to follow clear methodologies for troubleshooting and development. Expert knowledge of Teradata Architecture and FSLDM. Expert knowledge of data warehouse and relational data modelling design (Physical and Logical) Expert knowledge of Erwin data modeler tool. Certifications would be a plus. Expert in Data Analysis and Data Profiling. Efficient in prioritising work and multi tasking. Good to have experience in Oracle, SQL Server, DB2 UDB and DB2 Mainframe. Good to have experience in SAS Business Intelligence, SAP BO Business Intelligence and Qlikview.Mandatory Skills Expertise of Banking Data model (FSLDM or IBM BDW or other similar industry standard model) Erwin Basic knowledge of Hadoop Good knowledge of RDBMS (Teradata, DB2, Oracle, etc (any one) Knowledge of banking domain.
Degree: MCA/ PGDCA

Additional Degree: BE/ B.Tech (Engineering)

Experience: 2-5


Business/Systems Analysis | Database Administration (DBA) | Graphic Designing/Animation/Web Designing | System Analyst/Tech Architect
Applying for this job will take you to an external site


© Copyright 2015 Al Nisr Publishing LLC - powered by Gulf News