Senior Consultant | Apex | Gurugram | Oracle

Deloitte.

Be audacious in impact

When was the last time you thought the unthinkable, defined the unfathomable, or did what no one else has dared to try?

At Deloitte, we're creating bold new frontiers for our clients and communities. Our roar echoes across India and beyond. So, bring your unique self and rise louder and leap further than ever before.

Senior Consultant | Apex |Gurugram |Oracle 

• Job requisition ID: 106946


• Location: Gurugram


• Entity: Deloitte Touche Tohmatsu India LLP

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.