Send me more jobs like this

Keywords / Skills : Data Modeller

6 - 8 years
Posted: 2018-12-04

Industry
Recruitment/Staffing/RPO
Function
IT
Role
Software Engineer/ Programmer
Posted On
4th Dec 2018
Job Ref code
110843000009192667
Job Description
Job Description:

Source data analysis and Business requirement analysis.
· Understanding the business requirements and translating them into Logical Data Models.
· Creating Physical Data Model using Dimensional Modelling techniques.
· Working with the DBA in creating efficient table designs.
· Create and Maintain Data Model documentation.
· Understand business transformation logic and create Data Mapping document (Source System to Target systems).
· Creating ETL jobs as and when required.
· Advising the reporting team on efficient methods of data retrieval.
·Skill Set:

Basic Qualification:
· 6+ years of experience in Data Warehousing.
· 5+ years of experience in Data Modelling.
· 3+ years of experience in ETL.
· Reporting experience preferred.

Required Skills:
· Data Modelling concepts ʍimensional and Relational)
· Data Modelling best practices and techniques
· Logical Data Modelling
· Physical Data Modelling
· Advanced SQL Skills
· Experience with databases like DB2, Netezza
· Hands on Data analysis skills.
· Experience in Manufacturing or Supply chain centric industries would be preferred
· Hands on experience in ETL using Data Stage.
· Hands on experience in Infosphere Data Architect would be preferred.

Technology and Tools:
· RDBMS databases like DB2, Oracle. DB2 preferred.
· MPP databases like Netezza, Teradata.
· Brio
· SQL
· Infosphere Data Architect
· Data Stage
· Cognos (Good to Have)
Key Skill(s)

Similar Jobs
View All Similar Jobs
Walkin for you