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