This site uses cookies. To find out more, see our Cookies Policy

ETL Developer in Hauppauge, NY at CIOX Health

Date Posted: 5/14/2018

Job Snapshot

Job Description


The ETL Developer will be responsible for the efficient, compliant, timely, and secure acquisition, integration, provision, and exchange of the enterprise data between the company and our clients.

Duties & Responsibilities:

Develop ETL technical specifications and recommend, design, develop, test, implement/automate, and support innovative and optimal data solutions.

Develop and document mapping/sessions/workflows.

Create, execute, and document unit test plans for ETL and data integration processes and programs.

Design and develop solutions to meet business requirements.

Deploy cutting-edge technology solutions.

Design and implement the data loading (ETL) and publishing processes within the DW/BI environment.

Create reporting specifications, including report creation, data validation, and report validation.

Data Warehouse and ETL development.

Job Requirements


Bachelors Degree in Computer Science/Information Systems with 2+ years of experience or equivalent work experience (i.e. ETL/Data Integration Specialist with 3-5 years of experience in an enterprise business environment).

Exposure to MS SQL 2008 R2/2012+ with T-SQL experience.

Experience working with high volume data exchange and integrating large structured and unstructured data in multiple formats, character sets, and delivery methods.

Experience with ETL tools (Business Objects), data warehouse development, SDLC experience and subversion code version control.

Ability to work independently, possess strong problem-solving skills and have a willingness to work with new technologies.

Data Modeling.

SSRS Exposure.

Exposure to design and implementation of ETL processes, data modeling and SSRS as well as exposure to OLAP/MOLAP technologies and dimensional modeling a plus.

Good communication skills, efficient time management and organization skills, ability to handle multiple tasks and work well in a team environment.