Send me more jobs like this

Keywords / Skills : Data Modeller, Data Warehousing, ETL, Logical Data, SQL , DB2, Netezza , Data analysis , Data Mapping, Data Management

6 - 8 years
Posted: 2019-09-01

Industry
Recruitment/Staffing/RPO
Function
IT
Role
Software Engineer/ Programmer
Posted On
1st Sep 2019
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)

Similar Jobs
View All Similar Jobs


Walkin for you