Datawarehouse/ETL Analyst

Infojini Inc; Tumwater (WA); On-site; USD 100,000 - 120,000; Full time

Benefits offered by this job

Excellent compensation package

Job summary

A prominent IT consulting firm located in Washington is seeking an experienced ETL Analyst to create and maintain ETL processes. This role requires a minimum of 5 years of experience with SQL Server Integration Services (SSIS) and the ability to write complex SQL queries. The ETL Analyst will collaborate with various teams to develop data routines and ensure data integrity within the data warehouse systems. Strong technical skills and a background in large organizations are essential for this position.

Qualifications

• Minimum 5 years of experience in ETL processes.
• Experience with SQL Server and complex queries.
• Knowledge of data warehouse development principles.

Responsibilities

• Create ETL routines and write necessary code.
• Test target data structures for proper functionality.
• Verify data sources and ensure data accuracy.

Skills

Creating and maintaining ETL processes using SSIS

Writing complex queries using Transact SQL

Administering SQL Server databases

Employing data warehouse principles

Tools

SQL Server Integration Services

Informatica Power Center

Microsoft SQL Server 2000, 2005, 2008 r2

Job description

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

Job Description

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.

Qualifications

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.

Additional Information

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