Data Modeler – Teradata

Posted 17 Days Ago
Be an Early Applicant
Mumbai, Maharashtra, IND
In-Office
Senior level
Information Technology • Software • Business Intelligence • Consulting
The Role
Lead logical data modeler responsible for translating business requirements into conceptual, logical and physical data models on Teradata, customizing iLDM models, defining modelling/mapping standards, and guiding model implementation and performance considerations.
Summary Generated by Built In
Company 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

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.

Additional Information

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: 

Skills Required

  • Expertise in 3NF modelling
  • Exposure to Teradata industry models (iLDM) such as FSLDM, cLDM, mLDM, rLDM
  • Ability to gather requirements, produce conceptual data models and map business requirements to models
  • Experience customizing iLDM when requirements don't map to existing subject areas/entities
  • Converting conceptual definitions to LDM and LDM to PDM
  • Good exposure to data warehouse concepts and understanding of normalization / denormalization
  • Hands-on experience in dimensional modelling
  • Good knowledge of Teradata architecture
  • Experience with industry-standard data modelling tools (Erwin preferred)
  • Designing data modelling/mapping standards, metadata strategy, and end-to-end source-to-PDM mappings
  • Experience in Teradata 12.0 or greater environments
  • Knowledge of advanced Teradata concepts: join strategy, index choice, performance optimization, compression
  • Experience with Teradata utilities: BTEQ, MLOAD, FLOAD, TPUMP
  • Exposure to query tuning
  • Good understanding of ETL methodology
  • Leadership skills to lead a team of modellers
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
30 Employees
Year Founded: 2007

What We Do

Squircle IT Consulting Services Pvt Ltd is a leading IT solutions and services company established with a mission to provide comprehensive, top-of-the-line solutions specializing in Enterprise Resource Planning (ERP) and Business Intelligence (BI). Based in Hyderabad, India, the company offers a full spectrum of services ranging from implementation and business consulting to support, leveraging deep technology and domain expertise.

Similar Jobs

Comcast Logo Comcast

Development Engineer

Digital Media • Information Technology • News + Entertainment
Remote or Hybrid
India
115000 Employees

ZS Logo ZS

Senior Engineer

Artificial Intelligence • Healthtech • Professional Services • Analytics • Consulting
Hybrid
3 Locations
15000 Employees

ZS Logo ZS

Cloud Security Engineer

Artificial Intelligence • Healthtech • Professional Services • Analytics • Consulting
Hybrid
Pune, Maharashtra, IND
15000 Employees

ZS Logo ZS

Scientist

Artificial Intelligence • Healthtech • Professional Services • Analytics • Consulting
Hybrid
3 Locations
15000 Employees

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account