SSIS developer

Job Description

SSIS Developer

•              Proficient with ETL tools such as Microsoft SSIS

•              Analyze and develop strategies and approaches to import and transfer data between source, staging, and

•              ODS/Data Warehouse destinations

•              Designing and developing SSIS / SQL ETL solutions to acquire and prepare data from numerous upstream systems for processing into FP&A Systems 

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

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

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

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

•              Support system and acceptance testing including the development or refinement of test plans

•              Create documentation outlining ETL processes, deployment packages and installation process.