Job Description :
Please send resume at m[dot]vishwakarma[at]vegazva[dot]com


Warm greetings from Global Economic Advantage- !!
We have very urgent requirement, please find the job description below and if interested then please reply back to me with your updated resume ASAP.

Direct Client Requirement
Position : ETL Developer
Location : Chicago, IL
Duration : Long Term

Job description :

This position is responsible for developing ETL (Extraction Transformation and Loading) programs for the data warehouse projects. Reviews, evaluates, designs, implements and maintains ETL Programs. Identifies data sources, constructs data decomposition diagrams and documents the process. Develops ETL programs to load the data marts & data warehouses for reporting purposes and create extract files in a structured format for other business purposes.

Skills, Knowledge and Experience Required:
5+? years of experience in Development and Implementation of Data warehouse & BI solutions
3+? years solid hands-on database development & SQL programming experience (stored procedures, triggers) using MS SQL Server, Oracle and/or other data bases
2?+ Experience in ETL Development using Tools like Informatica, SAP Data Service (Data Integrator)
Thorough knowledge and experience in Relational? & Dimensional Data Models, OLAP, Star & Snow-flake schema and experience in developing data models using Erwin , MS-VISIO
Good Knowledge and experience of data warehouse? architecture, design principles, practices, systems development & analysis
Experience in developing Reporting? & Analytical solutions using tools like Business Objects, Cognos etc.
Good analytical, problem solving and decision making? skills
Excellent communication and interpersonal skills?
Any relevant certifications is a plus?


Analysis and Design Responsibilities
Assist in identifying entities, attributes and? relationships, define them in a complete and accurate form
Prepare technical documents to identify work flows? & data flows and source & destination mappings

Development and Implementation Responsibilities
Develop ETL (Extraction, Transformation? & Load) programs to load data marts and data warehouses.
Create database objects, normalize tables as needed.? Maintain the database referential integrity
Create accurate mapping from source to destination and? ensure the data is accurately transferred.
Implement the business logic by developing proper data? transformations inside the work & data flows
Follow SDLC (System Development Life Cycle ?

Testing & Quality Assurance Responsibilities
Perform unit, system, integration and regression tests.? Document test results and make recommendations
Validate the data thoroughly for its accuracy against the? source system or other standard system reports

Administration and Maintenance Responsibilities
Monitor the production jobs and make sure they are? completed on-time
Perform audits regularly in accordance with company? policies and correct the audit findings

Teamwork/Collaboration Responsibilities
Understand project plans and clearly articulate roles,? project goals, and time line
Take input from supervisor and appropriately and accurately? apply the comments/feedback.
Establishes harmonious and effective working? relationships with team members and clients.

Academic Background:
Bachelor’s degree in computer science or related field?