Job Description :
PL/SQL ETL Specialist
Albany, NY
9 Months
Job Description:
The New York Patient Occurrence Reporting and Tracking System (NYPORTS) is an adverse event reporting system implemented pursuant to New York State Public Health Law section 2805-l, Incident Reporting. An occurrence is an unintended adverse and undesirable development in an individual patient’s condition occurring in a hospital. This system is used by hospitals and clinics to meet their statutory reporting requirements.
The project encompasses three phases of effort to restructure and enhance an application to support the business requirements for the NYPORTS system. The first phase restructured and migrated the NYPORTS application to a supportable IT infrastructure in August 2015. A second phase included a redesign of the system to align with national standards established by the federal Department of Health and Human Services through its Agency for Healthcare Policy and Research (AHRQ), an effort to identify and define more complete NYPORTS business requirements, enhancement of the application to provide this functionality, and the addition of the capability to review the adverse events captured by the system. The third phase will address business requirements identified during the system redesign and the business needs analysis. These requirements include new reports, the ability to generate and print reports, extract capabilities for research and data sharing, and the ability to send and receive adverse event referrals. The ability of the Department to perform data analysis, share extracts with researchers and disseminate findings is a statutory requirement.
The Specialist will be responsible for, but not limited to, the analysis and design of database objects and data collection systems, including the transformation of legislative requirements into system functionality; data modelling; responsible for software development tasks including coding, testing, and implementation; prepares technical and user documentation.
Candidates should have at least 84 months experience and a majority of the following should apply:
Each candidate should fill out the months of experience they have for each item in the table:
1. 84 Months?Experience developing Oracle PL/SQL using advanced PL/SQL programming techniques. #OF MONTHS 25
2. 84 Months?Experience using Oracle development tools such as SQL Plus, SQL Developer, and SQL Loader for programming and maintaining applications. #OF MONTHS 20
3. 84 48 Months?Experience designing and implementing logical and physical database models, including indexes, primary keys, foreign keys, and constraints. #OF MONTHS 15
4. 48 months?Experience performing Extract, Transform, and Load (ETL) techniques. #OF MONTHS 10
5. 24 months?Experience optimizing, performance tuning, and debugging PL/SQL. #OF MONTHS 10