ETL developer

  • location: Joliet, IL
  • type: Contract
  • salary: $45 - $50 per hour

job description

ETL developer

job summary:
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. First Midwest Bank is in the early stages of building a significant data warehouse. The office is in downtown Joliet with some flexibility to work from home. This role has frequent interface with business leaders to discern data requirements.

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 models per business needs.
  • Must Have DevOps-2019/Team 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).
  • 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.
  • Position may require the need to travel to other branch or meeting locations in Chicago land.
DUTIES/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
  • Works well independently; capable of self-motivating and managing
 
location: Joliet, Illinois
job type: Contract
salary: $45 - 50 per hour
work hours: 9am to 5pm
education: Bachelors
 
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
  • Works well independently; capable of self-motivating and managing
 
qualifications:
  • Experience level: Experienced
  • Education: Bachelors (required)
 
skills:
  • ETL
  • SSIS
  • SQL

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

get jobs in your inbox.

sign up
{{returnMsg}}

related jobs

    ETL developer

  • location: Joliet, IL
  • job type: Contract
  • salary: $45 - $50 per hour
  • date posted: 6/4/2021

    SQL Server Developer

  • location: Lisle, IL (remote)
  • job type: Contract
  • salary: $45 - $50 per hour
  • date posted: 6/7/2021

    AWS Developer (Data)

  • location: Downers Grove, IL (remote)
  • job type: Permanent
  • salary: $110,000 - $125,000 per year
  • date posted: 6/11/2021