Oracle Technical PL/SQL Consultant

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.