Oracle Fusion HCM BI Reporting at IT Company · Bengaluru (Bangalore) · 7 - 10 years · ₹5L - ₹15L / yr (ESOP available) · Posted 15 Jan 2021
Reporting and Business Intelligence
Minimum of 8 to 10 years of experience in Report building and Business Intelligence with
Profound knowledge on Oracle BI Publisher and BI Analytics with Oracle Fusion HCM domain especially in Core HR, Payroll and Absences modules
Primary skill:
- Experience generating BI publisher reports, dashboards and drill-down reports
- BI Publisher (RTF design/ eText/ Scheduling/ Parameter Handling/Bursting/backup and migration of reports to different pods)
- Design Oracle BI Publisher Data Models, Data sets and Templates/sub-templates
- Strong PL/SQL and Advanced PL/SQL experience
- Solid understanding of performance tuning best practices and experience improving end-to-end processing times
- Knowledge on the data models related to Fusion HCM (Core HR, Absence and Payroll modules)
Nice to have skills:
- Experience generating BI publisher reports, dashboards and drill-down reports
- Strong OBI Administrator activity
- Create mobile applications with Oracle Business Intelligence Mobile App Designer
- Use BI Mobile to access BI Content
- Create and modify Interactive Dashboards
- Knowledge of additional reporting tools viz. HCM Extract / OTBI / Analysis Dashboard would be an added advantage
Behavioural and Process Skills
- Experience working in Agile teams
- Self-motivated and self-directed abilities to prioritize and execute tasks in a high-pressure environment with "time-critical" deadlines
- Proven analytical, evaluative, and problem-solving abilities
- Possesses a team and customer service provision orientation

Similar jobs (10)
Oracle Apex Developer:
- No. of Position: 3
- Budget: 12 - 16 LPA all inclusive depending on experience bracket
- Work Location – For Mumbai candidate it will be Mahape - Navi Mumbai; candidates from Pan India who are not ready to relocate can permanently WFH.
- Joining Time – Immediate to 45 Days
- US Client – Long term logistics domain project
- Opportunity to work with a team of 20+ Apex experts on the latest Apex technologies in the market
- Onsite opportunity for tenured employees
Experience:
- 5-8 years’ experience in Oracle PL SQL & Oracle Apex; (Majority of Oracle Apex experienced required)
- Preferred Education: B. Tech / B. E - Any Specialization, Computers (OR) BCA (AND/OR) MCA
Core Competencies:
- Experience working on Oracle PL/SQL Programming and DB features
- Proficient in Oracle Apex components is a must
- Experience in Javascript, Jquery and CSS
- Knowledge of Page zero concept, shared components, Page rendering & processing, Interactive reports
- Exposure to DBA activities like Table space management, Export/Import etc.
- Experience in Unix Shell scripting
- Exposure to any reporting tool
- Good communication skills
- Ability to take responsibility and handle pressure
- Ability to think creatively and solve complex problems
- Self-motivated, fast learner with the ability to operate independently
- Team player with strong interpersonal skills and a willingness to help others
- Ability to thrive in a cross-functional team on business-critical projects
- Intrinsically cares about the quality of work
- Organized and focused on delivering tasks within defined deadlines
Specific Responsibilities:
- Would work in design, develop, enhance, test and maintain software applications
- Design and develop SQL scripts, stored procedures, packages, parameterized queries and objects using tools like Toad, SQL Developer, Pl/SQL developer
- Build and maintain Application database schema/objects and account for data migration/upgrades across versions
- Identify and automate routine maintenance tasks
- Optimizing DB queries, stored procedures, Data structures, Indexes and DB Normalization.
- Certify all queries written by software developers to ensure optimal execution of the queries
- Research, investigate and evaluate potential database solutions to business problems/requirements
- Write Test cases for developed queries/functions using PLSQL and Quest code tester.
according to our company’s needs. You will be responsible for planning, developing,
testing, improving and maintaining new and existing databases to help users retrieve
data effectively. As part of our IT team, you will work closely with developers to ensure
system consistency. You will also collaborate with administrators and clients to
provide technical support and identify new requirements. Communication and
organization skills are keys for this position, along with a problem-solution attitude.
You get to work with some of the best minds in the industry at a place where
opportunity lurks everywhere and in everything.
Responsibilities
Your responsibilities are as follows.
• Working cross functional teams to develop robust solutions aligned with the
business needs
• Maintaining communication, providing regular updates to the development
team ensuring solutions provided are fit for purpose
• Training other developers in the team on best practices and technologies
• Troubleshooting issues in the production environment understanding the root
cause and developing robust solutions
• Developing, implement, maintain and solutions that are both reliable and
scalable
• Capture data analysis requirements effectively and represent them formerly
and visually through our data models.
• Maintaining effective database performance by identifying and resolving
production and application development problems
• Optimise the integration and installation of new releases
• Monitoring system performance, test, troubleshoot and integrating new
features
• Proactively recommending solutions to improve new and existing database
systems
• Providing database support by coding utilities, resolving user questions and
problems
• Ensuring compliance to database implementation procedures
• Performing code and design reviews as per the code review process
• Installing and organising information systems to guarantee company
functionality
• Preparing accurate documentation and reports
• Migration of data from legacy systems to new solutions
• Stakeholders’ analysis of our current clients, company operations and
applications, and programming requirements
• Collaborate with functional teams across the business to deliver end-to-end
products, features enabling enhanced performance
Required Qualifications
We are looking for individuals who are curious, excited about learning, and navigating
through the uncertainties and complexities that are associated with a growing
company. Some qualifications that we think would help you thrive in this role are:
• Minimum 8 Years of experience as a Database Administrator
• Strong knowledge of data structures and database systems
• In depth expertise and hands on experience with MySQL/MariaDB Database
Management System
• In depth expertise and hands on experience in database design, data
maintenance, database security, data analysis and mining
• Hands-on experience with at least one web-hosting platform such as Microsoft
Azure, AWS (Amazon Web Services) etc.
• Strong understanding of security principles and how they apply to web
applications
• Basic knowledge of networking, Desirable knowledge of business intelligence
• Desirable knowledge of data architectures related to data warehouse
implementations
• Strong interpersonal skills and a desire to work collaboratively to achieve
objectives
• Understanding of Agile methodologies
• Bachelor/Masters of CS/IT Engineering, BCA/MCA, B Sc/M Sc in CS/IT
Preferred Qualifications
• Sense of ownership and pride in your performance and its impact on company’s
success
• Critical thinker, Team player
• Excellent trouble-shooting and problem-solving skills
• Excellent analytical and Strong organisational skills
• Good time-management skills
• Great interpersonal and communication skills
Work Details: approx. 3-4 Months of development work and require support for next 3 months.
Job Role:
The selected professional/company will be responsible for:
- Understanding our software's API structure and Oracle SOA framework.
- Developing and implementing API integrations to connect our software with the specified Oracle SOA modules.
- Ensuring seamless functionality and data synchronization between systems.
- Performing rigorous testing to validate the integrations.
- Providing ongoing support, troubleshooting, and resolving any issues during and after the integration process.
- Setup the Development/UAT environment for the Oracle SOA integrations.
Modules to Integrate:
- Purchasing
- Payables
- Supplier
- Inventory
- General Ledger (GL)
Scope of Work:
- API Integration: Establish seamless integration of APIs between our software and the above-mentioned Oracle SOA modules.
- Data Flow & Functionality: Ensure smooth data flow and consistent functionality between systems.
- Support & Troubleshooting: Provide support and resolve any issues arising during the integration process.
- Relevant Experience: Demonstrate prior experience with Oracle SOA integrations.
We are looking for professionals or organizations capable of delivering on these requirements effectively.

Job Description:
- To resolve the tickets raised as per the defined standards of time, cost, and quality for increased customer satisfaction.
Skills and Experience
- Good SQL & PLSQL knowledge.
- Good Unix basic commands knowledge.
- Good Unix scripting knowledge will be an advantage.
- ANSI SQL
- Unix - Others/
- Experience - Fresher
We are looking for a Java Developer with experience in building high-performing, scalable, enterprise-grade applications. . You'll be required to apply your depth of knowledge and expertise to all aspects of the software development lifecycle, as well as partner continuously with your many stakeholders daily to stay focused on common goals You will be part of a talented software team that works on mission-critical applications
Responsibility
- Write automated test cases to test code.
- Excellent teamwork skills with an ability to get the work done with minimal
- Experience with multiple mobile platforms is a plus.
- A passion and will to accept any new technical challenge that may come across.
- Linux scripting and SSH terminal
- Conceptual, Working knowledge of - DBMS, SQL, PL/SQL.
- Ability to write clean and documented code.
- A team player can provide technical expertise for a small team of developers.
- Strong hands-on and experience in core Java - Java/J2EE
- Design and implement new features, create UI, debugging, and data modeling.
- To update and sync with other team members daily.
- Ability to communicate effectively, both written and oral, at all levels to various technical and non-technical audiences
- Testing all applications against software and hardware versions. Provide timely turnaround and documentation of things implemented.
Additional preferred skills * JSP/Servlets OR JQuery/HTML5 AND JavaScript
Requirements:-
- Working knowledge of - MySQL.
- Working experience on Struts/Spring.
- Experience with web services standards and related technologies - SOAP/Rest, AJAX, JSON, and XML.
● Good knowledge of Dimensional data warehouse systems
● Reporting data models with SSIS and MS SQL Server
● Knowledge of all aspects of BI preferably data modeling, data
● integration, data analysis, and reporting
● Good working knowledge of MS Azure environment
● Knowledge of BI tools like Tableau or PowerBI
● Good communication skills
- Hands on Java experience with minimum 8 yrs. More experience is a plus but need to be hands on.
- Server side programming experience with technologies: Spring, Hibernate & Swing is a plus
- Good DB knowledge, hands on PL/SQL or T-SQL
- Experienced to work on Linux, git, IntelliJ, Eclipse
- Experience of designing and developing end-to-end solutions.







