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
KINDLY SEND THESE DETAILS ALONG WITH LATEST RESUME IN WORD FORMAT
• 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