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.