Lead Oracle Developer

The Department of Information Services at SUNY Downstate Health Sciences University is seeking a full-time Lead Programmer Analyst / Lead Oracle Developer.

The successful candidate will serve as a Lead Programmer Analyst for Oracle Cloud applications (ERP, SCM, HCM) in supporting and developing integrations between Oracle Cloud applications (ERP, SCM, HCM) and on-premise, third-party systems using Oracle Integration Cloud (OIC) and supports Oracle data and reports.

• Design and development of Oracle integrations on OIC using file based/REST/SOAP adapters.
• Develop and deliver Oracle Integration Cloud based integrations with Oracle SaaS and 3rd Party applications.
• Design and develop Webservices/APIs for cloud, on premises, and hybrid solutions using Oracle Integration Cloud (OIC).
• Design, develop, unit testing, performance tuning and implementation of real time and batch integration.
• Expertise in building, error handling, auditing, scheduling, deployment, monitoring/alert integrations in OIC/ICS, and support end to end testing of integrations.
• Thorough knowledge of Mapping, Lookups, Connections, XSLT, Agents, Packages, and other features of OIC.
• Conceptualize technical design options, identify the best option, and complete the technical design specifications.
• Design and build reports leveraging Oracle OTBI, BI Publisher, Tableau and Fusion Analytic Warehouse.
• In depth knowledge about Oracle Cloud ERP schema and writing SQL queries, Data Modeling and Data Engineering.
• Expertise in creating BI Publisher & OTBI reports and using the RTF templates
• Support day-to-day Oracle application operations, including help desk issues and end user support.
• Meets with stakeholders, documents requirements, user stories, and related artifacts to determine technical specifications
• Adheres to all security, change management and application management lifecycle policies
• Supports systems maintenance, upgrades, enhancements, and integrations with other major systems.
• Understands multiple application platforms and collaborates with other teams to maintain operations.
• Maintains a current knowledge of relevant technologies as assigned.

Required Qualifications

• Bachelor’s degree in computer science, or related field combined with at least five years’ experience in the Software field with experience designing, developing, and testing of software applications
• 3+ years of experience working with Oracle SaaS modules and hands-on development and administration experience with Oracle Integration Cloud (OIC)
• 3+ years of experience with REST API, SOAP, FBDI, PL/SQL, and the use of Oracle Cloud-delivered Web Services.
• 2+ years of experience with developing integration using Oracle OIC
• End-to-end Oracle Integration Cloud (OIC) implementation experience with at least 1 end-to-end Oracle SaaS/PaaS/IaaS implementation project
• Experienced with interfacing between Oracle Cloud or ERP and 3rd party systems
• Experienced working with Oracle Cloud Infrastructure (OCI)
• Experience with Python and C# programming languages and or mobile app development.
• Ability to leverage pre-built integrations, cloud adapters, connections, SaaS applications, etc. in the solution
• Hands-on development experience with Oracle Database Cloud services (DBCS) and Managed File Transfer (MFT)
• Experience with all phases of the software development lifecycle (requirement, design, development, testing, deployment, support).
• Strong analytical and communication skills.
• Or, an acceptable equivalent combination of education, experience and training to the above.

Preferred Qualifications

• Experienced with Oracle Cloud ERP, SCM and HCM.
• REST API and SOAP. Oracle OIC, OTBI Tableau and BI Publisher.
• Oracle PL/SQL and SQL Server Stored Procedures,
• SQL Server Integration Services (SSIS).
• Programming language Python and C#
• Experience with implementation of Artificial Intelligence (AI).
• Experienced in Hospital or healthcare environment.