Senior Oracle Payroll Integrations Developer

Jobgether; United States; Remote; USD 130,000 - 150,000; Full time

Benefits offered by this job

Salary range $130k-$150k

Remote work from US

Full-time

PTO

Health insurance

Dental

Vision

Life insurance

Disability insurance

Paid holidays

Job summary

Jobgether seeks an experienced Oracle payroll integrations engineer to design, implement, and maintain end-to-end interfaces between Oracle HCM/Oracle EBS and HRIS, payroll, and finance systems. The role emphasizes data integrity, secure transfers, and scalable middleware using OIC, HDL, BI Publisher, and REST/SOAP APIs.

You will collaborate with Payroll Ops, HRIS, Finance, and Security teams, mentor junior developers, and ensure compliance with SOX, GDPR, and data privacy while meeting strict

Qualifications

• 7–10+ years of hands-on experience designing, developing, and maintaining Oracle Payroll integrations in enterprise environments.
• Strong knowledge of Oracle Payroll data structures, including PAY* and PY* schemas, with data accuracy and auditability.
• Advanced SQL/PL/SQL skills, including performance tuning and bulk operations.
• Experience with Oracle HCM Extracts, HDL, BI Publisher, and middleware like OIC, MuleSoft, or Boomi.
• Proven ability to implement secure integrations with REST/SOAP APIs, SFTP, and file-based transfers.
• Familiarity with CI/CD pipelines, version control, and automated testing.
• Understanding of payroll compliance, SOX, GDPR, and data privacy.

Responsibilities

• Design, develop, implement, and maintain payroll integrations between Oracle HCM Cloud/EBS and internal/external systems.
• Analyze and optimize Oracle Payroll data structures to ensure data accuracy and auditability.
• Develop high-performance code in SQL/PL/SQL and possibly Java/Python/JS for data transformations and API orchestration.
• Build payroll interfaces using HDL, OIC, and middleware like MuleSoft or Boomi.
• Implement secure APIs, SFTP pipelines, and event-driven data pipelines with OAuth 2.0 and encryption keys.
• Optimize queries, batch processing, and data handling to support high-volume payroll cycles.
• Implement error-handling, reconciliation, and monitoring for reliable data processing.
• Establish automated testing, reconcile outputs with payroll results and GL postings.
• Enforce security and privacy controls (PII, segregation of duties) and SOX compliance.
• Maintain observability with logs, metrics, alerts, and dashboards (Splunk/ELK/OCI Monitoring).
• Produce technical specs, data dictionaries, and runbooks; promote coding standards and CI/CD.

Skills

Oracle HCM/Payroll

SQL/PLSQL

REST APIs

SOAP APIs

OIC/Middleware

HDL/BI Publisher

CI/CD

Security & Compliance

Data reconciliation

Multi-system integrations

Java/Python/JS

Tools

Oracle HCM Cloud

Oracle EBS

HDL

BI Publisher

OIC

MuleSoft

Boomi

Splunk/ELK

OCI Monitoring

Job description

Accountabilities:

- Design, develop, implement, and maintain payroll integrations between Oracle HCM Cloud or Oracle E-Business Suite (EBS) and internal or external systems, including HRIS, benefits platforms, finance and ERP systems, time and attendance solutions, tax filing providers, and banking services.

- Analyze, query, and optimize Oracle Payroll data structures and underlying tables and schemas, including PAY* and PY* table families, to ensure data accuracy, referential integrity, and auditability across payroll results, costing, balances, and retroactive adjustments.

- Develop clean, scalable, and high-performance code using advanced SQL, PL/SQL, and, where appropriate, Java, JavaScript, or Python to support data transformations, validation, file processing, and API orchestration.

- Build and maintain payroll interfaces using Oracle HCM Extracts, HCM Data Loader (HDL), Fast Formulas, BI Publisher, and Oracle Integration Cloud (OIC) or comparable middleware platforms such as MuleSoft and Boomi.

- Implement and maintain REST and SOAP APIs, SFTP and file-based integrations, webhooks, and event-driven data pipelines, ensuring secure connectivity and appropriate authentication mechanisms, including OAuth 2.0, certificates, and encryption keys.

- Optimize queries, integration jobs, batch processing, and data handling strategies to support high-volume payroll cycles, meet payroll deadlines, and improve system performance and scalability.

- Implement robust error-handling, retry, reconciliation, and monitoring mechanisms to ensure reliable data processing and rapid resolution of integration failures.

- Establish automated unit and integration testing procedures, reconcile integration outputs against payroll results and general ledger postings, and maintain data quality throughout the payroll lifecycle.

- Enforce security, privacy, and compliance requirements, including segregation of duties, protection of personally identifiable information (PII), and relevant SOX and ISO controls.

- Implement observability practices through logging, metrics, alerts, and dashboards using tools such as Splunk, ELK, or OCI Monitoring to track service-level agreements (SLAs) and payroll cut-off readiness.

- Produce and maintain technical specifications, sequence diagrams, data dictionaries, mapping documents, and operational runbooks while promoting coding standards, version control, and CI/CD best practices.

- Collaborate with Payroll Operations, HRIS, Finance, Security, and other stakeholders to align integration solutions with business requirements and operational priorities.

- Mentor junior developers, participate in code reviews and technical design sessions, and contribute to continuous improvement across the integration development lifecycle.

Requirements:

- 7–10 or more years of hands-on experience designing, developing, and maintaining Oracle Payroll integrations in enterprise environments.

- Extensive practical knowledge of Oracle Payroll data structures and underlying schemas, including payroll results, costing, balances, elements, run actions, retroactive processing, and year-end reporting, with demonstrated proficiency querying PAY* and PY* table families.

- Advanced proficiency in SQL and PL/SQL, including packages, procedures, functions, bulk operations, query optimization, and performance tuning.

- Strong experience with Oracle HCM Extracts, HCM Data Loader (HDL), Fast Formulas for Payroll, Compensation, or Absence, and BI Publisher.

- Proven experience delivering integrations through Oracle Integration Cloud (OIC) or comparable middleware platforms, with a strong understanding of enterprise integration architecture.

- Demonstrated expertise in REST and SOAP APIs, secure file transfers, SFTP pipelines, and reliable data exchange between enterprise applications.

- Experience implementing secure integration patterns, authentication protocols, certificate management, and secrets management.

- Familiarity with CI/CD pipelines, Git-based version control, automated testing frameworks, and software development best practices.

- Strong understanding of payroll compliance requirements, including taxation, garnishments, retroactive adjustments, audit procedures, financial controls, and data privacy.

- Knowledge of SOX and relevant security standards, with the ability to design integrations that support auditability, access controls, and protection of sensitive employee information.

- Experience integrating payroll systems with banking platforms, tax filing providers, general ledger and ERP systems, and benefits carriers.

- Understanding of GDPR requirements and the complexities of global payroll, including multi-country payroll processes and regulatory variations, is an advantage.

- Excellent analytical, troubleshooting, and problem-solving skills, with a strong attention to detail and a commitment to data accuracy.

- Strong written and verbal communication skills, with the ability to collaborate effectively across technical and business teams in a distributed remote environment.

- Ability to manage competing priorities, work independently, and deliver reliable solutions within strict payroll processing schedules.

- Willingness to participate in occasional client-site visits when required.

Benefits:

- Competitive salary: Annual base salary ranging from $130,000 to $150,000 USD, depending on experience, education, and geographical location.

- Remote work: The flexibility to work remotely from anywhere in the United States.

- Full-time employment: An opportunity to contribute to enterprise payroll technology, integration architecture, and business-critical systems.

- Paid time off: Paid leave to support personal needs and work-life balance.

- Medical insurance: Health coverage to support employee well-being.

- Dental plan: Benefits to help cover dental care needs.

- Vision plan: Coverage for eligible vision care.

- Life insurance: Additional financial protection through life insurance benefits.

- Short-term and long-term disability insurance: Coverage designed to provide financial support in the event of a qualifying disability.

- Paid holidays: Paid time off for designated holidays.