W2 - Oracle Cloud HCM Integrations Developer

Job Title: Oracle Cloud HCM Integrations Developer

Location: Hybrid Wilmington, MA is preferred. 3 days onsite

Duration: 6+ Months Contract

Job Description:

Ideally someone who doesn't need to give a 2 weeks' notice. They need these people to start in like a week and a half

NEED SOMEONE HERE THAT CAN HEAVILY LEVERAGE AI and has worked with Claude. Someone that is more legacy will not work out well here.

We're looking for a hands-on integration builder, not a configurator, with 8+ years of Oracle Cloud HCM integration experience. This person will design, develop, and deploy inbound/outbound integrations using HCM Extracts, HDL/HSDL, BI Publisher, OIC, and REST/SOAP APIs as part of a broader enterprise HCM initiative.

What makes this role different from a typical Oracle HCM posting:

• We require demonstrated proficiency with the AI-assisted development tool, Claude. This is non-negotiable, we're building integrations at 2-3x traditional velocity and need someone who operates at that pace.
• The candidate must be able to write XSLT, debug HDL load errors, and build OIC orchestrations, not just talk about them.

Strong automation mindset, scripting, automated testing, self-documenting integrations

• Can the candidate name specific HCM Extracts and HDL integrations they personally built (not team projects they observed)? Ask them to describe one end-to-end.
• Can they explain the Oracle HCM data model, Person, Work Relationship, Assignment hierarchy, without hesitation?
• Have they used AI-assisted development tools (Claude, Copilot, Cursor, etc.) in their integration work? Ask for a specific example with measurable impact. "I've heard of it" is not sufficient.
• Can they write or talk through XSLT, Groovy, or SQL relevant to HCM integrations on the spot?
• Do they have hands-on OIC orchestration experience, not just connection setup, but end-to-end flows with error handling?

Role Summary:

We're looking for a hands-on integration builder, not a configurator, with 8+ years of Oracle Cloud HCM integration experience. This person will design, develop, and deploy inbound/outbound integrations using HCM Extracts, HDL/HSDL, BI Publisher, OIC, and REST/SOAP APIs as part of a broader enterprise HCM initiative.

Core Responsibilities

1. Integration Design & Architecture

• Partner with business systems analysts to translate functional requirements, data mappings, and integration use cases into scalable technical designs.
• Architect inbound and outbound integration patterns using Oracle-native and hybrid approaches, HCM Extracts, HDL/HSDL, REST/SOAP APIs, FBDI, file-based integrations, and event-driven (Business Events / webhook) patterns.
• Author comprehensive Technical Design Documents with data lineage diagrams, error-handling matrices, volumetric analysis, and SLA definitions.
• Evaluate and recommend patterns based on data volume, latency requirements, and security constraints (real-time vs. batch vs. near-real-time).
• Design for idempotency, retry logic, and graceful degradation, every integration must be resilient by default.

2. Integration Development & Build

• Develop HCM Extracts (BIP-based and fast formula driven) with optimized SQL and delivery configurations.
• Configure BI Publisher templates for outbound file generation, CSV, XML, fixed-width, with dynamic parameter-driven formatting.
• Build inbound data loads using HDL/HSDL with pre-validation logic, transformation layers, and automated error capture.
• Develop integration orchestrations in Oracle Integration Cloud (OIC) Gen 2/3 or equivalent middleware, connections, mapping, error handling, and scheduling.
• Implement robust transformation and validation logic (cross-field validation, referential integrity checks, business rule enforcement) before data hits HCM, shift-left on data quality.
• Configure encryption (PGP/GPG), compression, SFTP delivery, and content-server staging with automated file-naming conventions.
• Build Business Events subscribers for real-time integration triggers (new hire, termination, job change events).

3. AI-Accelerated Development & Automation (New, Critical)

• Leverage AI-assisted coding tools (Claude Code, GitHub Copilot, or equivalent) to accelerate XSLT/XSL-FO template development, Groovy scripting in OIC, and HDL file generation, achieving 2 3 velocity without sacrificing correctness.
• Use AI to auto-generate unit test payloads, edge-case HDL files, and regression test datasets from existing data dictionaries and mapping specs.
• Apply AI for rapid TDD/runbook authoring, draft technical design documents, error-handling procedures, and handover documentation from integration specifications with human review and refinement.
• Build or adopt automated validation frameworks, AI-powered log parsers that triage HDL load errors, extract failures, and ESS job exceptions, surfacing root causes in minutes rather than hours.
• Develop self-documenting integrations, automated generation of data flow diagrams, field mapping matrices, and change-impact summaries from code/configuration artifacts.
• Create intelligent monitoring dashboards with anomaly detection for integration health, volume drift, timing anomalies, error rate spikes, not just reactive alert-and-fix.
• Automate release note generation and commit message standardization for integration deployments.

4. Testing & Quality Assurance

• Perform thorough unit testing with positive, negative, boundary, and volumetric test scenarios.
• Support SIT and UAT cycles in close coordination with HCM functional and technical teams.
• Build automated regression test suites for critical integrations, every deployment runs against a known-good baseline.
• Validate data integrity end-to-end: source system transformation HCM staging HCM tables downstream consumers.

5. Troubleshooting & Production Support

• Diagnose HDL load errors (entity-level, attribute-level, referential) using import process logs, HCM Data Loader monitoring, and UCM content inspection.
• Troubleshoot HCM Extract failures, ESS job errors, BIP template issues, delivery channel failures, data-driven exceptions.
• Support defect triage with root-cause analysis discipline, distinguish data issues from configuration issues from platform issues.
• Automate recurring triage patterns, if you're solving the same category of issue three times, build a script or runbook that eliminates it permanently.

6. Compliance, Audit & Security

• Ensure integrations meet SOX, GDPR, HIPAA, and internal audit standards, data masking, access controls, encryption at rest and in transit.
• Maintain audit trail evidence: integration run logs, data transformation records, error resolution documentation.
• Support audit evidence requests with pre-built, queryable integration audit packages, always audit-ready.
• Implement data classification awareness in integration design, PII, PHI, and sensitive compensation data must have explicit handling protocols.

7. Cutover, Hypercare & Knowledge Transfer

• Execute cutover integration runs with documented rollback procedures.
• Support hypercare-phase issue resolution with defined escalation paths and SLA-driven response.
• Provide structured knowledge transfer, recorded walkthroughs, decision trees, and operational runbooks.
• Deliver comprehensive handover documentation: architecture diagrams, operational procedures, error-handling guides, and dependency maps.

8. Cross-Functional Collaboration

• HCM Functional & Technical Consultants, requirements alignment, data model validation, configuration dependencies
• Security & Identity Teams, SSO, role-based access, encryption standards, certificate management
• Middleware / Integration Teams, OIC orchestration, API gateway policies, credential rotation
• PMO & Release Management, deployment scheduling, change management, release readiness
• Data & Analytics Teams, data warehouse feed design, OTBI/BIP reporting alignment, data lake ingestion patterns

Key Skills & Qualifications

Required

• 8+ years of hands-on Oracle Cloud HCM integrations development (not just configuration, actual build experience).
• Deep understanding of the Oracle HCM data model, person, assignment, employment, position, organization, and payroll entities and their interdependencies.
• Expert-level proficiency in HCM Extracts (BIP-based, fast formula, SQL-driven) and HDL/HSDL (all major business objects, including complex objects like Element Entries, Salary, Benefits).
• Strong OIC Gen 2/3 or equivalent middleware experience, connections, orchestrations, mappings, error handling, scheduling, API-based integrations.
• Fluency in XML, XSLT, XSL-FO, JSON, REST, SOAP, not just awareness, but the ability to write, debug, and optimize.
• BI Publisher template development, RTF, XSL-FO, sub-templates, bursting configurations.
• Strong debugging, log analysis, and root-cause analytical skills.

AI & Automation Proficiency (Critical)

• Demonstrated experience using AI-assisted development tools (Claude, Copilot, Cursor, or equivalent) to accelerate integration development, testing, and documentation.
• Ability to write effective prompts for code generation, data transformation logic, test data creation, and documentation drafting.
• Mindset of "automate the repetitive, focus human effort on the complex", measurable track record of reducing manual effort through scripting, tooling, or AI augmentation.
• Familiarity with scripting for automation, Python, Shell/Bash, Groovy, or PowerShell for integration support tasks, file manipulation, and log analysis.

Strongly Preferred

• Experience with Oracle Business Events for real-time integration triggers.
• Knowledge of Oracle VBCS for lightweight integration UIs.
• Familiarity with the Oracle Fusion REST API catalog, pagination, query parameters, expand patterns, bulk operations.
• Experience with UCM/WebCenter Content for file staging and retrieval.
• Understanding of Oracle EPM, ERP, or SCM Cloud integration touchpoints with HCM.
• CI/CD awareness, version control for integration artifacts, environment promotion practices.
• Experience supporting M&A or large-scale data migration integration scenarios.

What Sets an Exceptional Candidate Apart

• You treat every manual process as a bug to be fixed, if it can be automated, you automate it.
• You've used AI tools to cut a 3-day integration build to 1 day and can articulate exactly how.
• You build integrations that operators can support without calling you, self-documenting, well-logged, clearly error messaged.
• You think in data flows, not just file transfers, understanding upstream and downstream impact of every field you move.
• You've been through at least one major Oracle Cloud HCM implementation or upgrade cycle end-to-end.
• You can explain a complex integration architecture to both a developer and a VP in the same meeting.

This role is designed for someone who combines deep Oracle HCM integration expertise with a modern, AI-augmented engineering mindset, delivering enterprise-grade integrations at startup speed.