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.
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
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
Familiarity with the data vault methodology