Previous Job
Previous
ETL Developer
Ref No.: 18-52530
Location: Chicago, Illinois
Position Type:Direct Placement
Start Date: 07/25/2018
Sr ETL Developer
Chicago, IL
Fulltime Permanent


Mandatory Technical Skills:
Bachelors degree or equivalent degree.
Minimum 6 to 8 years of experience in ETL using MSBI, SSIS, for mid to large BI projects.
Must have minimum 6 years of experience working with SQL Server & Client.
Must have minimum 6 years of experience in ETL performance tuninging, database query tuning.
Must have excellent understanding of Data Warehouse concepts.
Must have experience working with dimensional modeling, aggregate tables, transnational source systems.
Must have minimum 6 years of experience loading dimensional model using SSIS.
Good to have Dimensional Modelling, Star Schema, SCD, Facts, Dimensions etc.
Good to have understanding & experience working on SSAS (cubes).
Effective participant in discussion, Excellent analytical skills, requirement analysis as required.
Quick problem solver, attention to details required.
Ability to work independently and in a team environment effectively with minimum supervision.
Should be Proficient with on time delivery.
Ability to convey issues/solutions to the client based on nature of issue and provide workaround in a timely manner.
Proactively contribute to add value to the project.

Responsibilities:
Handle and support multiple application as required.
Work closely with Coverage team and Support releases.
Work on small CR related to bug Fix & provide estimations.
Create necessary doc such as source to Target mapping documents for Change Requests.
Creation Unit, integration and User test cases for CR related work.
Creation of documentstion both functional and technical.
Handle ETL Mappings/packages using SSIS, loading data to target as per requirements.
Ability to convey issues/solutions to the client based on nature of issue and provide workaround in a timely manner.
Writing Database SQL scripts and work on performance tuning both DB and ETL.
Participation in status meetings.