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.