Teradata Lead

Numaware Technologies Private Limited

Quick Apply

Posted 19 days ago
Over 400 applicants

5-8 Years

Bengaluru

IT/Computers - Software

Job Description

Job Designation : Teradata Lead
Keywords / Keyskills : Teradata, Stored Procedures, CLDM, Micro Strategy
Mandatory Key skills : Teradata, Stored Procedures, CLDM, Micro Strategy

Location : Bangalore
Experience Range : 5-8 Years
Industry : IT or Telecom

Job Description :

4 - 6 years of Database Design experience in Teradata.
SQL and Database experience with a major RDBMS (for example Teradata)
Hands on experience in SQL, PL/SQL routines development
Creating high level Common Semantic layer Architecture based on customer expectations. Review it with SMEs from client side and baseline the high-level model.
Owning the end to end Semantic modelling work
Analyze business requirements to determine the data elements needed in the Semantic Layer
Create necessary access layer objects for Facts, Dimensions to meet the business requirements
Should have good knowledge of Star Schema Design.
Must have good knowledge of OLAP queries, Aggregates, and usage of analytical functions in SQL queries
Good understanding of any one BI tool like MicroStrategy
Interact with Business SMEs to understand required data elements, the business rules governing them and confirm definitions
Create, manage and modify conceptual, logical and physical data models for Semantic Layers. Present data models to business and technical audiences for review and validation
Apply views, indexes and tables as required to meet the defined performance service levels (SLAs) for application access of the data warehouse.
Resource should have good understanding in PL SQL.
Should be able to develop, test, debug and optimize the stored programs units.
He should understand telecom terminology.
He should have understanding of Teradata CLD