ETL SSIS

·         Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process

·         Builds data transformations with SSIS including importing data from files, moving data from one database platform to another

·         Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data

·         Design, implement and maintain database objects (tables, views, indexes, ) and database security

·         Experience working with SSIS packages

·         Good knowledge of event handling and error logging

·         Analyze and develop strategies and approaches to import and transfer data between source, staging, and ODS/Data Warehouse destinations

·         Test and prepare ETL processes for deployment to production and non-production environments