SaintCharlesRecruiter Since 2001
the smart solution for Saint Charles jobs

Integration Engineer

Company: Jobot
Location: Saint Charles
Posted on: May 17, 2022

Job Description:

A bit about us:We believe in developing and retaining the best people in the industry and providing the best value services to our customers in the natural gas and electric industries. We take pride in developing the infrastructure of our country by connecting people and resources. We have built our reputation as a premier provider of services with a solid track record of performance, integrity and - above all - a commitment to safety, quality, and our people.Why join us?Great Team and Leadership!Opportunity for growth and Advancement.Benefits, bonus and 401k.Job DetailsWe are a fast-growing IT team focused on digital transformation, with an emphasis on releasing high-impact and high-quality solutions.Responsibilities:o T-SQL programming of SPs, functions, views, triggers, and other DB objects in SQL Servero Design, integrate, and develop ETL processes as requiredo Develop, implement, and optimize stored procedures and functions using T-SQLo Analyze existing SQL queries for performance improvementso Debugging and troubleshooting code related issues/defectso Develop procedures and scripts for data migrationo Create and update design documents in compliance with department policies.o Assist with various projects as assigned by a direct supervisor.o Experience working in a SOX compliant environment and keeping the environment compliant is a plus.o 3+ years of experience in SSIS.o 3+ years of experience in building ETL data flows using SSIS, creating workflows / data mapping to extract or push data.o Good knowledge of RDBMS topics, ability to write complex SQL Queries.o Write effective, scalable code to perform data transformation and integrationo Good communication skills and experience interacting with business stakeholders.o Overall 5+ years' experience with SQL, SSIS, and Dell Boomio Experience in Agile development methodologieso Excellent user-facing communication skills and an efficient team playero Good understanding of database environments, online analytical processing (OLAP) and ETL (Extract, transform, load) frameworksThe ideal candidate would also have:o Experience with Database on-Prem and in Azure, with data handling through the database gateway will be a plus.o Good working knowledge of Microsoft SQL Server environment, query optimization, performance tuning of stored procedures is a big plus.o Preferable but not mandatoryo AWS/Azure, Python programming experienceo Good familiarity with developing in a Microsoft technical environment, including Windows Server admin and SQL Database administration.o Familiarity with troubleshooting user requests and prioritizing the workload will be helpful.o The job requires working with Remote & distributed users across the US. Experience communicating with users via phone/MS Teams etc., understanding their requirements, following SDLC cadence to deliver project requests on time is plus.o Ability to work with offshore teams is a preferred.o Ability to work in a fast-paced challenging environment - accountable for your own actions and able to take ownership.

Keywords: Jobot, Saint Charles , Integration Engineer, Engineering , Saint Charles, Missouri

Click here to apply!

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

I'm looking for
in category

Log In or Create An Account

Get the latest Missouri jobs by following @recnetMO on Twitter!

Saint Charles RSS job feeds