Description
Position: SSIS Developer
Project: Physical Damage Data Storage for analysis and reporting.
Reporting data is in various DB2 and SQL server tables. SSIS will be utilized as ETL (extract transform load) tool to extract data from various database sources, manipulate/merge the data and store it in new tables in SQL platform.
Required Skills:
* SQL Server Integration Services (SSIS)Manipulating Data, need to have SSIS experience in a high volume environment.
* SQL Server Analysis Services (SSAS)
* XML
* Experience with data validation and cleansing,
Preferred Skills:
* Proficiency with complex stored procedures and T-SQL.
* DB2
* SQL
Required Experience and Responsibilities:
* Responsible for bringing data from these disparate sources and bring it to SQL server environment.
* Analysts primarily access these data to develop analysis and reporting, goal to ease future data analysis work.