SQL/ETL Engineer Chicago, IL (Day 1 Onsite) Full Time/Contract

[USA LaoTu Support Team]

Greetings !

I am reaching out to you on an exciting job opportunity with one of our clients.

SQL/ETL Engineer

Chicago, IL (Day 1 Onsite)

Full Time/Contract

Responsibilities:

Documents all technical and system specifications documents for all ETL processes and perform unit tests on all processes and prepare required programs and scripts.
Analyze and interpret all complex data on all target systems and analyze and provide resolutions to all data issues and coordinate with data analyst to validate all requirements, perform interviews with all users and developers.
Perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications.
Develop all data warehouse models and prepare reports for all meta data integration into systems and draft all ETL scripts and prepare required reports for all end users.
Collaborate with all developers and business users to gather required data and execute all ETL programs and scripts on systems and implement all data warehouse activities and prepare reports for same.
Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases and provide support to all ETL applications.
Develop and perform tests on all ETL codes for system data and analyze all data and design all data mapping techniques for all data models in systems.
Provide support to all ETL schedules and maintain compliance to same and develop and maintain various standards to perform ETL codes and maintain an effective project life cycle on all ETL processes.
Document all test procedures for systems and processes and coordinate with business analysts and users to resolve all requirement issues and maintain quality for same.
Monitor all business requirements and validate all designs and schedule all ETL processes and prepare documents for all data flow diagrams Skills
Good Data Analysis skills
Extensive knowledge and experience of SQL (preferably SQL Server)
Knowledge of Data warehousing concepts, Ralph and Inman models
Excellent communication skills.
Ability to troubleshoot and solve complex technical issues
Relational databases (SQL Server)
ETL tool sets, such as SSIS
Modeling tools such as Toad Data Modeler, Erwin and Embarcadero
.Net languages and Business Objects BI
Qualifications, knowledge, and experience

A bachelor's degree - BS Computer Science preferable or Administrator qualification
Prior experience implementing ETL with tools – 3-5 years.
Prior Experience Data modeling – 2-3 years
 If you are interested, please send me a copy of your resume in along with the following details to discuss this role

Full Name ( As per SSN):

LinkedIn url

Contact#:

Primary E-mail ID:

Current location:

VISA Status:

How soon you can join:

Willing to Relocate [Y/N]:

Expected Salary :-

Skype ID [For webcam interview ]:

Thanks and Regards

Gaurav Srivastava

Technical Recruiter

Jconnect Infotech Inc.

Ph# 856-283-2251 |Email: Gaurav.p@jconnectinc.com

168 Barclay Center Ste. 347, Cherry Hill, NJ 08034