Responsible for data extraction from multiples sources such as Oracle, SQL, SAS, Access, Flat files etc.
Experience leading ETL Developers on different projects such as adding new features to the Data Warehouse or creating Data Marts for our BI (Business Intelligence) Team.
Possess extensive experience in writing Complex Queries using Microsoft SQL (T-SQL) like (Derived Tables, Correlated Queries, While Loops, Variables, Merge Statements and so forth)
Creation, Optimization and Maintenance of Databases
Responsible for developing ETL Processes for the Enterprise Data Warehouse (EDW)
Provide support with Ad-Hoc queries or Data mart options to our Reporting Layers to be used by BI tools such as Tableau and Business Objects and soon, SSRSS and Power BI
Implementation of ETL Architecture
Highly Adaptable and Experienced ETL Developer using SSIS and Attunity
Create Source to Target mapping document for tables used on the different schemas such as EDW (Star Schema) or for Data Marts
Responsible for presenting to Business Users any new enhancements done to our reporting capabilities utilizing visual tools such as PowerPoint and or Visio
I have knowledge working with Data Modeling Tool: ER/Studio from Embarcadero
I am a Quick Learner and Self-Motivated individual with Excellent Problem Solving Skills