Overview
On Site
$80,000 - $110,000
Full Time
Skills
Microsoft SSIS
SSIS
Extract
Transform
Load
ETL
SQL
Data Warehouse
Microsoft SQL Server
FP&A
Data Quality
Stored Procedures
SQL Server
Job Details
Job Role: SSIS Developer
Location: Raleigh, NC
Job Description:
- 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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.