Sql developer

Summary

11+ years of experience in Design, Development, Implementation and Maintenance of Data warehouse applications as an ETL/OLAP and OLTP Developer in MS SQL Server 7.0/2000/2005/2008.
Experience in designing and implementing ETL environments using ETL strategies as well as tools like SQL Server BI Tools (SSIS and SSRS).
Extracted data into Data warehouse Facts and Dimensions tables using SQL SERVER 2000/2005 Integrated Services (DTS/SSIS).
Very good experience and knowledge on SCD Types (Type1, Type2) and Change Data Capture (CDC).
Exposure in Data Modeling using Star/Snowflake Schema Design, Data Marts, Relational and Dimensional Data Modeling, Fact and Dimensional tables, Physical and Logical data modeling using Erwin.

Expectations

Exposure in Data Modeling using Star/Snowflake Schema Design, Data Marts, Relational and Dimensional Data Modeling, Fact and Dimensional tables, Physical and Logical data modeling using Erwin.
Experience in Microsoft SQL 2005 Server migration from SQL Server 2000, Integration Service (SSIS), Crystal Reports and Reporting Service (SSRS).
Excellent in High Level Design of ETL SSIS Package for integrating data from sources (Excel, CSV, flat file, Text Format Data).
Expert in Creating, Implementing, Configuring and deploying the SSIS Packages from one server to other.
Expert in migrate the DTS Packages to SSIS Packages by using Package migration Wizard.
Expert in Designing SSIS Packages to Extract, Transform and Load (ETL)/ DTS data into the data warehouse from heterogeneous databases such as Oracle, DB2, MS Access.
Extensive experience working with repositories such as Team Foundation Server (TFS), GIT HUB and Cheetah.
24/7 on call Production Support.

Employment Preferences
Expected Hourly Rate

** USD

Academic Degree
Security Clearance Level
Experience

Total Professional Experience

11 years

Startup Experience

5 years

Enterprise Experience

11 years
Contact Candidate

Contacts

Send a connection request to the candidate to get their contact details.

Contact Candidate