Squircle IT Consulting Services Pvt Ltd Logo

Squircle IT Consulting Services Pvt Ltd

Data Modeler – Teradata

Posted Yesterday
Be an Early Applicant
In-Office
Mumbai, Maharashtra, IND
Senior level
In-Office
Mumbai, Maharashtra, IND
Senior level
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.
The summary above was generated by AI
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: 

Similar Jobs

2 Hours Ago
Hybrid
Mumbai, Maharashtra, IND
Junior
Junior
Fintech • Legal Tech • Software • Financial Services • Cybersecurity • Data Privacy
Client-facing fund accountant responsible for private equity, hedge fund and debt fund accounting. Tasks include processing capital activities, booking transactions, preparing NAVs and investor reporting, computing management fees and carried interest, performing waterfall allocations, and interacting with clients on operational and accounting matters across jurisdictions.
Top Skills: Investran
2 Hours Ago
Hybrid
Mumbai, Maharashtra, IND
Mid level
Mid level
Fintech • Legal Tech • Software • Financial Services • Cybersecurity • Data Privacy
Provide fund accounting services for global hedge fund, private equity and debt fund clients. Handle investor capital activities, booking transactions, NAV preparation, fee and carried interest computations, investor and fund-level reporting, and client interaction. Work with complex fund structures (SPVs, master-feeder), multiple asset classes, and instruments including TRS, MBS, and CLOs.
Top Skills: Investran
2 Hours Ago
Hybrid
Mumbai, Maharashtra, IND
Senior level
Senior level
Fintech • Legal Tech • Software • Financial Services • Cybersecurity • Data Privacy
Manage end-to-end transfer agency investor services for private equity funds, including capital calls, distributions, investor onboarding/KYC, registry maintenance, investor communications, liaising with internal and external stakeholders, supporting audits, UAT/process improvements, and mentoring junior staff while ensuring regulatory compliance and data integrity.
Top Skills: GenevaIntralinksInvestor PortalInvestor VisionInvestranExcel

What you need to know about the Mumbai Tech Scene

From haggling for the best price at Chor Bazaar to the bustle of Crawford Market, the energy of Mumbai's traditional markets is a key part of the city's charm. And while these markets will always have their place, the city also boasts a thriving e-commerce scene, ranking among the largest in the region. Driven by online sales in everything from snacks to licensed sports merchandise to children's apparel, the local industry is worth billions, with companies actively recruiting to meet the demands of continued growth.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account