Datawarehouse/ETL Analyst

Infojini Consulting is a full service IT consulting, services, and staffing firm with offices in Edison, NJ.

Infojini Consulting is recognized as one of the fastest growing IT services and software development Companies. With a partnership of all major technology vendors, Infojini Consulting has built a strong Government and commercial customer base including fortune 100 companies and most state and federal agencies such as State of North Carolina, State of South Carolina, State of Maryland, State of California, State of Pennsylvania, State of Virginia, State of Washington and many others.

Infojini Consulting is an equal opportunity employer and considers all qualified individuals for employment irrespective of their race, gender, age, color, sexual orientation. We offer an excellent compensation package

Position: ETL Analyst 

Location: Tumwater, WA

ClienDirect Client

Duration: 3+ Months

Duties:

• Participate in project team meetings and work closely with the data warehouse administrator, ETL staff, data modelers, database administrators, support analysts, report writers, and the data warehouse project manager to create ETL routines. Creating ETL routines includes writing the code that creates the transformations and processes that move data from the specified sources, transform it as required and write it into the data mart. Client requirements and database design specifications will be provided by WSDOT staff.

• Test target data structures to ensure that all works as designed.

• Verify identified data sources to ensure that the needed data can be properly provided.

• Write technical documentation of ETL routines to explain how the routines operate to meet requirements and design specifications.

• Provide technical assistance to write complex data-mart queries, based on the detailed knowledge gained during the construction of ETL routines.

• Assist in troubleshooting data loading and data warehouse performance issues.

Required Skills:

• Minimum 5 years of experience in creating and maintaining Extract, Transform, and Load (ETL) processes using SQL Server Integration Services (SSIS) and / or Informatica Power Center.

• Minimum 5 years of experience writing complex queries using Transact SQL for reporting and data validation purposes

• Minimum 5 years of experience using Microsoft SQL Server 2000, 2005, and 2008 r2 software tools to administer and/or manage SQL Server databases.

• Minimum 5 years of experience working with large organizations (over 1000 employees).

• Minimum 5 years of experience employing data warehouse principles and theories, including knowledge of the various tactical approaches to data warehouse development

Desired Skils:

• Understanding of database modeling and design principles and ability to use a data model diagram.

• Experience using PowerExchange for Mainframe ADABAS.

• Tuning and optimizing SQL Server databases.

• Performing mainframe-to-server automation, bulk copy and FTP download.

• Programming in .Net. Or COBOL and/or Natural running on an MVS/zOS platform.

All your information will be kept confidential according to EEO guidelines.