Functional Consultant

Oracle Apps Technical with SQL / PLSQL and DBA knowledge with 6-10 years of experience.

• Looking for Candidates with high level of proficiency of implementation using SQL and PL/SQL related technologies on Oracle Database as a PLSQL Developer.
• 610 years of experience in Oracle EBS and/or Oracle ERP Cloud.
• Strong command of

  SQL and PL/SQL

  , with proven experience in writing complex queries and procedures.
• Should be knowledgeable and experienced in SCM and/or Order to Cash Modules, SCM tables / packages and technical details.
• Familiarity with Oracle Cloud tools such as OTBI, FBDI, and ADF is a plus.
• Ability to work independently and manage multiple priorities in a fast-paced environment.
• Collaborate with business users and functional teams to gather requirements and translate them into technical solutions.
• Provide techno-functional support for Oracle EBS (R12) and Oracle ERP Cloud modules, especially in SCM, Inventory, and Finance.
• Analyze and troubleshoot issues related to Oracle applications, including performance tuning and data integrity.
• Strong knowledge of Oracle Applications architecture.
• Must have strong experience on CURSORS, STORED PROCEDURES, PACKAGES, FUNCTIONS AND TRIGGERS
• Should have extensive knowledge of Oracle database and PL/SQL programming, Performance tuning Using HINTS, table partitions, Indexing.
• Must have worked on Dynamic SQL, Collections and BULK COLLECT.
• Should have Knowledge Oracle prebuilt Packages of PL/SQL.
• Proficient in writing Complex SQL Queries.
• Must have Excellent Communication Skills
• Technical understanding of various E-Business Suite modules such as (Financials, Receivables / Payables /GL) WMS (Warehouse Mgmt System) SOA Gateway).
• Very good understanding of Oracle core database architecture and concepts
• Knowledge on Concurrent managers in Oracle EBS and strong AOL concepts.