• 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)

Job Details

Total Positions:
1 Post
Job Shift:
Second Shift (Afternoon)
Job Type:
Department:
Business Intelligence
Job Location:
Gender:
No Preference
Minimum Education:
Bachelors
Degree Title:
Computer Science or Software Engineering
Career Level:
Experienced Professional
Experience:
3 Years - 5 Years
Apply Before:
May 02, 2019
Posting Date:
Apr 03, 2019

Cloud Ventures Private Limited.

Information Technology · 601-1000 employees - Karachi

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.

What is your Competitive Advantage?

Get quick competitive analysis and professional insights about yourself
Talk to our expert team of counsellors to improve your CV!
Try Rozee Premium

Similar Job Titles

Data Engineer

Horizon Technologies, Karachi, Pakistan
Posted Mar 09, 2024
I found a job on Rozee!