JolietRecruiter Since 2001
the smart solution for Joliet jobs

BI SSIS ETL Developer - Joliet

Company: Connect Search LLC
Location: Joliet
Posted on: August 14, 2019

Job Description:

Connect Search is looking for an SSIS ETL developer for one of our great clients in Joliet. US Citizens Green Card holders are encouraged to apply No 3rd Party companies POSITION SUMMARY The ETL Developer is responsible for the development and implementation of technical solutions. This role leverages technical expertise in database applications, ETL processes, and automation in support of internal and external customers data exchange and integration needs. REQUIRED EDUCATION, EXPERIENCE AND SKILLS 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 modelas per business needs Must have experience in Database Development, Design, Analysis, SQL Servers 2015-2019 in Development, Testing and Production Environments with various business domains Experienced in extracting, transforming and loading 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) 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) Hands on experience in performance tuning and query optimization including updating statistics, rebuilding and re-organizing indexes Experienced in normalizing and de-normalizing the tables and maintaining referential integrity by using triggers and primary and foreign keys Ability to work independently and be able to collaborate and guide other team members Strong written and oral communication, experience on reproving and presenting new design and solutions to senior leadership Working knowledge of MS SSMS 2012 to 2019 Working knowledge of analytical and data visualization technology such as Power BI, R Services Working knowledge of cloud based data architectures leveraging PAAS, IAAS, DAAS etc.. Familiarity with MS DQM, MDM, Big Data concepts Works well independently capable of self-motivating and managing Position may require the need to travel to other branch or meeting locations. DUTIESRESPONSIBILITIES Designing and developing (enhancements and maintenance) new ETL and Business Intelligence Solutions using the Microsoft SSIS and SQL Server Relational Database technologies Participate and deliver on new data warehouse project and later work as 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 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 Works well independently capable of self-motivating and managing

Keywords: Connect Search LLC, Joliet , BI SSIS ETL Developer - Joliet, IT / Software / Systems , Joliet, Illinois

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Other IT / Software / Systems Jobs

Software Engineer
Description: Robert Half is currently seeking a Unity Developer for a long-term contract position. The Unity Developer must be able to creat new platforms and maintaining existing technologies. The Unity Developer (more...)
Company: Robert Half Technology
Location: Chicago
Posted on: 08/21/2019

Field Service Representative
Description: Magid is seeking a PART TIME Field Service Representative to work an estimated 2-4 hours a week, servicing our customers in the Bensenville, IL. 60106 area. br br br Why MAGID br br We're a (more...)
Company: Magid Glove & Safety
Location: Bensenville
Posted on: 08/21/2019

Entry Level Software developer
Description: Role Software Developer Location Chicago, IL Responsibilities Develop, create, and modify general computer application software or specialized programs
Company: Tata Consultancy Services
Location: Chicago
Posted on: 08/21/2019

PL/SQL Developer with BI and AWS
Description: Requisition 498133819190813 Title PLSQL Developer with BI and AWS Location Chicago, IL Duration Client full-time Requirements 8 years
Company: Alans Group
Location: Chicago
Posted on: 08/21/2019

Arity - Kafka Administrator
Description: Founded by The Allstate Corporation in 2016, Arity is a data and analytics company focused on improving transportation. We collect and analyze enormous amounts of data, using predictive analytics to build (more...)
Company: Allstate
Location: Chicago
Posted on: 08/21/2019

Lead Developer
Description: Let companies apply to you, not the other way around. Sign up with Hired to get access to thousands of companies currently hiring lead developers, designers and engineers.Want to work for a company you (more...)
Company: Hired
Location: Hammond
Posted on: 08/21/2019

Project Manager with Mobile Apps projects Exp
Description: Project Manager with Mobile Apps projects Exp Chicago,
Company: Headway Tek Inc
Location: Chicago
Posted on: 08/21/2019

Java Developer with Micro services
Description: 6 years of experience with JavaJ2EE, SQL PLSQL, Restful Service, JSON.
Company: Kani Solutions
Location: Chicago
Posted on: 08/21/2019

UI Developer
Description: Hope you are doing well Please go through the below job description and let
Company: StoneGate-Technologies LLC
Location: Chicago
Posted on: 08/21/2019

Technical Lead
Description: ROLE Technical Lead Location Bolingbrook, IL Duration 6 months Mandatory Skills
Company: Akshaya Inc
Location: Bolingbrook
Posted on: 08/21/2019

Log In or Create An Account

Get the latest Illinois jobs by following @recnetIL on Twitter!

Joliet RSS job feeds