Oracle SOA Consultant - Ampcus Incorporated
Rosemont, IL
About the Job
Title: Oracle SOA Consultant with Web methods
Location: Rosemont, IL (Hybrid Role) - Onsite 3 days and remote 2 days
Position Type: Fulltime
Salary: $130K + Benefits
Job details:
Strong Development and Support knowledge in Oracle ODI and FMW SOA with at least 8 years
Design and develop ETL solutions using ODI to integrate data from various sources into data warehouse.
Create mappings, workflows, and load plans to move data from source systems to target systems. Develop and maintain ODI interfaces, packages, procedures, and functions.
Analyze and identify the right Knowledge modules and develop the interface.
Should have good understanding of the knowledge modules like LKM, IKM, SKM, etc.
Good knowledge of SQL and Unix commands.
Monitor and troubleshoot ETL jobs, identify and resolve issues, and optimize performance.
Document ETL designs, mappings, workflows, and other artefacts.
Stay up-to-date with the latest ODI and data integration technologies and trends.
Strong Development knowledge and code debugging skill in Oracle SOA Suite 12c and Oracle OSB
Good Knowledge on Oracle Technology adapters (FTP, File, DB, AQ etc.), Salesforce, SOAP, REST, JMS, UMS etc. along with Complex Transformation using XSLT
Should have basic understanding of Change Management, Requirement Gathering, Incident management, problem management, change management
OIC development experience is an added advantage
Good knowledge of SQL and Unix commands (Shell Scripting).
Good communication skill. Should be flexible.
Should be confident enough to deal with client one on one basis and managing delivery on time
Should have team management and reporting skill
Technically competent resource with experience in wide range integration platforms
Collaborate with business analysts, data architects, and other stakeholders to understand data integration requirements and translate them into technical specifications.
Analyze the current functionality and modify existing flows based on the change request provided by Business that needs to be enhanced.
Perform data profiling, cleansing, and validation to ensure data accuracy and integrity.
Identify, analyses and communicate all exception errors to the appropriate application owners and service managers
Cross train team members for effective management of production issues and resolution
Conduct Root Cause analysis (RCA) and apply fixes accordingly
Provide detailed analysis of the issue reported that might be related to program bug and data related issues
Identify and suggest the required long term fix to have it resolved.
Candidate should have extensive working experience in MWS, Integration Server, webMethods designer, Universal Messaging, Web Services (REST, SOAP), pub-sub model
Understanding of coding, log/tracing, JMS and processing, Security Policies, Authentication/Authorization
Have worked and followed exhaustive best practices of coding and design standards in webMethods.
Assist in deploying code for Ad-hoc releases or Project releases to Performance and Production Environments.
Experience in various deployment methods (Jenkins/WM Deployer, CI/CD etc.) and version control tools - (SVN, GIT HUB and BIT Bucket)
Having working experience of Jira, Conflunence with good knowledge of Agile Scrum, Service Oriented Architecture, Design & Development, design patterns and recommends proper usage of patterns.
Guides (and helps others) in creating and reusing components.
Good understanding of e-commerce and web integration principles, Enterprise Application Integration (EAI), middleware.
Ownership for Requirement, Design, Review, Testing coordination and for providing best solution to the offshore team and to the client.
Basic Unix and shell scripting
Provide support and help to AMS team on SAG platform and Interface support (post production)
Responsible for coaching, guiding and mentoring junior members in the team to help them to scale faster.
Having experience to work with the client independently with sound verbal and written communication and drive 5-10 member team.
Expertise in onsite-offshore working model.
Having decent experience in basic project management activities.
Provide/create architecture solutions, framework, reusable components and IPs for the project and for the Organization
Location: Rosemont, IL (Hybrid Role) - Onsite 3 days and remote 2 days
Position Type: Fulltime
Salary: $130K + Benefits
Job details:
Strong Development and Support knowledge in Oracle ODI and FMW SOA with at least 8 years
Design and develop ETL solutions using ODI to integrate data from various sources into data warehouse.
Create mappings, workflows, and load plans to move data from source systems to target systems. Develop and maintain ODI interfaces, packages, procedures, and functions.
Analyze and identify the right Knowledge modules and develop the interface.
Should have good understanding of the knowledge modules like LKM, IKM, SKM, etc.
Good knowledge of SQL and Unix commands.
Monitor and troubleshoot ETL jobs, identify and resolve issues, and optimize performance.
Document ETL designs, mappings, workflows, and other artefacts.
Stay up-to-date with the latest ODI and data integration technologies and trends.
Strong Development knowledge and code debugging skill in Oracle SOA Suite 12c and Oracle OSB
Good Knowledge on Oracle Technology adapters (FTP, File, DB, AQ etc.), Salesforce, SOAP, REST, JMS, UMS etc. along with Complex Transformation using XSLT
Should have basic understanding of Change Management, Requirement Gathering, Incident management, problem management, change management
OIC development experience is an added advantage
Good knowledge of SQL and Unix commands (Shell Scripting).
Good communication skill. Should be flexible.
Should be confident enough to deal with client one on one basis and managing delivery on time
Should have team management and reporting skill
Technically competent resource with experience in wide range integration platforms
Collaborate with business analysts, data architects, and other stakeholders to understand data integration requirements and translate them into technical specifications.
Analyze the current functionality and modify existing flows based on the change request provided by Business that needs to be enhanced.
Perform data profiling, cleansing, and validation to ensure data accuracy and integrity.
Identify, analyses and communicate all exception errors to the appropriate application owners and service managers
Cross train team members for effective management of production issues and resolution
Conduct Root Cause analysis (RCA) and apply fixes accordingly
Provide detailed analysis of the issue reported that might be related to program bug and data related issues
Identify and suggest the required long term fix to have it resolved.
Candidate should have extensive working experience in MWS, Integration Server, webMethods designer, Universal Messaging, Web Services (REST, SOAP), pub-sub model
Understanding of coding, log/tracing, JMS and processing, Security Policies, Authentication/Authorization
Have worked and followed exhaustive best practices of coding and design standards in webMethods.
Assist in deploying code for Ad-hoc releases or Project releases to Performance and Production Environments.
Experience in various deployment methods (Jenkins/WM Deployer, CI/CD etc.) and version control tools - (SVN, GIT HUB and BIT Bucket)
Having working experience of Jira, Conflunence with good knowledge of Agile Scrum, Service Oriented Architecture, Design & Development, design patterns and recommends proper usage of patterns.
Guides (and helps others) in creating and reusing components.
Good understanding of e-commerce and web integration principles, Enterprise Application Integration (EAI), middleware.
Ownership for Requirement, Design, Review, Testing coordination and for providing best solution to the offshore team and to the client.
Basic Unix and shell scripting
Provide support and help to AMS team on SAG platform and Interface support (post production)
Responsible for coaching, guiding and mentoring junior members in the team to help them to scale faster.
Having experience to work with the client independently with sound verbal and written communication and drive 5-10 member team.
Expertise in onsite-offshore working model.
Having decent experience in basic project management activities.
Provide/create architecture solutions, framework, reusable components and IPs for the project and for the Organization
Source : Ampcus Incorporated
