Oracle SOA/ODI

• 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. Should have good understanding of the knowledge modules like LKM, IKM, SKM, etc.
• Analyze and identify the right Knowledge modules and develop the interface.
• 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
• Experience with installation and configuration Oracle Fusion Middleware products in high-availability environments
• Experience troubleshooting, performance tuning, testing and administration support for Oracle Fusion Middleware applications and environments.
• Experience supporting code deployments, customizations and integration of Oracle Fusion Middleware technologies with 3rd party applications and databases
• Must have experience on Deploying SOA composites through WLST, EM console, ANT scripts and also through any of the continuous integration tool
• Experience installing, configuring, and utilizing Continuous Integration tools and technologies, including Ant, Github, Jenkins
• Must be able to monitor hardware , OS and application performance (e.g. CPU, I/O, Memory, Network traffic etc.) through available utilities
• Experience in various deployment methods (Jenkins/WM Deployer, CI/CD etc.) and version control tools - (SVN, GIT HUB and BIT Bucket)
• 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.
• Should have basic understanding of Change Management, Requirement Gathering, Incident management, problem management, change management
• Analyze the current functionality and modify existing flows based on the change request provided by Business that needs to be enhanced.
• 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.
• 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.
• OIC development experience is an added advantage

Additionally:

• 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 members 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