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. 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.

Requirements

Must-haves

Position: ETL Analyst
Location: Tumwater, WA
ClienDirect Client
Duration: 3+ Months
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.
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
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.

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sql

Platform: smartrecruiters
Effort: medium