This job board retrieves part of its jobs from: Toronto Jobs | Emplois Montréal | IT Jobs Canada

The Land of Lincoln is hiring! New job offers every day

To post a job, login or create an account |  Post a Job

SQL SSIS Developer

Kforce Technology Staffing

This is a Full-time position in Chicago, IL posted June 8, 2021.

RESPONSIBILITIES Kforce has a client in Chicago, IL that is searching for an experienced SQL SSIS Developer. Responsibilities Design, develop, and enhance ETL and BI Solutions using the Microsoft SSIS and SQL Server Relational Database technologies Participate and deliver on new data warehouse project and be the main ETL support member after the go-live Monitor production jobs, maintain, and enhance legacy ETL processes on a regular basis Improve slow running jobs with the help of redesign and better ETL processes to meet business needs Work very closely with the existing DBA to design, model, develop, and maintain existing and new SQL databases objects required for all business solutions Take directions, follow recommendations provided by data architecture, Info Security and data governance organization Confer with relevant business and IT team members where necessary Study systems flow, data usage, and work processes Deliver functional work product that has been thoroughly tested Follow development team’s SDLC process Accurately estimate time required to complete projects and tasks Meet mutually agreed upon deadlines for completion of modules throughout the program development REQUIREMENTS Bachelor’s degree in Science or Engineering required Over 5 years of experience in developing ETL and Business Intelligence Solutions using SSIS, SSRS, and expertise in designing and implementing Relational Database models per business needs Must have DevOps-2019Team foundation experience Must have visual Studio 2019 Development experience Must have experience in Database Development, Design, Analysis, SQL Servers 2015-2019 in Development, Testing and Production Environments with various business domains Experienced in ETL data from excel, flat file C and C used for scripting in Script Tasking in SSIS to control the flow of SSIS package Very good working experience of T-SQL Proficiency in complex stored procedures, User Defined Functions (UDF), Database Triggers, using tools like SQL Profiler and Database Tuning Advisor (DTA) Must have implemented incremental load for many SSIS packages Experience in error handling, debugging, error logging for production support in SSIS Experience in bulk importing CSV, XML and Flat files data using Bulk Copy Program (BCP) Must have knowledge of PowerBI Nice to have knowledge of Cloud Technology Works well independently capable of self-motivating and managing Kforce is an Equal OpportunityAffirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.