• Data warehouse Architect Jobs in Pune,India - 25088803

  • Saama Technologies Pvt Ltd

Job Description:

Description Responsibilities -
Design and develop data warehouse architecture, data models and integration standards
Document relationships between entities and create ER diagrams
Document and publish Enterprise Data Warehouse schema details for enterprise wide consumption
Develop data models to provide single version of truth for all KPIs especially common business metrics
Develop methodology for Database design as a service to facilitate other groups to conform to design standards
Prepare inventory of data elements necessary to feed into enterprise data warehouse
Architect logical and physical data models, including normalized 3NF integration layers and denormalized dimensional presentation layers
Identify enhancements to existing models
Create and maintain procedures and supporting documentation in support of the DW environment and policies
Capture and analyze business requirements as and when needed

Qualifications -

Minimum Bachelors degree in a business or technical field (information systems, business administration, computer science)
Experience in a traditional data or analytics corporate environment
10 or more years and proven understanding of Data Warehouse, BI, and Business Analysis techniques
Experience working on Commercial Pharmaceuticals initiatives and projects
Should have worked with Oracle technologies
Expertise in SQL and in data modelling, including dimensional data models
Expertise in ETL and data integration concepts and tools (Informatica and SSIS preferred)
Experience in hybrid architectures leveraging traditional RDBMS (Teradata preferred) and Hadoop (Cloudera preferred)
Understanding of reporting tools (Tableau)
Understanding of Scrum/Agile methodology
Able to rapidly learn new processes/subject areas
Experience in Cloud environments is a plus Knowledge of Snowflake an additional plus
Strong communication, presentation and relationship management skills
Experience in building enterprise level data models that bring business optimization
Developed data modeling standards for external data integration with enterprise data sets
Well versed with latest technologies ie; No-SQL, Columnar databases is a plus

Profile Summary:

Employment Type : Full Time
Eligibility : Any Graduate
Industry : Software Services, Internet/Dot com/ISP
Functional Area : IT Software : Software Products & Services
Role : Data Warehousing
Salary : As per Industry Standards
Deadline : 12th May 2020

Key Skills:

These are some of our most popular tutorials

People who search this job also searched for the following Keywords


Salary trends based on over 1 crore profiles

View Salaries

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status