Oracle Technical Consultant (EBS - HRMS & ApeX)

Interloop Holdings Pvt. Ltd.; Punjab; On-site; PKR 3,000,000 - 6,000,000; Full time

Job summary

Interloop Holdings Pvt. Ltd. is seeking an Oracle Technical Consultant to design, develop, and maintain complex integrations and reports.

You will work with Oracle EBS modules (Core HR, Payroll, GL) and Oracle APEX, delivering RESTful APIs, security measures, and AI-enabled enhancements. The role requires 4–6 years of hands-on experience in Oracle EBS/APEX development, strong SQL/PLSQL skills, and familiarity with enterprise applications and reporting technologies.

Qualifications

• Bachelor’s or Master’s in CS/IT or related field.
• 4–6 years relevant Oracle EBS/APEX experience.
• Strong SQL/PL/SQL and reporting/integration skills.
• Experience with Oracle development tools and security.

Responsibilities

• Design, develop, and maintain reports with BI Publisher/XML Publisher/RDF.
• Develop PL/SQL packages, procedures, functions, and triggers.
• Build enterprise apps using Oracle APEX, PL/SQL, JS/HTML5/CSS3.
• Create dashboards, forms, charts, and customized UIs.
• Translate business requirements into technical specifications.
• Develop and consume RESTful APIs and ORDS for communication.
• Implement and support Oracle Workflow and integrate apps.
• Provide Oracle EBS technical support and reporting.
• Ensure code quality, security, and performance optimization.
• Coordinate with DBAs, Infra, and Support for deployments.

Skills

SQL

PL/SQL

Reporting tools

Integrations

Enterprise apps

Education

Bachelor’s or Master’s degree in Computer Science, Software Engineering, Information Technology, or related field

Tools

BI Publisher

XML Publisher

RDF

Oracle APEX

ORDS

Oracle EBS

Job description

The Oracle Technical Consultant develops complex integrations and automations, including REST APIs and application security measures. Looking for the candidate having Bachelor's or Master's Degree in Computer Science, Software Engineering, Information Technology, or a related field, preferably with exposure to ERP systems, enterprise software, and application development, along with 4-6 years of relevant experience in Oracle EBS Technical Development and/or Oracle APEX Application Development, with strong hands-on expertise in SQL, PL/SQL, reporting technologies, integrations, and enterprise applications. Candidate will support application deployment, testing, and operational activities while coordinating with database administrators, infrastructure, and support teams. The role requires a deep understanding of Oracle EBS modules, especially Core HR, Payroll, and General Ledger, coupled with expertise in Oracle development tools and reporting technologies. This position demands a proactive approach in troubleshooting and optimizing solutions while adopting innovative AI-enabled features to improve business process automation. Candidates should have significant experience in Oracle technical architecture and demonstrate competence in advanced database and front-end web technologies.

Responsibilities

• Design, develop, and maintain custom reports using BI Publisher, XML Publisher, RDF, and Oracle reporting tools.
• Develop complex PL/SQL packages, procedures, functions, triggers, and other database objects.
• Build and enhance enterprise applications leveraging Oracle APEX, PL/SQL, JavaScript, HTML5, and CSS3 technologies.
• Create interactive dashboards, reports, forms, interactive grids, charts, and customized user interfaces.
• Collaborate with functional teams to accurately convert business requirements into detailed technical specifications and develop corresponding application solutions.
• Develop and consume RESTful APIs, JSON integrations, and Oracle REST Data Services (ORDS) for seamless application communication.
• Implement and support Oracle Workflow solutions and integrate various enterprise applications and services.
• Provide ongoing Oracle EBS technical support including customization and report development to meet business needs.
• Ensure adherence to Oracle development standards, code quality practices, security protocols, and performance optimization techniques.
• Optimize SQL queries, PL/SQL code, reports, and application performance to meet SLAs and business expectations.
• Coordinate and cooperate with Database Administrators, Infrastructure, and Support teams for deployment, testing, and production support activities.
• Proactively troubleshoot and resolve application, integration, and production environment issues efficiently.
• Implement advanced AI-enabled features within Oracle APEX applications, including AI agents and AI tools.
• Leverage modern AI technologies such as Generative AI, RAG, Vector Search, and AI-assisted development methods to drive innovation.
• Support data migration, release management, and post-production operational activities to ensure smooth business function continuity.
• Document technical designs, development processes, and change management procedures comprehensively.
• Stay abreast of emerging technologies and apply knowledge to enhance enterprise solutions and development frameworks.

.