ETL Developer

Company: Allied Solutions
Location: Carmel
Posted on: May 17, 2020

Job Description:

The purpose of the ETL Developer position is to design, develop, unit test, document, and perform ongoing support for the ETL and MS SQL products and code. Additionally, the developer needs to understand ETL to and from common database and file formats. This person is expected to be a subject matter expert that other team members can use as a reference for ETL, SQL, data design, and programming.The purpose of the ETL Developer position is to design, develop, unit test, document, and perform ongoing support for the ETL and MS SQL products and code. Additionally, the developer needs to understand ETL to and from common database and file formats. This person is expected to be a subject matter expert that other team members can use as a reference for ETL, SQL, data design, and programming.

Job Duties & Responsibilities

45% Troubleshooting and correcting data and data processing errors in existing solutions

25% Creating detailed documentation of data warehouse, data stores, and ETL.

10% Working with other technical teams as well as with internal and external users in order to develop technical designs

5% Reviewing designs with the rest of the project team as appropriate

5% Attending and contributing to architecture meetings to determine project scope, time frame and cost estimates

5% Understanding the data warehouse and data mart models as well as being familiar with the business information contained in each

5% Other duties as assigned

Qualifications

--- Bachelor's Degree required, or equivalent education / work experience

o 1-3 years of experience in data and dimension modeling

o 1-3 years of experience in ETL development

o 1-3 year of experience with Informatica

--- Experience with SQL required

--- Experience with Visual Studio required

C# preferred

The above statements are intended to describe the general nature and level of work being performed by people assigned to this job. They are not intended to be an exhaustive list of all responsibilities, skills, efforts or working conditions associated with a job.

We offer our employees a robust compensation package! Our comprehensive benefits include: medical, dental and vision insurance coverage; 100% company-paid life and disability coverage, 401k options with company match, three weeks PTO by the end of the first year and much more. Allied proudly promotes from within as part of a strong commitment to providing career growth opportunities for employees of all levels. Our diverse business portfolio allows employees broad career options with the advantage of staying with the same organization.

All qualified candidate will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law.

Keywords: Allied Solutions, Carmel , ETL Developer, IT / Software / Systems , Carmel, Indiana