Job Description :
Position: Data warehouse Consultant
Location: San Jose, CA
Duration is 6+Months
Rate: Open
Job Description:
Develop data warehouse and database for Cisco Managed Services customer data. Experience with data warehousing (Hadoop, Oracle, SQL, MS Access), and front-end business intelligence tools (Tableau, Sharepoint, Excel
Experience with Cisco data warehousing solutions a plus. Experience with building highly available, durable and scalable data warehousing solution.
Skills and Qualifications:
Database Design, Data Maintenance, Database Security, Database Management, Requirements Analysis, Teamwork, Presenting Technical Information, Training , Operating Systems
Responsibilities:
· Determines database structural requirements by analyzing operations, applications, and programming; reviewing objectives; evaluating current systems.
· Develops database solutions by designing proposed system; defining database physical structure and functional capabilities, security, back-up, and recovery specifications.
· Installs database systems by developing & building process flowcharts; applying optimum access techniques; coordinating installation actions; documents actions.
· Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance; answering user questions.
· Provides database support by coding utilities, responding to user questions, and resolving problems.
· Develop Gap Assessment including; Identify data Sources, Coordinate with SME’s, Understand data, Frequency of reports
· Define Unique identifier; define taxonomies and mapping, Roles and Responsibilities to maintain, where to store
· Define data and model elements; How will data be stored, consumed, integrated and managed by different data entities, how will data integrated with IT systems, definitions, Inputs, outputs and dependencies
· Develop Prioritization by the phases and define what and how reports will be generated (To-Be State)