Company Logo

Data Warehouse - Data Modeller (Dimensional Modelling)

at  Travancore Consultancy(Posted by travancore consultancy)

Data Warehouse - Data Modeller (Dimensional Modelling)

at  Travancore Consultancy(Posted by travancore consultancy)

3 Openings

Posted 3 weeks, 2 days Back


10Lac  - 20Lac  CTC


6 yrsto12 yrs experience| Resume Required


HSR Layout, Bengaluru

Share via

Share via EmailShare via FacebookShare via LinkedinShare via Whatsapp

Additional Details

Job Type

Full Time

Working Days

5 days

Job Requirements


Graduation degree preferred

Bachelor of Technology (B.Tech)/Bachelor of Engineering (B.E.) preferred


6 yrs to 12 yrs of experience as Software Developer in IT- Software preferred

Job Description

Data Warehouse – Data Modeller (Dimensional Modelling)

Greetings from Zsah Managed Technology Services!

Looking for Data Modeler with 6 to 12 years of experience

Location: Bengaluru

A highly experienced Data Modeller with strong experience in data profiling, Data Quality Analysis, Dimensional Modelling and Data Warehouse concepts& architecture. Candidate must have experience in Erwin modelling tool to develop and maintain logical and physical data models.Candidate should be disciplined, detail-oriented, self-motivated, and delivery-focused.

Technical skills:

·         7 to 10 years of strong experience in data profiling, Data Quality analysis and Dimensional modelling.

·         Experience in profiling from single column, to single table, to cross-table structural profiling and cross columns analysis.

·         Experience in using Erwin modelling tool to develop and maintain data models.

·         Experience in creating efficient data models for SQL Server 2016.

·         Experience in working with Source SMEs, DW Architect, Technical Leads and ETL developers to facilitate the overall data warehouse build and ETL development.

·         Analyse data-related system integration challenges and propose appropriate solutions.

·         Ability to understand data requirements and able to create data model to support self-service BI.

·         Expert knowledge in RDBMS concepts and SQL.

·         Experience in ETL tools like ODI, Pentaho or BODS.

·         Work experience in ETL development and design.

·         Strong in data warehouse architecture, methods, concepts, techniques, dimensional modelling to support building enterprise data warehouse and dimensional models.

·         Experience in assessing the risksand challenges involved inintegrating multiple data sources.

·         Experience in defining data governance processes to improve the quality of the data.

·         Experience in writing source to target mapping sheet.


Non-Technical skills:

·         Strong Communication skills

·         Must have experience with On Site and Off Shore Development model.


Skills Desired but not mandatory:

·         Pentaho

·         Business Objects

·         Python 2.7


• Full Name:

• Total Year of Exp.:

• Relevant Year of Exp.:

• Current company:

• Current CTC:

• Exp. CTC:

• Notice Period:

• Negotiable Notice Period/Buyout:

• Skype ID:

• Contact no:

• Reason for change:

• Current Location:

Interested candidates, please drop your updated CV 

Company Details

TRAVANCORE CONSULTANCY HR SERVICES can help your company HR tasks.

Travancore Consultancy HR Services as India’s fastest-growing job Recruitment company connecting quality job seekers with the Best of Corporate.

What we do:

Travancore Consultancy HR services are designed to bridge the gap between specialty sectors which were manpower starved, and respective Indian manpower, which was hungry for opportunities.

We are providing services in the area of HR Consulting and HR process outsourcing.

We’ll help you improve both job satisfaction and engagement in your organization.

Our Mission

Our mission is to consistently deliver value to our clients, provide them with staffing services, screen candidates with our efficient hiring techniques in the stipulated time frames.

Our Vision

To emerge as an uncompromising organization in excellence, morale & veracity, constantly striving to live up to the trust our esteemed clients have upon us.

Our Strength

  • Vast database
  • Dedicated Workforce
  • Client Relations

Our Clients:

  • NIIT Technologies
  • Gatwick Airport Limited
  • Laxwill Digital Innovations
  • Vedya Info Solutions

Data Warehouse - Data Modeller (Dimensional Modelling)

at  Travancore Consultancy(Posted by travancore consultancy)


10Lac  - 20Lac  CTC


HSR Layout, Bengaluru


6 yrsto12 yrs experience

Note: Aasaanjobs does NOT ask money from jobseeker anytime. If a company is asking money from jobseeker, it is most probably a scam.