Description

You will design, develop, and support ETL solutions and integration workflows using Oracle ODI and FMW SOA in Rosemont, IL.

Responsibilities

• Design and develop ETL solutions using ODI to integrate data from various sources into data warehouses.
• Create mappings, workflows, load plans, interfaces, packages, and procedures.
• Develop and maintain Oracle SOA Suite 12c and Oracle OSB components, including complex transformations using XSLT.
• Install, configure, and troubleshoot Oracle Fusion Middleware in high-availability environments.
• Perform root cause analysis (RCA) for production issues and optimize ETL job performance.

Required Skills

• 8+ years of experience in Oracle ODI and FMW SOA development and support.
• Deep understanding of ODI Knowledge Modules (LKM, IKM, SKM, etc.).
• Proficiency with Oracle Technology adapters including FTP, File, DB, and AQ.
• Hands-on experience with SOAP, REST, JMS, and UMS.
• Experience with Salesforce integration.
• Strong debugging skills in Oracle SOA Suite 12c and Oracle OSB.
• Experience with CI/CD tools and version control such as Jenkins, Ant, GitHub, SVN, or Bitbucket.
• Proficiency in SQL and Unix shell scripting.
• Ability to monitor hardware and OS performance including CPU, I/O, Memory, and Network traffic.

Preferred Skills

• Oracle Integration Cloud (OIC) development experience.
• Experience working within Agile Scrum methodologies using Jira and Confluence.

Key Skills

Education

Any Graduate