Senior Oracle Payroll Integrations Developer

Next Generation Inc.; California (MO); On-site; USD 130,000 - 150,000; Full time

Benefits offered by this job

Paid time off

Medical insurance

Dental plan

Vision plan

Life insurance

Short-Term / Long-Term Disability

Paid holidays

Job summary

A technology solutions company is seeking an experienced Senior Oracle Payroll Integrations Developer to design and maintain integrations across the payroll ecosystem. In this remote role, you will ensure data accuracy and compliance while collaborating with cross-functional teams. Ideal candidates have extensive experience in Oracle Payroll, excellent coding skills in PL/SQL and SQL, and a strong understanding of payroll compliance and integrations. A competitive salary range of $130,000-$150,000 USD is offered based on experience.

Qualifications

• 7–10+ years of hands-on experience building Oracle Payroll integrations.
• Deep practical knowledge of Oracle Payroll data structures.
• Advanced PL/SQL/SQL skills with strong experience in HCM Extracts.
• Experience using REST/SOAP APIs and secure integration patterns.
• Solid understanding of payroll compliance and financial controls.

Responsibilities

• Design, implement, and maintain payroll integrations.
• Query and analyze Oracle Payroll underlying tables/schemas.
• Write high-quality, performant code for data transformations.
• Build/maintain interfaces using HCM Extracts and middleware.
• Implement and manage authentication and connectivity.

Skills

Oracle Payroll integrations

PL/SQL

SQL

JavaScript

Python

REST/SOAP APIs

CI/CD

automated testing

data privacy/PII

Tools

HCM Extracts

Oracle Integration Cloud

Splunk

ELK

MuleSoft

Boomi

Job description

Job Summary

Next Generation, Inc., an Equal Opportunity Employer, is seeking a seasoned Senior Oracle Payroll Integrations Developer to design, build, and maintain robust integrations across a payroll ecosystem. You’ll be responsible for payroll data flows, while ensuring data accuracy, compliance, and performance. The ideal candidate is very well‑versed in Oracle Payroll’s data model (including the underlying payroll tables/schemas), and excels at writing clean, scalable code for complex transformations and high‑volume transactions. This is a remote position with collaboration across cross‑functional teams in multiple time zones, and may include client site visits.

Job Responsibilities

• Integration Ownership: Design, implement, and maintain payroll integrations between Oracle (HCM Cloud/EBS) and internal/external systems (HRIS, benefits, finance, time & attendance, tax filing, banking).
• Data Model Mastery: Query, analyze, and optimize against Oracle Payroll underlying tables/schemas (e.g., PAY* / PY* table families and related metadata), ensuring referential integrity and auditability across payroll runs, costing, balances, and retro adjustments.
• Code Development: Write high-quality, performant code (PL/SQL, SQL, Java/JavaScript or Python for middleware utilities) to support transformations, validations, file generation/ingestion, and API orchestration.
• Oracle Tooling: Build/maintain interfaces using HCM Extracts, HDL (HCM Data Loader), Fast Formulas (Payroll/Comp/Absence), BI Publisher, and OIC (Oracle Integration Cloud) or equivalent middleware (MuleSoft, Boomi, etc.).
• APIs & Connectivity: Implement REST/SOAP services, SFTP/file-based integrations, webhooks, and event-driven pipelines; manage authentication, secrets, and connectivity (OAuth 2.0, certificates, keys).
• Performance & Scaling: Tune queries and jobs for high‑volume payroll cycles, optimize partitioning/indexing strategies, batch windows, and error-handling/retry logic.
• Quality & Compliance: Establish automated testing (unit/integration), reconcile outputs against payroll results and general ledger postings; enforce SOX/ISO controls, segregation of duties, and PII protection.
• Observability: Instrument integrations with logging, metrics, and alerts (e.g., Splunk, ELK, OCI Monitoring); create dashboards for SLA tracking and payroll cut‑off readiness.
• Documentation & Standards: Author technical specs, sequence diagrams, data dictionaries/mappings, and runbooks; promote coding standards and CI/CD best practices.
• Mentorship & Collaboration: Partner with Payroll Ops, HRIS, Finance, and Security; mentor junior developers and participate in code reviews and design sessions.

Job Requirements

• 7–10+ years of hands-on experience building Oracle Payroll integrations in enterprise environments.
• Deep practical knowledge of Oracle Payroll data structures, including payroll results, costing, balances, elements, run actions, retro, and year‑end reporting, and proficiency querying the underlying payroll tables/schemas (PAY*/PY*).
• Advanced PL/SQL/SQL (packages, procedures, functions, bulk operations, performance tuning) and strong experience with HCM Extracts, HDL, Fast Formulas, and BI Publisher.
• Proven delivery using OIC or comparable middleware, plus REST/SOAP APIs, SFTP/file pipelines, and secure integration patterns.
• Experience with CI/CD (Git, build pipelines), automated testing, and secure secrets management.
• Strong understanding of payroll compliance (tax, garnishments, retro, audits), data privacy/PII, and financial controls.
• Excellent communication skills; ability to operate in a remote, distributed team and meet tight payroll calendars.
• Background integrating with banking, tax filing, GL/ERP, and benefits carriers.
• Knowledge of GDPR and global payroll nuances (multi‑country).

Job Benefits

• Paid time off
• Medical insurance
• Dental plan
• Vision plan
• Life insurance
• Short-Term / Long-Term Disability (STD/LTD)
• Paid holidays
• Competitive FTE salary range of $130,000-$150,000 USD based on experience, education, and location