Data Engineer

Data Analytics Riyadh, Ar Riyad, Saudi Arabia

Profile
Contacts

Summary

Over Six (6+) years of experience as an programming developer in T-SQL ,Microsoft SQL
Server, Oracle-PLSQL , ETL DataStage with 2+ years of experience in data visualization
tools - Tableau and SSRS.
Extensive experience in Analysis, Design and implementation of Business applications
using the Microsoft SSIS , Oracle Relational Database Management System (RDBMS) and
SQL Server Management Studio (SSMS) .
Strong understanding of the principles of Data Warehousing using Fact tables, dimension
tables and Star/Snowflake schema modelling.
Worked extensively with Dimension modelling, Data Migration, Data cleansing, ETL
processes for Data Warehousing.
Experienced in scheduling and troubleshooting of jobs using tools like Autosys and
Control-M.
Produced attractive/Informative dashboards to covey the story inside the data using
Tableau.
Designed, developed, tested and maintained Tableau functional reports based on user
requirements.
Experience with Data Flow diagrams, Data Dictionary , Database Normalization theory
techniques , Entity relation modelling and design techniques.
Sound knowledge of Data Warehousing concepts, ER model , Dimension Modelling, 3NF
like Star Schema , Snowflake Schema and database architecture for OLAP and OLTP
applications, data analysis and ETL processes.
Experienced in client server application development using Oracle 11g, Oracle 12C,
Microsoft SQL Server 2012/2014, analytical Functions, Database Design, query
optimization and performance tuning.
Effectively made use of Table Functions , Indexes , Table Partitioning , Analytical
Functions, Views , Materialized Views and Query Re-write for new business requirements