Banner Image

All Services

Programming & Development

ETL Expert

$15/hr Starting at $25

I am a senior Data warehouse Architect with over 10 years experience in Data warehouse As a Data Analyst responsible for Analysis using SPSS, Design, Develop, Test and Implement ETL Job involves skills on SQL, PL\SQL, Statistics, and ETL tools like Datastage, Tech well aware of - MYSQL, MSSQL, PHP, Oracle,BD2,Cognos 8,10,10.2 and MSBI. An experienced Cognos Professional with database programming and administration skills Databases: SQL server, Oracle, My SQL, Postgres, SQL, PL-SQL I am expert in data analysis using R,SAS,SPSS, STATA,, Eviews, Minitab and excel. Please, give me an opportunity to work for you and deliver the best. I am responsible for the Design and the Development of the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2. The database is being updated daily from the core system via SSIS and a numerous of KPIS are being daily updated during the ETL. For performance reasons the KPIS are replicated to another DB which exploits the reports via SSRS to the consumers. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Finally several other reports are daily automatically produced and sent via email to the recipients. The size of the Master DB, which I am the Admin, is about 4TB and the replicated KPI DB is 350GB

About

$15/hr Ongoing

Download Resume

I am a senior Data warehouse Architect with over 10 years experience in Data warehouse As a Data Analyst responsible for Analysis using SPSS, Design, Develop, Test and Implement ETL Job involves skills on SQL, PL\SQL, Statistics, and ETL tools like Datastage, Tech well aware of - MYSQL, MSSQL, PHP, Oracle,BD2,Cognos 8,10,10.2 and MSBI. An experienced Cognos Professional with database programming and administration skills Databases: SQL server, Oracle, My SQL, Postgres, SQL, PL-SQL I am expert in data analysis using R,SAS,SPSS, STATA,, Eviews, Minitab and excel. Please, give me an opportunity to work for you and deliver the best. I am responsible for the Design and the Development of the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2. The database is being updated daily from the core system via SSIS and a numerous of KPIS are being daily updated during the ETL. For performance reasons the KPIS are replicated to another DB which exploits the reports via SSRS to the consumers. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Finally several other reports are daily automatically produced and sent via email to the recipients. The size of the Master DB, which I am the Admin, is about 4TB and the replicated KPI DB is 350GB

Skills & Expertise

Data ManagerDatastageEtlMsbiSsis

0 Reviews

This Freelancer has not received any feedback.