Data Modeler – Teradata

SQUIRCLE IT CONSULTING SERVICES PVT. LTD; Mumbai; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Squircle IT Consulting Services in Mumbai is seeking an experienced Data Modeler to lead logical data modeling efforts for Teradata-based data warehouses. You will translate business requirements into conceptual and logical models, design end-to-end mappings from source to physical data models, and drive standards and best practices across a team of modellers.

You will apply expertise in 3NF, dimensional modelling, and Teradata architecture, and contribute to performance optimization and data

Qualifications

• Must have expertise in 3NF modelling.
• Must have exposure to iLDM Teradata models (e.g., FSLDM, cLDM, mLDM, rLDM).
• Hands on experience converting conceptual models to LDM and LDM to PDM.
• Experience with Dimensional Modelling and Teradata architecture.
• Experience with Teradata utilities: BTEQ, MLOAD, FLOAD, TPUMP.

Responsibilities

• Lead the Logical Data Modeller role for Teradata-based data models.
• Design data modelling standards and metadata for the model.
• Perform end-to-end mapping from source to PDM and ensure alignment with business requirements.
• Mentor and lead a pool of data modellers.

Skills

3NF modelling

Dimensional modelling

Teradata

Erwin

Data warehouse concepts

Normalization/Denormalization

Data modelling standards

Leadership

Query tuning

ETL methodology

Teradata utilities

Tools

Erwin

Job description

Squircle IT Consulting Services is a leading IT solutions and services company established with a specific mission of providing comprehensive, top of the line solutions around ERP and BI. Since its inception in November, 2007, SQUIRCLE has emerged as a key player in ERP and BI space. SQUIRCLE brings together the best Technology and Domain expertise in PeopleSoft to offer a full spectrum of services ranging from Implementation, Business Consulting to Support.

Job Description

JD:

Data Modeler : A brief back-ground on role (typically for recruitment use)

• This role is for the Lead Logical Data Modeller, the Database platform will be Teradata. Most places Teradata Industry Standard model will be implemented.
• Technical Skills & Expertise Required Must have expertise in 3NF modelling.
• Must have exposure to one of the industry model, iLDM, produced by Teradata. Eg, FSLDM, cLDM, mLDM, rLDM etc.
• Must have taken the activity to understand the requirements, discuss with the Business to summarize them and convert them into Conceptual Data Model.
• Must have worked on one of the iLDM produced by Teradata,
• where by mapping of Business requirements to the Model are performed. Also customized the model to an extent, where requirements don't map to any Subject Area/Facet/Entity/Attribute in the Model.
• Hands on experience in converting business definitions/conceptual model into LDM (logical data model) and converting LDM to PDM will be added advantage.
• 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, Erwin experience will be added advantage.
• 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.

Good To have

------------------

• 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.
• Leadership Skills Should be able to lead the pool of Modellers.

Additional Information

Hi,