ETL Consultant

Login to Apply

Job Description

Full time / Perm

Must be onsite at Rocky Hill CT

Open for H1B Transfer

Responsibilities:

ETL Developer is responsible for the design and development of Data Systems solutions;

Design and develop ETL solutions/procedures to acquire, harmonize, and consolidate various data assets/sources;

Create process for automation and enhancement of data quality.

Required Skills:

Three (3) years’ experience in data systems, ETL, data structures, and reporting tools and environments.

An understanding of healthcare systems and healthcare databases.

7 years’ experience performing data systems development, modification, and support.

7 years with SQL Server, SSIS, ETL, SQL,

Must have hands on experience in

• Logical, rational, dimensional, and physical data modeling.

• Code development, testing for QA, and data profiling.

• Perform SQL queries tuning activities.

• Normalized, dimensional, star schema and snow flake schematic models.

• Developing and optimizing T-SQL (DDL, DML, DCL) queries, stored procedures, functions, and views for various applications

• Software engineering practices and best practices for the full SDLC, including coding standards, code reviews, source control management, build processes, testing, and operations.

• Strong technical documentation skills.