Skip to Main Content

Job Title


Oracle Technical Consultant


Company : Greystar


Location : Udaipur, Rajasthan


Created : 2025-07-23


Job Type : Full Time


Job Description

Technical Experience: Possess a total of 6+ years of IT experience in Oracle Cloud/Fusion ERP and Oracle EBS modules. Minimum 5 years of hands-on experience in Oracle Cloud ERP, particularly in Finance and PPM modules, focused on reporting, integrations, and technical development. Exposure to Oracle Cloud HCM is not mandatory, but familiarity alongside Finance and PPM is preferred.Responsibilities:Design, develop, and maintain robust PL/SQL code including packages, procedures, functions, and structured exception handling aligned with Oracle ERP standards. Develop and optimize payment templates such as Positive Pay, RTF, E-Text, and Excel based on functional requirements and localization needs. Build custom reports and dashboards in Oracle CloudFinanceandPPMmodules usingBI Publisher (BIP)andOTBI , ensuring accuracy and performance. Write and fine-tune complex SQL queries to support data models, custom reports, and improve long-running process efficiency. Create and manage customESS jobs ,job sets , andvalue sets , utilizingData Composerfor transactional reporting within Oracle ERP Cloud. Implement and maintainOracle Integration Cloud (OIC)integrations, including REST/SOAP APIs, file-based adapters, and real-time or scheduled data flows. Develop scalable integration flows using OIC to connect Oracle Fusion Cloud with third-party applications and legacy systems. Configure and schedule data extractions usingBusiness Intelligence Cloud Connector (BICC)for Finance, PPM, and Procurement modules. Automate data pipelines using BICC with file transfer mechanisms for downstream reporting and analytics systems. Troubleshoot and resolve technical issues across custom reports, integrations, and core ERP modules to ensure system reliability. Collaborate closely with functional consultants and business users to gather requirements, propose technical solutions, and deliver enhancements. Adhere to Oracle development best practices for coding, testing, migration, documentation, and production deployment.Skills Required: Strong PL/SQL and SQL Performance Tuning – Mandatory BI Publisher (BIP) and OTBI Reporting – Mandatory Payment Template Customization – RTF, Check Print, Positive Pay, and Transmission Configuration – Mandatory Oracle EBS Technical (Reports and Interfaces) – Good to have Oracle Integration Cloud (OIC) – Minimum 1 year – Must Have Business Intelligence Cloud Connector (BICC) – Minimum 1 year – Must Have Deployment and Production Support experience Strong Problem-Solving and debugging skills Familiarity with Agile methodologies (JIRA)