Oracle EBS Technical Consultant

We are hiring a PL/SQL Developer to build and optimise database logic on Oracle.

Responsibilities

• Write stored procedures, functions, packages and triggers in PL/SQL
• Tune complex SQL queries for performance
• Build data loads and batch jobs
• Support production databases and fix issues

Requirements

• 2+ years of PL/SQL development on Oracle
• Strong SQL and query-tuning skills
• Unix shell scripting is a plus

We are looking for an experienced Oracle EPM Technical Consultant with strong hands-on expertise in Oracle EPM Cloud Planning / EPBCS technical components. The candidate will be responsible for configuring, developing, migrating, and supporting EPM applications across implementation, enhancement, and AMS engagements.

The ideal candidate should have practical experience with Forms, Business Rules, Groovy Calculations, Reports, Data Maps, Data Management, metadata management, and application artifact migration, along with a good understanding of Oracle EPM SaaS products.

Job Description — L2/L3 Oracle DBA and Oracle Apps DBA 

Experience: 5–10 years of relevant experience​

Support coverage: Dubai customer business hours and on-call support as required 

Role Overview 

We are seeking an experienced Oracle DBA and Oracle Apps DBA to support 

customer Oracle Database and Oracle E-Business Suite (EBS) environments. The role 

involves L2 incident resolution, L3 troubleshooting, performance tuning, patching, 

upgrades, and maintaining database and application availability. 

Key Responsibilities 

Oracle Database Administration 

∙Install, configure, administer, and maintain Oracle databases across 

production and non-production environments. 

∙Monitor database health, availability, performance, storage, and capacity. 

∙Troubleshoot database incidents, connectivity failures, locking, blocking, and 

resource issues. 

∙Analyse AWR and ASH reports, SQL execution plans, and database wait 

events to resolve performance problems. 

∙Configure and manage RMAN backups; perform recovery and restore 

validation. 

∙Administer Oracle RAC, ASM, Grid Infrastructure, and Data Guard 

environments. 

∙Perform database patching, upgrades, migrations, and refreshes through 

approved change procedures. 

∙Manage database users, roles, privileges, auditing, and security controls. 

∙Execute disaster recovery drills, Data Guard switchovers, and failovers. 

∙Automate routine administration and monitoring using shell scripts and SQL. 

Oracle Applications DBA 

∙Administer Oracle E-Business Suite R12.2 application and database tiers. 

∙Monitor and troubleshoot concurrent managers, concurrent requests, 

Workflow Mailer, application services, and login issues. 

∙Perform EBS online patching using ADOP and manage the associated 

patching lifecycle. 

∙Clone and refresh EBS environments using supported tools, including Rapid 

Clone. 

∙Maintain application configuration using AutoConfig and context files. 

∙Administer EBS-related WebLogic Server, Oracle HTTP Server, and Forms 

services. 

∙Troubleshoot application-tier performance and coordinate with functional 

and development teams. 

∙Support EBS upgrades, technology-stack patches, certificate renewals, and 

integration-related incidents. 

∙Maintain operational procedures for application startup, shutdown, backup, 

recovery, and maintenance. 

L2/L3 Support and Customer Operations 

∙Own incidents and service requests within agreed SLAs. 

∙Provide L2 troubleshooting and escalate complex issues with complete 

diagnostic evidence. 

∙Lead L3 investigation, root-cause analysis, and permanent corrective actions. 

∙Support major incidents, communicate progress, and document recovery 

actions. 

∙Raise and manage Oracle Support service requests. 

∙Prepare change plans, risk assessments, validation steps, and rollback 

procedures. 

∙Maintain runbooks, knowledge articles, configuration records, and shift 

handovers. 

∙Coordinate with customer teams and internal infrastructure, storage, 

network, and application teams. 

∙Mentor junior DBAs and identify opportunities to reduce recurring incidents. 

Required Skills and Experience 

∙Hands-on production experience administering Oracle Database, including 

Oracle 10g, 11g, 12c, 18c and 19c. 

∙Strong experience supporting Oracle EBS R12.2 as an Apps DBA. 

∙Practical knowledge of RAC, ASM, Data Guard, RMAN, Data Pump, and 

Job Summary

We are looking for an experienced Essbase Developer / Consultant with strong hands-on experience in Oracle Essbase OLAP (ASO/BSO) and financial reporting solutions. The candidate will be responsible for designing, developing, testing, supporting, and optimizing Essbase applications and reporting solutions.

The role requires strong technical expertise in Essbase, financial reporting, database modeling, Unix/Linux scripting, and production support.

Key Responsibilities

• Design, develop, test, debug, document, and maintain Essbase solutions using Agile development practices.
• Manage the complete lifecycle of multidimensional financial reporting and analytical applications, including requirements gathering, design, development, testing, deployment, and maintenance.
• Develop and support Oracle Essbase ASO/BSO applications.
• Work extensively with:
• Essbase Outline Design
• Load Rules
• MaxL Scripts
• Calculation Scripts
• Partitions
• Security
• Performance Tuning and Optimization
• Smart View / Excel Add-in
• Design and maintain financial reporting and analytical solutions.
• Work with Star Schema design and relational database modeling using Oracle or SQL Server.
• Source hierarchy and fact data from file-based and relational data sources.
• Work with metadata management systems such as DRM (Data Relationship Management).
• Develop Unix/Linux shell scripts to automate Essbase database outline builds, data loads, and aggregations.
• Build and maintain automation processes using CA AutoSys.
• Troubleshoot and resolve complex technical issues in Essbase applications.
• Provide production and on-call support when required.
• Ensure quality, security, and compliance requirements are met.
• Collaborate with business users, finance teams, and technical stakeholders.
• Document technical solutions, processes, and application changes.

Mandatory Skills

• 7+ years of overall IT/application development experience.
• 5–7 years of hands-on experience with Oracle Essbase OLAP.
• Strong experience with Essbase ASO and BSO.
• Hands-on experience with Outline Design, Load Rules, MaxL, Calc Scripts, Partitions, Security, and Performance Tuning.
• Strong experience with Smart View / Excel Add-in.
• Experience with financial reporting and multidimensional analytical applications.
• Experience with Oracle or SQL Server databases.
• Strong knowledge of Star Schema and relational database modeling.
• Experience with Unix/Linux Shell Scripting.
• Experience with CA AutoSys.
• Experience supporting production environments and providing on-call support.
• Strong communication and stakeholder management skills.

Oracle Planning Functional Analyst

6 + years

Duration - 6 Months

Need min 6+ years of experience in implementing Oracle Fusion Cloud Planning solutions. Candidates should have strong expertise in Supply Planning, Demand Planning, and Supply Chain Planning (SCP), along with hands-on experience integrating Planning modules with other Oracle Fusion applications. The ideal candidate should have implementation experience, strong business process understanding, configuration and testing expertise, and the ability to translate business requirements into effective planning solutions. Exposure to SQL/PLSQL and Oracle SCM processes is preferred.

Planning roles:

2:00 PM to 11:00 PM IST during the U.S. Daylight Saving period (approximately March to early November each year) / 3:00 PM to 12:00 Midnight IST during the non-Daylight Saving period (approximately November to the end of February each year).

* 7+ years of IT experience with hands-on Oracle Retail XStore POS Development experience.

* Strong hands-on experience in Oracle Retail XStore POS development, implementation, and customizationt engagements.

* Expertise in XStore Architecture, XStore Office, POSLog, Extension Framework, business components, event listeners, and transaction workflows.

* Design and deliver scalable XStore solutions by translating business requirements into functional and technical implementations.

* Hands-on experience in XStore JET UI customization, screen enhancements, dashboards, forms, and user experience improvements.

* Proficiency in Java, Spring Framework, REST APIs, SOAP Services, XML, JSON, SQL, and Oracle Database technologies.

* Experience design and developing integrations with ERP, Inventory, Pricing, Loyalty, Customer, Payment, and Omnichannel platforms.

* Strong understanding of retail business processes including Sales, Returns, Exchanges, Promotions, Loyalty, Inventory, and Store Operations.

* Perform solution design, fit-gap analysis, impact assessment, code reviews, troubleshooting, defect resolution, and production support activities.

* Experience supporting SIT, UAT, deployments, upgrades, migrations, store rollouts, hypercare, and post-production stabilization.

* Excellent stakeholder management, problem-solving, and communication skills with experience delivering solutions in global retail environments.

* Preferred Skills: Experience with XStore upgrades, modernization programs, POSLog, DTX messaging, XOCS/SIOCS integrations, and large-scale retail transformation initiatives.

OBIEE Developer + ETL Lead

🔹 Experience: 8+ Years

🔹 Location: PAN India

🔹 Work Mode: Work From Office – 5 Days

🔹 Joining: Immediate Joiners Preferred

🔹 Communication: Excellent communication skills required

💼 Key Skills:

• #OBIEE Development

• #ETL / #DataIntegration

• #BIReporting & Analytics

• #ETL Lead / Technical Leadership

• Strong #SQL & #Database Concepts

We are looking for a highly skilled Senior NetSuite Developer with 5+ years of hands-on experience in designing, developing, customizing, and integrating Oracle NetSuite ERP solutions. The ideal candidate should possess strong expertise in SuiteScript 2.x, SuiteCloud development, integrations, workflows, and NetSuite customizations while collaborating with functional consultants and business stakeholders to deliver scalable enterprise solutions.

Key Responsibilities

• Design, develop, and maintain custom NetSuite solutions using SuiteScript 2.x
• Customize NetSuite forms, records, fields, workflows, saved searches, dashboards, and reports
• Develop and maintain RESTlet, SuiteTalk (SOAP/REST), and third-party integrations
• Build and deploy SuiteApps using the SuiteCloud Development Framework (SDF)
• Develop User Event, Client, Scheduled, Map/Reduce, RESTlet, and Suitelet scripts
• Optimize existing customizations for scalability and performance
• Collaborate with business analysts and functional consultants to understand requirements and translate them into technical solutions
• Troubleshoot production issues and provide timely resolutions
• Perform code reviews and ensure adherence to NetSuite development best practices
• Participate in Agile ceremonies and contribute to sprint planning, estimation, and technical design discussions
• Maintain technical documentation for custom developments and integrations

Required Skills

• 5+ years of hands-on NetSuite development experience
• Strong expertise in:
• SuiteScript 2.x
• SuiteCloud Development Framework (SDF)
• SuiteFlow
• SuiteBuilder
• SuiteAnalytics
• Saved Searches
• Experience developing:
• User Event Scripts
• Client Scripts
• Suitelets
• RESTlets
• Scheduled Scripts
• Map/Reduce Scripts
• Strong understanding of NetSuite record architecture and scripting APIs
• Experience with NetSuite integrations using:
• REST APIs
• SOAP (SuiteTalk)
• Celigo, Boomi or similar iPaaS platforms
• Experience with JavaScript (ES6+), HTML, CSS, and JSON
• Strong SQL/database concepts
• Version control using Git
• Experience with CI/CD and deployment automation

Strong Senior Developer – PL/SQL, SQL & ETL (Microsoft SSIS) Profile

2

Mandatory (Experience 1) – Must have minimum 5+ years of strong hands-on experience in PL/SQL and SQL development, including complex stored procedures, functions, queries, joins, data manipulation, and query/performance optimization.

3

Mandatory (Experience 2) – Must have strong hands-on experience in ETL development using Microsoft SSIS, including building, maintaining, optimizing, and troubleshooting SSIS packages for large-volume data movement and transformation.

4

Mandatory (Experience 3) – Must have solid experience working with Data Warehousing concepts and architectures, including data models, fact/dimension structures, ETL data flows, and enterprise reporting/data warehouse environments.

5

Mandatory (Experience 4) – Must have experience managing batch jobs, scheduling, and data pipelines, ensuring timely and reliable execution of enterprise ETL workflows.

6

Mandatory (Experience 5) – Must have hands-on experience in production support for SSIS/ETL and data warehouse jobs, including monitoring job execution, troubleshooting failures, performing root cause analysis, and implementing preventive fixes.

7

Mandatory (Experience 6) – Must have experience with data quality, validation, and troubleshooting, including identifying and resolving data discrepancies/issues affecting downstream reports, dashboards, and analytics.

8

Mandatory (Experience 7) – Must have experience with unit, integration, and regression testing of SQL, PL/SQL, and ETL components, along with strong documentation of technical designs, data mappings, data flows, and deployment processes.

9

Mandatory (Location) – Must be willing to work in a hybrid model from a city where Cognizant has an office.

10

Mandatory (Notice Period) – Immediate joiners or candidates who can join within 2–4 weeks.

We are seeking an experienced Fusion Receivables Functional Consultant with following skills:

• Designing Oracle Fusion Receivables process flows to handle data migrations, transformation and orchestration of Interfaces between third party systems and Oracle Cloud.
• Responsible for designing, developing, and maintaining expert level skills on Fusion Receivables.
• Demonstrated experience in gathering and documenting business requirements, leading fit-gap analysis, conference room pilots (CRPs) functional configuration, testing, client user training.
• Design and develop integrations to/from Oracle ERP Fusion receivables FBDI File Uploads.