PLSQL Developer

• Health plan knowledge with emphasis on claims operations financial reconciliation provider networks claims management systems data hubs and data governance.
• Experience with ETL processes using data hubs and Operational Data Store (ODS) JSON CSV and EDI transaction standards.

Good to have skills:

• 4 years of experience with Oracle SQL PL/SQL packages triggers and views for programming development and production support.
• Experience with production operations support working multiple parallel projects.
• Bachelors Degree in Information Systems Business Administration Engineering Health Information Technology or related field of study.

Responsibilities:

Summary:

• Formulates and defines system scope and objectives based on user needs.
• Devises or modifies procedures to solve complex problems considering computer equipment capacity and limitations operating time and form of desired results.
• Prepares detailed specifications from which programs will be written.
• Analyzes and revises existing system logic difficulties and documentation as necessary.
• Competent to work at the highest technical level of all phases of applications systems analysis activities.

Ideal Candidate:

• The Senior Developer will be responsible for Java based integrations using Oracle PL/SQL to extract data from backend transactional systems.
• This role will be accountable for break/fix operational support as well as new development & enhancements with limited supervision.
• The developer will be handle all phases of the software lifecycle with an emphasis on Java & SQL design development & performance tuning.

Responsibilities:

• Provides advanced support for definition/refinement of business requirements and for quality assurance/acceptance testing efforts
• Designs develops tests and debugs software components of moderate to high complexity
• Provides implementation production and upgrade support for software components of moderate to high complexity
• May act as supporting liaison between the application team and the user community responsible for facilitating communications coordinating system enhancements and providing production support. Works with user community to define business requirements in sufficient detail and define business use cases that systems configuration development/enhancement and/or Operations activities can be pursued.
• Manages the development of user and technical documentation according to department standards.

PL/SQL,ETL,triggers,Oracle,SQL