Next Generation VT · 3 weeks ago
Senior Oracle Payroll Integrations Developer
Next Generation, Inc. is seeking a seasoned Senior Oracle Payroll Integrations Developer to design, build, and maintain robust integrations across a payroll ecosystem. The role involves ensuring data accuracy and compliance while collaborating with cross-functional teams and mentoring junior developers.
Education Management
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
Qualification
Required
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)
Benefits
Paid time off
Medical insurance
Dental plan
Vision plan
Life insurance
Short-Term / Long-Term Disability (STD/LTD)
Paid holidays