Oracle HCM Integration Engineer

Wise Skulls llc

Boston, MA, United States

12 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Temporary contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

3 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Application Programming Interfaces (APIs) Amazon Web Services Amazon S3 Microsoft Azure Big Data Cloud Computing Information Engineering Data Integration Data Transformation Data Security Database Queries Domainkeys Identified Mail

+39 more

Middleware File Transfer Hardware Description Language Internet Message Access Protocols Python (Programming Language) OAuth Oracle Databases Oracle (Applications) Oracle SQL Developer Software Engineering SQL Stored Procedures Data Streaming Twilio Web Services Extensible Markup Language (XML) Enterprise Data Management Data Processing File Transfer Protocol (FTP) Enterprise Software Applications Cyberark Bi Publisher Office365 Snowflake SOAPAPI Sap Business Objects HR Software Integration Tests Enterprise Integration AWS Data Analytics Front End Software Development Application Client Oracle HCM Api Gateway SailPoint Restful APIs Streamlit Framework Oracle Integration Api Management Servicenow

Job description

As a senior integration engineer within the HR Technology Tech Pod, you will design, develop, deploy, and support data integrations and APIs across Citizens Bank’s HR technology ecosystem. You will work across Oracle HCM Cloud, Oracle Integration Cloud (OIC), Snowflake, AWS, and 20+ vendor applications to ensure reliable, secure, and compliant HR data flows. You will participate in quarterly Oracle platform releases, drive the AWS data migration initiative, build modern data access applications, and provide production incident response for mission-critical HR systems., * Designing, building, and maintaining Oracle Integration Cloud (OIC) jobs, REST/SOAP APIs, and BI Publisher (BIP) reports that move HR data between Oracle HCM/ORC and downstream systems (SailPoint, ServiceNow, BLOC, Fuel50, Equifax, Icertis, and others).

Engineering the HR Data Transformation initiative migrating the HR Datahub from on-premises Oracle to AWS (S3/Snowflake), including SFTP-to-S3 file transmission migration via Seeburger, data comparison/validation across environments, and production stabilization post-cutover.
Managing the integration engineering aspects of Oracle’s quarterly release cycle (26A 26D) across DEV1/DEV2/UAT/PROD environments reviewing release notes for integration impacts, transferring VBS configurations, performing SIT and ORC integration testing, and providing cutover support.
Developing modern data access applications using Snowflake and Streamlit (Python), including large-scale data archival solutions (1M+ attachment migrations), front-end interfaces for legal/compliance inquiry access, and internal reporting tools.
Owning the integration layer for Oracle Recruiting Cloud and its vendor ecosystem 2-Way Messaging (Twilio SMS, Azure/O365 Email), Paradox chatbot API management, HireVue SSO/T2O integrations, and Radancy XML job feed transmissions.
Managing the lifecycle of SSL certificates, DKIM keys, PGP encryption keys, Azure Application Client Secrets, and OIC API Gateway certificates across all environments, coordinating with Venafi, Oracle Support, Middleware, and external vendors.
Performing quarterly Non-Human Account (NHA) password resets for 15+ service accounts driven by CyberArk compliance policy, and managing post-refresh validation of UAT/DEV environments.
Coordinating with Enterprise Data Organization (EDO) and Oracle Functional Services (OFS/Infosys) on process migrations converting SFTP-based file delivery to OIC SFTP, rewriting stored procedures to Oracle Business Objects, and executing end-to-end migration testing.
Investigating and resolving production defects API failures, SMS outages, BI Publisher report issues, environment connectivity failures, and data discrepancy remediation requiring same-day resolution.
Providing engineering analysis and implementation support for strategic initiatives including GCC India offshore onboarding, Redwood UI migration, and Oracle HCM Enhanced Address Validation downstream impact analysis.

Requirements

5+ years of experience in integration engineering, middleware development, or enterprise application development
3+ years of hands-on experience with Oracle Integration Cloud (OIC) job design, lookup/business object configuration, scheduling, and error handling
3+ years of experience with Oracle HCM Cloud or Oracle Recruiting Cloud (ORC) BIP reports, PVO extracts, REST APIs, HDL loaders
Strong SQL skills Oracle PL/SQL and/or Snowflake SQL for data comparison, validation queries, and stored procedure analysis
Experience with REST/SOAP API development, including OAuth 2.0, API Gateway management (F5), and IMAP integration
Experience with file transfer protocols SFTP, PGP encryption/decryption, Seeburger/BIS or equivalent managed file transfer platforms
Demonstrated ability to manage 10+ concurrent workstreams across different release cadences
Strong cross-team communication skills coordinating deliverables across offshore teams (OFS/India), middleware, transmissions, data engineering, and business lines simultaneously
Experience with IT Change Management processes (ServiceNow change tickets, production readiness, cutover coordination)