Job Title:  Senior Consultant | Apex | Gurugram | Oracle

The team

Enterprise technology must do much more than keep the wheels turning; it is the engine that drives functional excellence and the enabler of innovation and long-term growth. Learn more about ET&P

Your work profile

Solution Design & Development

• Design and develop enterprise applications using Oracle APEX.
• Gather and analyze business requirements and translate them into technical solutions.
• Develop responsive and user-friendly dashboards, forms, workflows, and reports.
• Create reusable components and frameworks to accelerate application development.
• Perform code reviews and ensure adherence to development standards and best practices.

Database Development

• Develop and optimize SQL, PL/SQL packages, procedures, functions, and triggers.
• Design database objects and data models to support business requirements.
• Tune application and database performance for large datasets and high transaction volumes.

Integration & Automation

• Develop integrations using REST and SOAP web services.
• Integrate Oracle APEX applications with Oracle Fusion ERP, Oracle Primavera Unifier, Oracle Primavera Cloud (OPC), Oracle E-Business Suite, and third-party applications.
• Develop APIs and automation processes for seamless data exchange.

Reporting & Analytics

• Develop interactive reports, dashboards, charts, and KPIs.
• Implement BI Publisher and other reporting solutions as required.
• Support business users with analytical and operational reporting needs.

Testing & Deployment

• Prepare technical design documents and deployment plans.
• Perform unit testing, integration testing, and user acceptance testing support.
• Support application deployment across development, test, and production environments.
• Troubleshoot and resolve production issues.

Stakeholder Management

• Conduct workshops and requirement-gathering sessions with clients.
• Collaborate with functional consultants, project managers, and business users.
• Provide technical guidance to junior developers and consultants.

Required Skills

Technical Skills

• 3-5 years of experience in Oracle APEX development.
• Strong expertise in Oracle SQL and PL/SQL.
• Experience with Oracle APEX 20.x/21.x/22.x/23.x or later versions.
• Hands-on experience with REST APIs, JSON, XML, and web services.
• Experience with Oracle Database administration concepts and performance tuning.
• Knowledge of JavaScript, HTML5, CSS, and Dynamic Actions.
• Experience with Oracle BI Publisher and reporting tools.
• Familiarity with Git, SVN, or other version control systems.

Integration Skills

• Experience integrating Oracle APEX with:
• Oracle Fusion Cloud Applications
• Oracle Primavera Unifier
• Oracle Primavera Cloud (OPC)
• Oracle E-Business Suite
• Third-party enterprise systems

Preferred Skills

• Experience in infrastructure, engineering, construction, utilities, water, or capital project industries.
• Knowledge of Oracle Cloud Infrastructure (OCI).
• Exposure to Oracle Integration Cloud (OIC).
• Experience with Single Sign-On (SSO), OAuth, and security frameworks.
• Understanding of Agile and DevOps methodologies.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or related field.
• Oracle APEX certification preferred.
• Oracle Cloud certifications are an added advantage.

Key Competencies

• Strong analytical and problem-solving skills.
• Excellent communication and client-facing capabilities.
• Ability to work independently and lead technical workstreams.
• Strong documentation and presentation skills.
• Ability to mentor junior consultants and developers.