• Design, code, test, debug, and document complex database programs to ensure that data processing production systems meet user needs.

• Design and implement the data warehouse on a Microsoft SQL server platform.

• Knowledge on Data warehouse (Star, Snowflake Models) and writing ETL in PL/SQL. 

• PL/SQL, SQL Tuning and Optimization of current and existing applications.

• Develop and prepare schedule for new and existing data warehouse.

• Prepare plans for all ETL procedures and architectures.

• Analyze large databases and recommend appropriate optimization for same.

• Design data models and define both logical and physical models.

• Administer all requirements and design various functional specifications for data.

• Analyze various data warehouse objects.

• Excellent understanding of OLTP and OLAP systems.

• Prepare ad hoc queries reports for both technical and business teams.

• Prepare various code designs and ensure efficient implementation of same.

• Monitor data warehouse work and provide subject matter expertise.

• Provide training to all employees of development team.

• Select and deploy Power BI to facilitate reporting and analytics from the warehouse

Primary Skills:

Data Warehouse, Star & Snowflake Models, Data Marts, Data Mining, Data Clustering, Data Partitioning, Cubes, MDX, SQL, Database Designing, ETL, Query Optimization & Performance, Data Modeling, Business Intelligence (BI)

工作详细内容

全部职位:
1 发布
工作时间:
中班
工作类型:
部门:
Business Intelligence
工作地址:
性别:
没有偏好
最低学历:
学士
学位头衔:
Computer Science or Software Engineering
职位等级:
资深专业人员
经验:
3年 - 5年
在之前申请:
May 02, 2019
发布日期:
Apr 03, 2019

Cloud Ventures Private Limited.

· 601-1000 员工 - 卡拉奇

Simplifying IT for Customers & Partners: Royal Cyber Inc. Headquartered in Naperville, IL is a leading software organization that provides services ranging from application development and deployment to training and consultancy. We commenced the operations in the year 2002 as a specialized Technology provider striding in as a software deployment service provider, assisting clients to meet the standards and demands of doing business in the rapidly changing marketplace. Today we stand tall as a One Stop Shop for all your IT needs.

你最大的竞争优势

快速得到有竞争力的分析和专业的对你的评定
联系我们团队的专业顾问来提升你的简历
尝试罗资 专业版
我在ROZEE上找到工作啦!