Job Description

ETL Developer

Location:

REMOTECalifornia

Date Posted:

4/8/2021

Employment Type:

Consulting

Recruiter:

Ina Martin

Recruiter Email:

ina.martin@avidtr.com

Job ID:

JN -042021-14472

Job Description

Requirements
  • Demonstrated effective communication and interpersonal skills.
  • Demonstrated ability to communicate technical information to technical and non-technical personnel at various levels in the organization. 
  • Self-motivated and works independently and as part of a team.
  • Able to learn effectively and meet deadlines. 
  • Demonstrated complex problem- solving skills. 
  • Experience with EPIC electronic medical record databases Clarity and Caboodle 
  • Advanced knowledge of the EPIC data such as clinical and financial data and how to use these data effectively in analytics, dashboards and reporting 
  • Demonstrates the ability to design, code and test ETL routines 
  • Understands the principles of good ETL design Req 3 to 4 years writing T-SQL.
  • Experienced in writing stored procedures and complex SQL 
  • Must possess experience and skills in understanding data models and developing databases and database objects.  Experience developing and executing complex test plans.
  • Familiarity with at least one ETL tool such as SSIS or DataStage 
  • Experience with clinical and healthcare administration data 
  • Expertise in creating technical specifications 

Preferred Requirements
  • 1 to 2 years of DataStage ETL development experience.
  • Experience with Version 11.5 and above is preferable. Should be able to design and develop data extraction / integration solutions using DataStage. 
  • At least 3 to 4 years of Microsoft Integration Services (SSIS) ETL development experience 
  • Should be able to design and develop data extraction / integration solutions using Visual Studio. 
  • Must be able to work with multiple RDBMS environments (e.g. Oracle and SQL Server).
  • Able to resolve and improve performance issues. 
  • Ability to create data flow diagrams, and ETL specifications
Apply for this job