Software Engineer - Oracle Integration

Mayo Clinic•Rochester, MN

1d•Hybrid

About The Position

This is a hybrid position and must be located within 100 miles of a Mayo Clinic campus for occasional on-site expectations based on business needs. The Administrative Integration Services Unit is seeking a Software Engineer to develop and support Human Capital Management (HCM) integrations for Mayo Clinic’s Oracle Enterprise Resource Planning (ERP) System. This role will focus primarily on Oracle Integration Cloud (OIC) and Fast Formula development supporting Core HR, Benefits, Talent Acquisition, and Payroll. The Software Engineer will design, develop, implement, and support secure, reliable, and scalable integrations between Oracle HCM Cloud and internal applications, external vendors, APIs, databases, and other enterprise platforms. Responsibilities include developing OIC integrations, orchestrations, mappings, transformations, connections, and error-handling processes, as well as Oracle HCM Fast Formulas and related integration components. Works closely with Product Managers, Architects, functional teams, vendors, and business stakeholders to translate requirements into effective technical solutions. Develops and supports integrations using technologies such as REST and SOAP APIs, HCM Extracts, HDL/HSDL, SFTP, JSON, XML, and other Oracle HCM integration capabilities. Participates in the full software development lifecycle, including requirements analysis, design, development, testing, deployment, monitoring, troubleshooting, and production support. Applies integration standards and DevOps practices to create solutions that are secure, reusable, maintainable, and resilient. Supports CI/CD and deployment automation using tools such as Azure DevOps (ADO) and Azure Pipelines. Performs troubleshooting and root cause analysis of integration and application issues using OIC monitoring, logs, payloads, and other diagnostic tools. Ensures appropriate technical documentation is created and maintained and that solutions comply with organizational security, privacy, and data protection requirements. Communicates effectively with technical and business partners across the organization and continues to build knowledge of Oracle HCM, OIC, enterprise integration patterns, organizational processes, and customers. Participation in a 24/7 on-call rotation is required.

Requirements

Bachelor's degree in computer science/engineering or related field; or an associate’s degree in computer science/engineering or related field with an additional 2 years of experience.
Working knowledge and experience of Software Engineering with a minimum of internships and a minimum of 1 yr. of experience, or 2yrs of experience coding applications or services in a high-level language (C, C++, Golang, Java, C# etc.).
Demonstrated problem solving and time management skills.
Strong technical aptitude for designing and implementing software solutions.
Experience with modern application development frameworks.
Knowledge of professional software engineering practices & best practices for the full software development life cycle, including coding standards, code reviews, source control management, build processes, testing, and operations.
Deep hands-on technical expertise.
Excellent verbal and written communication skills.
Experience with Agile software development techniques.
High level of analytical skill.
Ability to manage varied workload on projects.
Proactiveness.
Willing and capable of adapting to shifting requirements.
Authorization to work and remain in the United States, without necessity for Mayo Clinic sponsorships now, or in the future (for example, be a U.S. Citizen, national, or permanent resident, refugee, or asylee).
Mayo Clinic does not participate in the F-1 STEM OPT extension program.
Oracle Fusion Cloud Platforms - Required
Oracle Integration Cloud (OIC) - Required
Oracle HCM Data Loader (HDL)
Oracle HCM Extracts
Oracle Business Intelligence Publisher (BIP)
Oracle File-Based Data Import (FBDI)
Oracle Web Services (SOAP/REST)
Oracle SQL – PL/SQL

Nice To Haves

Experience writing and supporting complex database queries is highly valued.
Ability to use a wide variety of open-source technologies and cloud-based services.
Experience with Google and Azure cloud environments
Experience in databases, analytics, big data systems or business intelligence products
Experience with building high-performance, highly available and scalable distributed systems.
Experience developing software for healthcare related industries.
Oracle Fusion HCM Fast Formulas – Preferred
Oracle Application Integration Professional Certification
Oracle Cloud Certification
Agile Methodologies
ServiceNow
Splunk
Cleo Harmony (MFT)
Google Apigee

Responsibilities

Develop and support Human Capital Management (HCM) integrations for Mayo Clinic’s Oracle Enterprise Resource Planning (ERP) System.
Focus primarily on Oracle Integration Cloud (OIC) and Fast Formula development supporting Core HR, Benefits, Talent Acquisition, and Payroll.
Design, develop, implement, and support secure, reliable, and scalable integrations between Oracle HCM Cloud and internal applications, external vendors, APIs, databases, and other enterprise platforms.
Develop OIC integrations, orchestrations, mappings, transformations, connections, and error-handling processes.
Develop Oracle HCM Fast Formulas and related integration components.
Translate requirements into effective technical solutions in collaboration with Product Managers, Architects, functional teams, vendors, and business stakeholders.
Develop and support integrations using technologies such as REST and SOAP APIs, HCM Extracts, HDL/HSDL, SFTP, JSON, XML, and other Oracle HCM integration capabilities.
Participate in the full software development lifecycle, including requirements analysis, design, development, testing, deployment, monitoring, troubleshooting, and production support.
Apply integration standards and DevOps practices to create solutions that are secure, reusable, maintainable, and resilient.
Support CI/CD and deployment automation using tools such as Azure DevOps (ADO) and Azure Pipelines.
Perform troubleshooting and root cause analysis of integration and application issues using OIC monitoring, logs, payloads, and other diagnostic tools.
Ensure appropriate technical documentation is created and maintained.
Ensure solutions comply with organizational security, privacy, and data protection requirements.
Communicate effectively with technical and business partners across the organization.
Continue to build knowledge of Oracle HCM, OIC, enterprise integration patterns, organizational processes, and customers.
Participate in a 24/7 on-call rotation.