Requirements
- Expertise in 3NF modelling
- Exposure to one of the industry model, iLDM, produced by Teradata, e.g., FSLDM, cLDM, mLDM, rLDM
- Experience in understanding business requirements, discussing with the Business, summarizing them, and converting them into Conceptual Data Model
- Worked on one of the iLDM produced by Teradata, mapping business requirements to the model
- Customized the model where requirements don’t map to any Subject Area/Facet/Entity/Attribute in the Model
- Good exposure to Datawarehouse concepts
- Understanding of Normalization and De-normalization concept
- Hands on experience in Dimensional Modelling
- Good knowledge of Teradata architecture
- Must have used one of the industry standard Data Modelling tools
- Design technical solution for setting up the data modelling and mapping standards, Meta-data for the Model and End to End mapping from source to PDM
Nice to Have
- Erwin experience will be added advantage
- Hands on experience in converting business definitions/conceptual model into LDM (logical data model) and converting LDM to PDM will be added advantage
- Must have worked in Teradata 12.0 or greater environments
- Very good knowledge of Advanced Teradata concepts like Join strategy, Index choice, Performance Optimization, Compression, etc.
- Experience in Teradata utilities BTEQ, MLOAD, FLOAD, TPUMP
- Exposure to query tuning
- Good understanding of ETL methodology
Additional Information
- Notice period: 2 months
- Leadership Skills: Should be able to lead the pool of Modellers
