(Phase 2) Cleaning Historical Financial (end of day) Dataset to Create Accurate Dataset. (Data prep / data quality) -

Project Description

Expand existing SSIS package functionality so it can continue to update the clean “gold standard” end of day database daily, in a forward-looking fashion. The package will connect to the four data sources (tblHistoricalData, Google, Yahoo, XIgnite) and construct a new record for each US ticker symbol each day. Also, the SSIS package will need to be adjusted so we can install it within our SQL Server 2012 environment.

 Note: this project is being awarded to the same expert who performed the first phase.