Phone/skype Hire
Location: Columbia, SC Duration: 7+ months Rate: Open Historically, the Data Warehouse application team has used the proprietary Embarcadero DT/Studio tool, along with custom transform code from RSI, to load data from federal and state data sources into the Data Warehouse. The team is now charged with converting all of the data load processes to use Microsoft SQL Server Integration Services (SSIS) At this time an experienced ETL (Extract, Translate, and Load) specialist with expertise in SSIS is needed to assist in this process. Responsibilities: . Responsible for building ETLs using SSIS packages to load data from various data sources including files from internal and external data sources. . Setting up and running the proprietary Portfolio Warehouse Associate and Grow (A&G) offline process for data cleansing and matching of these files. This includes configuring the A&G match keys with consultation from the business users and Data Warehouse team. . Conduct quality assurance for loaded data. . Creating and executing "views" as required by business users. . Performing database utility functions, such as SQL Server Analytical Services for OLAP, development of stored procedure, SSIS, etc. as needed for loading and analysis of data Skills Needed: . ETL . SSIS . SQL Server . TFS . T-SQL . C# . Java . Data Warehousing . Data Mart . Testing Thanks Sandeep Sandeep Jain Software People Inc. [email protected] Ph: 631-863-0299, 631-410-4741, 631-921-2111 C Fax: 631-574-3122 Twitter: Software People @spincjobs Certifications: SBA 8a/SDB, NY MWBE, VA SWaM, DE OMWBE, MA MWBE -- You received this message because you are subscribed to the Google Groups "Exact Match" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/exact-match. For more options, visit https://groups.google.com/d/optout.
