Oracle Technical PL/SQL Consultant

We are seeking a skilled Oracle Technical PL/SQL Consultant to support a Payment Segmentation Project. The ideal candidate will be responsible for technical development, data analysis, integrations, and various database-related activities within Oracle E-Business Suite.

Main Responsibilities

Key responsibilities include:

  • Develop, enhance, and maintain Oracle PL/SQL solutions.

  • Analyze and process data related to payment segmentation requirements.

  • Design and optimize SQL queries, stored procedures, packages, functions, and triggers.

  • Support data extraction, transformation, and validation tasks.

  • Collaborate with functional consultants to implement business requirements.

  • Troubleshoot technical issues and resolve performance bottlenecks.

  • Support testing and deployment activities.

Key Requirements

  • 5+ years of hands-on Oracle PL/SQL development experience.

  • Strong experience with Oracle E-Business Suite (EBS).

  • Deep understanding of Oracle database architecture and performance tuning.

  • Experience with complex SQL, PL/SQL packages, procedures, functions, and interfaces.

  • Experience supporting ERP-related integrations and data flows.

  • Strong problem-solving and analytical skills.

Nice to Have

  • Experience with Oracle Financials and SCM modules.

  • Knowledge of Oracle APIs, Concurrent Programs, XML Publisher, and Oracle Workflow.

  • Experience with payment-processing or finance-related projects.

  • Exposure to Oracle Integration technologies.