Megthink - Oracle EBS Techno-Functional Consultant (9-15 yrs)

Job Summary :

We are seeking an experienced Oracle Financials EBS Techno-Functional Consultant to join our team. The successful candidate will possess a comprehensive understanding of Oracle E-Business Suite financial modules, complemented by strong technical expertise in SQL, PL/SQL, and related tools. This role involves providing functional support, system configuration, technical development, and troubleshooting to ensure smooth financial operations and optimal system performance.

Key Responsibilities :

- Provide functional support, configuration, and ongoing maintenance for Oracle EBS Financial modules including General Ledger, Fixed Assets, Accounts Payable, Accounts Receivable, Project Accounting, Purchasing, iProcurement, iExpenses, eTax, Cash Management, and System Administration.

- Financial Accounting Hub (FAH), along with banking attributes

- Manage and enhance reporting solutions using Reports Builder, XML Publisher, and Forms Builder.

- Develop, optimize, and troubleshoot SQL and PL/SQL scripts, procedures, functions, triggers and packages.

- Monitor system performance, identify bottlenecks, and implement tuning strategies such as partitioning and indexing.

- Support workflow processes using Workflow Builder and develop customizations via JDeveloper, OA Framework, and ADFDI uploads.

- Provide occasional on-call support outside regular business hours to address critical and emergent issues.

- Collaborate with functional teams and business stakeholders to gather requirements, troubleshoot issues, and implement solutions.

- Ensure compliance with best practices and company standards for application development and system administration.

Qualifications & Skills :

Functional Skill Set :

Proven experience with Oracle E-Business Suite Financial Modules, including :

- General Ledger (GL)

- Financial Accounting Hub (FAH) including banking attributes

- Subledger Accounting (SLA)

- Accounts Payable (AP)

- Accounts Receivable (AR)

- Fixed Assets (FA)

- Project Accounting (PA)

- Purchasing & iProcurement

- iExpenses, eTax, Cash Management

- System Administration

- Application Administration, Approvals Management (AME)

- Alerts Manager

- Cash Management

- Shared Human Resources and Oracle Cloud integrations

Technical Skill Set :

- Strong expertise in SQL and PL/SQL development and tuning.

- Experience with Reports Builder, XML Publisher, and Forms Builder.

- Proficiency in Unix Scripting for automation and troubleshooting.

- Knowledge of Workflow Builder, JDeveloper, OA Framework, and ADFDI.

- Understanding of Oracle Applications underlying ETL, table design, and structure.

- Experience in performance optimization, including hints and explain plans.

- Familiarity with Web Adi templates, and ADFDI upload templates.

- Hands-on experience with partitioning, indexing, and database performance tuning.

- Apex development experience is a plus.

- Ability to customize Forms, use CUSTOM.pll, develop Business Events, and manage Employee management modules.

Qualifications :

- Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent experience).

- 12 to 15 years of relevant experience in Oracle EBS Financial modules and technical development.

- Strong analytical and troubleshooting skills.

- Excellent communication and collaboration skills.

- Exposure to Oracle Fusion is desirable

Shift Timing :

- Core shift : 7 :00 AM to 7 :00 PM UK Time

- Flexibility is required within this window to meet business needs.

- Rarely, on-call support may be needed until 11 :00 PM UK Time.