• Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process
• Design and develop SSRS / SSIS / SQL ETL solutions to acquire and prepare data from numerous upstream systems
• Build data transformations with SSIS including importing data from files, moving data from one database platform to another.
• Building reports using SSRS
• Debug and tune SSIS, SSRS or other ETL processes to ensure accurate and efficient movement of data
• Design, implement and maintain database objects (tables, views, indexes etc) and database security
• Experience working with SSIS, SSRS packages
• Proficient with ETL tools such as Microsoft SSIS, SSRS
• 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
• Support system and acceptance testing including the development or refinement of test plans
• Any other adhoc duties as assigned