ETL Data Developer

Vidant Duplin Hospital   •  

Greenville, NC

Industry: Patient Care


Less than 5 years

Posted 353 days ago

Position Summary

The ETL Developer position is responsible for the integration of enterprise data by developing, testing and implementing packages and programs using Microsoft’s SSIS and/or Informatica’s Power Center.  In addition, this position is responsible for building, maintaining reference tables, master data domains and data extracts that are needed to ensure the efficient and accurate processing of information within Vidant Health.

Typical tasks will include, but are not limited to: requirements gathering, analysis, software architecture and design, software development, testing, implementation and documentation.


  • Analyzes, designs, build, test, and implement integration technology solutions that meet the specifications of a project or service request.

  • Effectively utilizes standard enterprise tools to develop or implement technical solutions.

  • Writes test cases and report results

  • Identifies problems following problem management expectations and performs problem resolution.

  • Resolve most reported issues independently or escalates as needed to senior engineers.

  • Provides preventative maintenance, troubleshooting and quickly resolves routine problems to ensure infrastructure and application stability.

  • Adheres to standards and best practices, processes, and deliverables in accordance with standards.

  • Participates in defining operational readiness requirements.

  • Follows testing best practices and standards.

  • Adheres to SLA expectations.

  • Writes technical specifications for respective applications or infrastructure platforms.

  • Participates in creating prototypes or proofs of concepts for new infrastructuretechnology.

  • Remains current with respective technology capabilities

  • Collaborates with Project Managers to resolve requirements gaps uncovered in design or within specifications or requirements.

  • Prepares technical documentation for platform, service or infrastructure technical components.

  • Adheres to change and incident management standards and expectations.

Minimum Requirements

  • Bachelor's degree in Information Technology or related field OR relevant work experiencerequired

  • 4+ years' experience in an ETL administration or ETL/application development environment Experience working with project teams to design and implement new solutions

  • Experience working in team-oriented, collaborative environment

  • Independently motivated to seek knowledge in areas pertaining to their current position Exhibits proficient in either SSIS or Informatica ETL tools

  • 1+ years applicable experience in the Healthcare / Health domain, with good understanding of HIPAA data Privacy and Security requirements

  • Self-educates and seeks knowledge from mentors / management of VH Information Services, and other business leaders from VH

  • 2+ years of working with dimensional modeled data Knowledge of data vault modeling techniques

  • Expert level knowledge in writing SQL code for queries, stored procedures, data cleansing and manipulation

Preferred Requirements

  • SQL Server development – T-SQL/stored procedures

  • Microsoft SSIS or Informatica Power Center ETL programming

  • 2+ years in Healthcare

  • Epic Caboodle 1+ years

  • SME on 2 or more Epic data Clarity modelsSAS administration or development experience

  • Hands on experience with the Epic Clarity supplied cubes, Excel spreadsheets, or Business Objects universes

  • Epic Clarity or Epic Data warehouse certification

Experience not required but a plus

  • Informatica Power Center

  • Informatica Analyst and or IDQ

  • Oracle SQL, PL/SQL

  • Data modeling

  • ER/Studio

  • Familiarity with the data vault methodology