
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
• Java 8/12• Frameworks - Spring MVC, REST, Spring Boot, Hibernate, (Optional – Play)• Oracle DB• Elastic Search (Optional but good to have)
• Junit, Mockito• Messaging – Should have knowledge of how RabbitMQ works
• Agile / TDD
• Good Experience in Core-Java concepts
• Experience of Continuous Integration / Continuous Delivery frameworks – Jenkins• Apache, Tomcat
• Good to have basic knowledge in AWS
• Good communication abilities & team-working 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.


The ideal candidate will be familiar with the full software design life cycle. They should have experience in designing, coding, testing and consistently managing applications They should be comfortable coding in a number of languages and have an ability to test code in order to maintain high-quality code.
Responsibilities
- Design, code, test and manage various applications
- Collaborate with engineering team and product team to establish best products
- Follow outlined standards of quality related to code and systems
- Develop automated tests and conduct performance tuning
Qualifications
- Bachelor of Science in Information Technology
- 1+ years of experience working with .NET, Asp.net or relevant experiences
- Experience developing web-based applications in Asp.net, Dot net Core, jQuery, HTML5, Rest base API integration
- Understanding DB,PL/SQL, Webform
- Experience working in agile development environment

- Actively participate in the exchanging of ideas and information within the department
- Participate in rollout of new business system integrations.
- Serve as escalation point for system and troubleshooting issues, assist in resolving production issues.
- Participate in or lead solution design sessions.
- Ability to work effectively under pressure with changing priorities and tight deadlines
- Provide technical advice, code reviews and assistance to other programmers.
- Write complex integration solutions, optimized data extracts, updates and interfaces.
- Interface with functional specialists to ensure solution design and integrity.
- Devise sample input data to test accuracy of program.
- Observe or runs test of program using sample or actual data, assist in user acceptance training.
- Understand and embrace the global IT strategic direction
- Adhere to all safety and health rules and regulations associated with this position and as directed by superior.
- Proactively organize verbal and written ideas clearly and use an appropriate business style
- Be effective and consistent in providing regular updates to appropriate managers
Communication :
- Ask questions; encourage input from team members
- Able to work with and participate within a small multicultural professional team.
- Provide regular updates to appropriate managers
- Confer with reporting manager on complex or unusual situations
- Maintain a thorough knowledge and in-depth field experience regarding emerging or job technologies required to fulfill the job, this could include formal or self paced professional development. Participate in the exchange of ideas and information within the department
- Offer new ideas and suggestions for improvement. Identify and implement new practices and processes that are - best in field-
Requirements:
KNOWLEDGE REQUIREMENTS :
- Experience in analysis, design, coding, and implementation of enterprise integration solutions.
- Experience with webMethods components: Integration Server, Broker, Trading Networks, and SAP Adapter. webMethods 9.x version preferred.
- Experience with RosettaNet PIP's and standards.
- Experience with XML and webservices (SOAP/REST).
- Experience with PL/SQL.
- Experience with FlatFile processing
- General understanding of scalability and high-availability systems.
- Excellent communication/documentation skills
- Experience in system administration a plus.
EDUCATION & EXPERIENCE REQUIREMENTS :
- B.E./B.Tech/M.Tech/MCA
- 3 to 5 years experience in a relevant IT position OR equivalent external work experience
WORKING CONDITIONS :
- Location:
- Travel requirements: Domestic and/or International, up to 10%.
- Climate controlled office environment during normal business hours
● Good knowledge of Dimensional data warehouse systems
● Reporting data models with SSIS and MS SQL Server
● Knowledge on 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
Comes with the opportunity to upskill on Big Data cluster
- 4-8 years of experience in BI/DW
- 3+ years of experience with Microstrategy schema, design and development
- Experience in Microstrategy Cloud for Azure and connecting with Azure Synapse as Data Source
- Extensive experience in developing reports, dashboards and cubes in Microstrategy
- Advanced SQL coding skills
- Hands on development in BI reporting and performance tuning
- Should be able to prepare unit test cases and execute unit testing

The main roles and responsibilities of a Power BI developer are discussed below:
- Power BI development and administration.
- Building Analysis Services reporting models.
- Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
- Connecting to data sources, importing data and transforming data for Business Intelligence.
- Excellent in analytical thinking for translating data into informative visuals and reports.
- Able to implement row level security on data and have an understanding of application security layer models in https://powerbi.microsoft.com/en-us/">Power BI.

- - 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

