
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
Prolifics Looking for.NET Core Developer with experience in Web Api Applications
Role:.NET Core Developer.
Location: Hyderabad
Mode of Employment: Permanent
Experience Required: 3 to 8 Years
Primary Skills:
.Net Core, Asp.NetCore Web Application
C#
ROAD
PL/SQL – prefer Oracle experience.
Web API
Regards,
Anil Kumar
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.
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.
- Basic knowledge of Oracle Forms and reports - (Must)
- Good experience on SQL*Loader.
- Should Knowledge on Agile / Scrum.
- Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
- Using SQL developer tool we debugged the code and unit test
- Knowledge of oracle programming
- MySQL, Oracle,
- Knowledge of Unix platform
- PostgreSQL
- advance database knowledge.
- Writing PL/SQL and PL/MySQL
- Coding support
- Debugging & Project module management
- Deployment and fine-tuning as per team lead.
● 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
- - 2+ years experience in application support on Asp.Net and SQL
- - Should be able to debug production issues and bug fixes
- - Should be able to write queries for extracting data using joins
- - Interact with stakeholders and provide regular status updates on call logs to on-site and offshore project co-coordinator
- - Provide daily status updates and time-sheets to on-site and offshore project
- - Ready to work in shifts
- - Knowledge Transfer / Training to stakeholders
Personal Attributes
- - Good communication skills
- - Highly committed and able to work independently and as a team
- - Positive attitude towards learning
- - Deadline orientated and escalate in advance in case of delays
- - Contribute towards improving quality, standardization and documentation for all
- changes & Support activity
- - Ability to remain calm in a fast-paced and highly pressure environment
Job Role – SDE2
Duration – 12 months
Location – HYD
Key Skills:
- 3- 5 years
- Understanding databases and building reports
- Ideal candidate should have experience in Cosmos, Kusto and powerbi
- Mandatory experience in some Database query language(such as SQL)








