Oracle EBS Technical Consultant

Must have skills : BI/XML Publisher and Oracle Reports, Oracle SQL and PL/SQL(Packages/Functions/Ref cursors), RICEW components (Reports, performance optimization, * 8-10+ Years Functional candidates will be assessed on their competency of mentioned technical skills as well

• Strong experience as a developer in ERP and Oracle Cloud, RICEW, PL/SQL.
• Develop, maintain and troubleshoot issues; and take a leading role in the ongoing support and enhancements of the applications
• High level of commitment to client satisfaction and agility
• Have designed custom DB solution for an application and done integration with other DB
• Develop, maintain and troubleshoot issues in the ongoing support and enhancements of the applications
• Help in maintaining the standards, procedures and best practices in the team
• Collaborate with others and build positive working relationships.
• Possess a strong work ethic. * Strong written and verbal communication skills

Preferred qualifications-

• Strong Experience with ERP/Oracle Fusion XML/BI Reports
• Reports - OTBI, BI Publisher, Smart View, Financials Reporting Centre
• Strong Experience with Oracle Database
• Good Understanding of Oracle Architecture
• Good Understanding of data flow and under lying table in Finance/SCM Modules like PO, AP, AR, FA, GL, INV.
• Good experience in Oracle performance optimisation techniques * Good experience and hands-on knowledge of PL/SQL (Packages/Functions/Ref cursors)
• Hands on experience in frequent code deployment into multiple environments
• Design, develop, tests technical solutions and document technical design specification in line with OUM methodology (Oracle Unified Method).
• Capable of crafting solutions and providing process consulting.

Good to have technical skills:

• Experience in OTBI and FRS Reports o Experience in Page Customizations o Exposure in versioning tools like GIT o Exposure in REST/SOAP API’’'’s

• Functional o Experience of working within Finance/SCM Modules (PO, AP, AR, FA, GL, INV) o Openness to work as a part of a team engaged in development as well as production support activities RESPONSIBILITIES:
• Oracle ERP technical consultant who would be involved closely with application development to create and manage DB objects which involves performance and bug fixing on the go.
• Designing and implementing technical solutions on Oracle ERP/Cloud technologies.
• Building DB components for custom applications/reports based on requirements.
• Ability to troubleshoot issue - Trace data/logic and report back on root cause.
• Work directly with the customer on requirement understanding and complete the development.
• Ability to work on own initiative and as a team member in a high-pressure environment.
• Having excellent written and verbal communication skills.
• Being able to adapt to new technologies and techniques.