4 Oracle Otbi Jobs

You are ready to gain the skills and experience necessary to advance your career, and we have an excellent opportunity for you as a Software Engineer II at JPMorgan Chase within the Workforce Technology Team, specifically as a part of the Employee Platforms Team. In this role, you will play a vital role in our agile team, focusing on enhancing, designing, and delivering software components for cutting-edge technology products. Your responsibilities will include implementing software solutions through design, development, and troubleshooting of various technical products, applications, or systems. This position offers a great chance to refine your skills and gain valuable experience for career progression. Your key responsibilities will involve maintaining business processes such as configuration documents, JIRA practices, and SR tracking, consulting and supporting HCM Oracle Compensation Cloud, utilizing Oracle OTBI and HDL/HSDL experience, ensuring clear communication and timely responses, following security and release processes to minimize risks, safeguarding data privacy and ensuring regulatory compliance, applying lessons learned to reduce production defects, reviewing Oracle release notes and conducting impact analysis, meeting design deliverables and deadlines with consistent follow-through and independent work, conducting functional testing to minimize defects, and quickly identifying and resolving root causes. To qualify for this role, you should have formal training or certification in software engineering concepts and at least 2+ years of applied experience, the ability to work effectively in large, collaborative teams to achieve organizational goals, a passion for fostering an innovative culture, and a minimum of 2 years of experience in HCM Oracle Compensation Cloud. Preferred qualifications include exposure to Oracle HCM Compensation and a background in Btech.,

About Oracle Customer Success Services(CSS): As a key member of Oracle Customer Success Services, you will join an international network of experts dedicated to driving customer success through innovation and expertise. Our One Oracle approach ensures you will be part of a team delivering comprehensive, end-to-end services and solutions that accelerate the entire customer journey. Work alongside certified and experienced professionals, gaining exposure to cutting-edge technologies and methodologies, and enhancing your skills and credentials. Engage with a diverse range of customers, managing the full lifecycle of delivery and services, and ensuring each project has a tangible impact. Benefit from robust team support in a collaborative environment that prioritizes teamwork and mutual success. Join us in Oracle Customer Success Services and elevate your career with a company that values innovation, expertise, and customer-centric solutions Career Level - IC4 Mandatory Skills: Should have 8+ years of experience in Oracle SQL query tuning expertise. Strong expertise in writing and understanding of Oracle SQL/PLSQL Functional knowledge of Oracle Fusion Middleware products, Weblogic & Database products. Interpreting explain plans and able to read AWRs and ASH for identifying SQL query bottle necks. Ability to interpret explain plans for access path, predicate filtering and high knowledge of joins and orders in table access. Advanced knowledge of SQLHC, parallel query knowledge. Should have rich experience in factored / scalar sub-queries and ability to utilise them in sql queries. Strong decision making, convincing skills to bring down the complex discussions to closure supported by right arguments and facts. Understanding of database initialization parameters, logs and traces. Experience working on complex software development/integration projects Experience in scripting tool like Unix shell, Python, Perl Optional hands on troubleshooting Oracle OTBI & BIP report issues and performance related techniques on components like Data models/sets, LOV, parameters , bursting, FF, scheduling. Good to Have Skills: Understanding of AI and Machine learning will be an added advantage. Oracle SQL performance diagnostic tools like SQLHC Experience in using monitoring tools like OEM. Building synthetic test cases. Responsibilities: Optimize Oracle SQL: Diagnose and resolve individual SQL performance issues (you would need to apply hints, define new indexes, investigate optimiser/environment issues) . Early Adopter of Innovation: Explore and adopt new technologies like Oracle 23ai, Autonomous DB, Auto indexing, AI related tools. Analysis and Optimize Oracle BIP Reports: Should be able to help customer to identify performance issues with Oracle BIP reports functionality and sql queries involved with them. Optional knowledge of various components of BIP reports like Data models, Parameters, LOVs, Flex Fields, Bursting. Should be able to advise customers to use right sql queries as per Oracle best practices and which aids in completing the report optimally. OTBI and BIP reports: Knowledge of troubleshooting OTBI reports for advising customers to use performance enhancing configuration parameters. Career Level - IC4

Skills - Oracle HCM Reporting, Oracle BI Publisher and OTBI, Interactive dashboards, and Analytical skills, HR Modules, Good Communication, Stakeholders Mgt, Note 70% should be in Functional and 30% in Technical job description: We are seeking a highly skilled and detail-oriented Senior Business Systems Analyst to join HR Technology team and provide expert support for Oracle Cloud HCM reporting. The successful candidate will be responsible for designing, maintaining complex reports using both Oracle Business Intelligence Publisher (BIP) and Oracle Transactional Business Intelligence (OTBI) across HR, Benefits, Compensation, Performance and Talent modules. An important component of this role is the understanding and implementation of security rules within the reporting environment to ensure confidentiality and integrity of data. Experience: • Minium 5 years of extensive experience with Oracle HCM Reporting. • Total 5 to 7 years of IT experience in building reports and dashboards using Oracle BI Publisher and OTBI. Responsibilities: • Requirements Gathering and Analysis: o Act as primary liaison for Oracle HCM Cloud Reporting, consulting with internal customers to create requirements for new reports, report changes, and data requests. o Developing or translating requirements to technical developers. o Collaborate with HR, Benefits, Compensation, Performance, and Talent stakeholders to understand their reporting and security needs. o Translate complex business requirements into clear and detailed Funcitonal specifications, including security requirements. o Analyze existing reports and security configurations to identify areas for improvement and performance optimization. o Document requirements, specifications, security design, and testing plans. • Report Maintenance: o Design and maintain complex reports using Oracle BIP and OTBI, including data modeling, SQL queries, and layout design. o Ensure data accuracy, consistency, and security across all reports. o Optimize report performance and troubleshoot reporting and security issues. • Security Implementation and Management: o Design and implement security rules within Oracle HCM reporting to control access to sensitive data. o Understand and apply Oracle HCM security concepts and configurations related to reporting. • Data Analysis and Validation: o Perform data analysis to validate report results and identify data discrepancies and security vulnerabilities. o Develop and execute test plans to ensure report accuracy and functionality. • User Support and Training: o Provide support to end-users regarding report usage, troubleshooting, and security guidelines. o Develop and deliver training materials and documentation for reports and reporting tools. o Assist in the development of best practices and standards for reporting and security. • Project Management and Collaboration: o Participate in project planning and execution related to reporting and security initiatives. o Collaborate with IT, security, and other business teams to ensure successful report and security implementation. o Manage multiple reporting and security projects and prioritize tasks effectively. o Keep up to date on oracle HCM cloud updates, new report features and security patches. Preferred Skills: • Experience with Oracle Analytics Cloud (OAC). • Experience with other reporting and security tools. • Knowledge of data warehousing concepts and security best practices. • Project management experience. • Experience with SOX or other compliance standards

Location - Hyderabad, Pune Experience - 7- 10 Years Notice - Immediate to 15 days Requirements: Should have min 7+ years of experience in Oracle Cloud Technical. Responsible for providing incident resolution, change input and release controls on ORACLE FUSION CLOUD application and all interfaces to this system at second and third line functional level Manage and resolve Incidents and request related to Oracle OTBI, BI and BI Publisher. Update or Review reports causing performance issues. Tune the SQLs for the BI Publisher Reports. Build new reports, dashboards or interactive reports. Bursting through Scheduling or Scheduled Event Triggers. Review and define Data modeling structure. Create and contribute BI Deployment Strategy. Identify solutions for streamlining of business processes in Fusion Application to meet business needs, including functional setups, personalization's, interfaces, customizations, extensions and reports. Participate as technical/Functional contributor on Fusion Application projects to be delivered on time, within budget and with high quality, including our planned enhancement programmer. Actively Participate in weekly Global Team meeting on current issues and escalations.