Job Designation : Teradata Lead
Keywords / Keyskills : Teradata, Stored Procedures, CLDM, Micro Strategy
Mandatory Key skills : Teradata, Stored Procedures, CLDM, Micro StrategyLocation : 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