Data Modeler – Teradata
At a glance
Mid-level Data Architecture & Governance role at SQUIRCLE IT CONSULTING SERVICES PVT. LTD. Mumbai · full-time.
Pay not stated Data Architecture & Governance salary
dataroles summary, based on the employer's posting.
What you'll do
- Turn business discussions into conceptual data models, then map requirements onto Teradata industry models
- Adapt the industry model when business needs fall outside its existing subject areas or entities
- Convert business definitions and conceptual models into logical models, then build physical models
- Set standards for modelling, metadata and end-to-end mapping from source systems to physical models
- Lead a team of data modellers
What you bring
- You have six to twelve years of experience and strong command of third normal form modelling
- You have worked with a Teradata industry model such as iLDM, mapping business needs and tailoring the model
- You bring hands-on dimensional modelling experience and a sound grasp of data warehouse concepts
- You have used an industry-standard data modelling tool and understand Teradata architecture
Who this fits
This mid-level role suits an experienced data modeller who can guide other modellers. The position is onsite in Mumbai.
From the employer
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.
Skill: Data Modeler – Teradata
Location: Mumbai & Bangalore
Exp: 6 to 12 years
N/P : 2 months
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.
Hi,
We have multiple openings for different location, for different clients. If you are interesting in plz find the attached details.
Closing Block
Full Name (As per PAN CARD):
Self Mobile number:
Alternate Number:
Email Address:
Total Experience:
Relevant Experience:
Highest Qualification (Degree):
Current Employer name (Payroll):
Current Designation:
Current CTC (Annual)
Expected CTC (Annual)
Official Notice Period (As per Offer Letter):
Can join in (Days):
Any Interviews / Offers in Pipeline:
Current Location:
Work / Requirement Location:
Date of Birth:
PAN card Number:
Interview Timings:
Data Architecture & Governance work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Architecture & Governance
Find me workBy the team behind dataroles.