Oracle Technical PL/SQL Consultant

emagine; India; In loco; INR 900.000 - 1.200.000; Tempo pieno

Descrizione del lavoro

emagine Group is seeking an experienced Oracle Technical PL/SQL Consultant to support a Payment Segmentation Project in India. You will be responsible for developing, analyzing, and integrating Oracle PL/SQL solutions within Oracle E-Business Suite.

The ideal candidate brings 5+ years of hands-on PL/SQL development, deep ERP integration experience, and strong performance tuning skills to optimize complex databases and data flows.

Competenze

• 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.

Mansioni

• 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.

Conoscenze

Oracle PL/SQL

Oracle E-Business Suite

SQL tuning

Data analysis

ERP integrations

Problem solving

Strumenti

XML Publisher

Oracle Workflow

Oracle APIs

Concurrent Programs

Descrizione del lavoro

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.