Senior ETL & Data Warehouse 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

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.