What are the responsibilities and job description for the SSIS Developer position at Centraprise?
Job Role: SSIS Developer
Job Type: Full time/ Permanent
Location : Raleigh, NC
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.
- Thanks & Regards,