ETL Developer with SSIS ( Healthcare Domain) -W2 only

Hexplora; Rocky Hill (CT); On-site; USD 80,000 - 100,000; Full time

Job summary

Hexplora is seeking an ETL Developer specializing in the healthcare domain to work in Rocky Hill, Connecticut. The role requires strong SQL programming skills and experience with SSIS, ETL processes, and Data Modeling. You'll be responsible for developing and documenting ETL processes, optimizing SQL statements, and coordinating data migrations. A bachelor's degree in a relevant field is mandatory. This position operates on a W2 basis and offers a supportive work environment that values diversity.

Qualifications

• Strong SQL programming skills a must.
• Experience in Healthcare Domain essential.
• Hands-on experience with SSIS required.
• Proven experience in ETL processes with EDW necessary.
• Bachelor's degree in a related field is mandatory.
• Knowledge of Data Modeling and Database Design expected.

Responsibilities

• Coordinate and develop ETL processes including making table structures.
• Develop SQL programming to facilitate data exchanges.
• Document steps for migrating database objects across environments.
• Optimize complex SQL statements.
• Build and maintain all objects, packages, and functions.
• Experience with Data Conversion is preferred.

Skills

SQL programming skills

Healthcare Domain experience

Experience with SSIS

ETL with EDW experience

Data Modeling

Database Design

Predictive Modeling

Education

Bachelor’s degree in computer engineering, sciences or related

Tools

SQL Server

SSIS

SSRS

SSAS

Job description

Overview

Title : ETL Developer with SSIS ( Healthcare Domain) -W2 only

Location: Rocky Hill, CT

Work Hours: 11am - 8pm EST

Responsibilities

• Coordinate, plan, develop and support ETL processes including architecting table structure, building ETL process, documentation.
• Development of ETL processes and SQL programming to facilitate data exchanges.
• Document steps needed to migrate database objects between various environments including Development, UAT, Staging, and Production.
• Strong proficiency with SQL and its variation among popular databases.
• Skilled at optimizing large, complicated SQL statements.
• Build, maintain, and enhance all objects, packages, and functions.
• Data Conversion experience is preferred.
• Prefer experience with SQL Server, SSIS, SSRS and SSAS.

Required Skills

• Must have strong SQL programming skills.
• Healthcare Domain experience.
• Must have hands-on experience working with SSIS.
• Must have proven experience in ETL with EDW.
• Must have at least a bachelor’s degree in computer engineering, sciences or related.
• Knowledge on Data Modeling, Database Design, EDW Concepts, Predictive Modeling and Healthcare.

Infowave Systems is an equal opportunity employer that is committed to diversity and inclusion in the workplace.