Zenotis Group · 4 hours ago
SSIS Developer
Zenotis Group is seeking a Senior SSIS Developer to join their team in Raleigh, NC. The role involves designing and developing SQL Server stored procedures and SSIS/SQL ETL solutions to manage data processing from various upstream systems.
Responsibilities
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 non-production environments
Qualification
Required
10+ years of experience
Proficient with SSIS
Experience working with SSIS packages
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
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
Company
Zenotis Group
Zenotis Group is among the fastest-growing Talent Acquisition firms across North America and India.
Funding
Current Stage
Growth StageCompany data provided by crunchbase