Blog

Role: SSIS developer

Location: Nashville, TN (Onsite)

Duration: Contract Position

Job Description:

• Design and develop SQL Server stored procedures functions views and triggers to be used during the ETL process
• Designing and developing SSIS SQL ETL solutions to acquire and prepare data from numerous upstream systems for processing by QRM
• 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
• 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
• Test and prepare ETL processes for deployment to production and nonproduction environments
• Support system and acceptance testing including the development or refinement of test plans”

Skills:

• SQL Server