
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
We're Hiring Module Lead Oracle D2k
Location: Gurgaon, India
Experience Level: C2
Job Type: Full-time
Job Description:
- Design and develop custom Oracle Forms and Reports applications.
- Perform technical architecture design and document system requirements, processes, data flow, and message/interface designs.
- Develop Oracle SQL and PL/SQL scripts to meet business requirements.
- Review and optimize existing code, ensuring adherence to best practices and standards.
- Collaborate with internal teams to understand software issues and recommend solutions.
- Conduct Proof-of-Concepts (POCs) to evaluate new technologies or innovative ideas.
- Provide regular updates to the IT team and stakeholders, ensuring smooth project execution.
- Contribute to the development of API interfaces using Swagger and manage API security, authorization, and access control.
- Maintain thorough documentation throughout the development lifecycle.
Key Skills & Experience:
- Hands-on experience in designing, developing, and delivering Oracle Forms/Reports (12c).
- Strong knowledge of Oracle SQL and PL/SQL for database-driven application development.
- Experience with Oracle Database 19c and Unix shell scripting.
- Familiarity with Oracle REST Data Services (ORDS).
- Proficiency in API design and Swagger documentation; understanding of API security and access control.
- Knowledge of DevOps tools and experience with JIRA is a plus.
- Exposure to Java programming will be an added advantage.
- Strong communication and leadership skills, with a track record of working collaboratively with cross-functional teams.
• 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

Job Description:
7+ years of experience as a Techno-Functional specialist supporting a finance organization with an emphasis on project management.
Must have 2-3 Project implementation and more than one support experience in Oracle EBS R12.
Expert level knowledge of Oracle Applications Framework, Oracle Workflow, Oracle Forms, Oracle Report, XML Report, PLSQL
Functional knowledge in financial module like, GL,AP, AR PO, Project is must Extensive use of oracle APIs and interfaces Experience in performance tuning of the code Experience in shell scripting.
Worked on Oracle Alert, AME, OAM ,DFF etc Good to have ADF experience Good to have ORDS experience Good to have exposure in cloud technology.
Responsibilities:
Act as a senior liaison between Business partners and IT communities Facilitate cross-functional teams through business process and application initiatives from requirements definition to prototyping, design, development, testing, training, and deployment.
Create technical designs to support business requirements.
Lead the development of technical solutions. Communicate project status and escalate issues to management. Develop and execute system test plans and scenarios.
Assist in preparing training materials for deployment of applications, modules, enhancements and bug fixes.
Assist in developing baseline datasets and reports to support testing of technical solutions.



Skill for BI Backend developer -
-SQL development (Snowflake preferred but any other version of SQL would work)
- ETL
- Stored Procedures
- Creating jobs and work flows in SQL
- some business knowledge
- 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 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
● 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
- 7 years of hands-on experience on database development
- Very strong and hands-on in Oracle Database and PL/SQL development
- Hands on experience in designing solutions and developing for data migration projects using Oracle PL/SQL
- Experience with Oracle Argus Safety, ArisG and other Safety/Clinical systems
- Working experience in development of ETL process, DB Design and Data Structures
- Excellent knowledge of Relational Databases, Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based) , Object type, Stored Procedures, Functions, Packages and Triggers, Dynamic SQL, Set transaction, pl/sql Cursor variables with Ref Cursor
Excellent written and verbal communication skills
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)

