Oracle SOA ODI Developer (with EBS experience). Cleveland, OH
HYRG Source
Hi,
Greetings from HYR Global Source!
I am Ramesh and working with HYR Global Source Inc.
Please go through the below job description and let me know your interests ASAP.
Reply with your updated resume and expected hourly rate.
Position: Oracle SOA ODI Developer (with EBS experience)
Location: Cleveland, OH
Duration: 6+ Months
VISA: No Constraints
10+ Years Resource Only
Consultant will be responsible for design and implementation of ODI Integration services and Oracle PL SQL. Consultant will be responsible for Creating design documents, and performing impact analysis for implementation elements following Sherwin-Williams’ Standards. Tasks include but not limited to:
· Develop technical design solutions for building Interfaces utilizing Oracle ODI , which integrate with multiple on-prem and Third part systems Enterprise systems (ORACLE EBS, Payroll, Fidility, Kronos ) and others.
· Participate in functional discussions with functional & technical team members to develop technical specification documents.
· Document requirements, assumptions, process and system ownership.
· Develop integration services by following Standards developed by GEA Integrations.
· Develop automated build and deployment scripts for all the interfaces.
· Develop reconciliation process for all the interfaces.
· Assist users with problems and resolve issues independently.
· Create test plans, test cases, test scripts and perform Unit and Load testing for all the interfaces.
· Troubleshoot and resolve issues independently.
Technical Experience/Skills Required:
· 5+ years of Hands-On experience with design and development of Integrations on ODI platform.
· Subject matter expertise in solution design, development standards and best practices for integration’s development on ODI platform.
· Experience with designing and developing integration’s for various integration patterns involving Flatfiles, SOAP, REST & Databases between Cloud/on-prem and multiple target systems.
· Hands-On experience in ODI Navigators like Designer, Topology, Operator and Security Navigator
· Hands-On Customization of KM's(Knowledge Modules) and knowledge of Integration-KM, Journalizing-KM, Check-KM, Loading-KM, Extract-KM, Service-KM and Reverse Engineering – KM.
· Hans-On experience working on slowly changing dimensions (SCD) , Change data capture (CDC). Creating ODI procedures, Mappings to create and populate in target systems.
· Hands-On using Expression in mapping area, aggregations in mappings, lookups, Filter, Datasets.
· Hands-On using Source table joins, Normal Join, Full Outer Join, Detail Outer Join, and Master Outer Join in the Joiner Transformation.
· Experience in developing Reusable mappings in ODI 12c for developing most complex interfaces.
· Hands-On Experience with Solution design and development of integrations involving Data Encryption by leveraging PGP, GPG or REST services based methods.
· Hands-On integrations development experience using XML/SOAP and REST API services on ODI.
· Strong SQL, PL/SQL, ETL/ELT knowledge.
· Experience with implementation of Error Handling and reprocessing framework for ODI integrations.
Technical Experience/Skills Preferred:
· Through understanding of ODI component Architecture.
· ODI administration –
· Involving setup/administration of Multiple Master repositories, Work repositories, Standalone and J2ee-agents.
· Management of users using various access levels.
· Experience with managing multiple environment and automated migration of the ODI archives (objects) to test and Prod envs.
· Good understanding of Physical and Logical Architecture, Contexts and Configuring Agents
· Strong weblogic administration experience.
Regards,
Ramesh,
HYR Global Source Inc | AN ERP Consulting Corp
Mail to: r...@hyrglobalsource.com
Work: 617-418-4173