Arcturus Consulting Services

Oracle OTBI / BI Publisher Consultant

India full-time Mid Salary not listed
full-time Mid level Technology & IT Curated
Sign in to apply Free account — we bring you straight back to this role.

About the role

This is a remote position.

JOB DESCRIPTION
We are seeking an experienced Oracle OTBI / BI Publisher Consultant with strong expertise in developing custom OTBI analyses, dashboards and BI Publisher reports in Oracle Fusion applications. The candidate should have experience in reporting, data modelling, SQL queries and report customization.

Key Responsibilities:

Design, develop and customize Oracle Transactional Business Intelligence (OTBI) analyses.

Develop interactive dashboards and reports based on business requirements.

Create and maintain BI Publisher (BIP) reports.

Develop data models, data sets and report templates.

Write and optimize SQL queries for reporting requirements.

Work with Oracle Fusion ERP, SCM and HCM reporting requirements.

Perform report testing, validation and troubleshooting.

Enhance existing reports and improve reporting performance.

Work closely with functional teams to understand reporting requirements.

Support report deployment, maintenance and production issues.

REQUIREMENTS
Required Skills:

Strong hands-on experience with Oracle OTBI.

Expertise in BI Publisher (BIP) report development.

Experience creating custom analyses and dashboards.

Strong SQL and data modelling knowledge.

Experience with Oracle Fusion reporting and data structures.

Knowledge of BI Publisher data models, templates and scheduling.

Experience in report customization and performance optimization.

Preferred Skills:

Experience with EBS-to-Oracle Fusion report migration.

Knowledge of Oracle Fusion ERP, SCM and HCM modules.

Experience with Oracle Analytics Cloud (OAC).

Understanding of Oracle Fusion security and reporting roles.

Qualifications:
Bachelor's degree in Computer Science, Information Technology or a related field.

Location: PAN India / Remote

Originally posted on Himalayas

Interview prep

Walk in with sharper answers.

Use this as a quick practice sheet before you speak with the employer.

Mid
Technology & IT Data Analysis MySQL Remote Collaboration SQL Mid level full-time

Likely questions

  1. Tell us about work you have done that is close to the Oracle OTBI / BI Publisher Consultant role.
  2. How would you approach your first 30 days at Arcturus Consulting Services?
  3. Which of Data Analysis, MySQL and Remote Collaboration have you used recently, and what did it help you achieve?
  4. Describe a time you solved a problem without waiting to be told exactly what to do.
  5. How do you handle busy days, changing priorities, or pressure at work?

Prepare before the call

  • A recent example that proves your experience with Data Analysis, MySQL and Remote Collaboration.
  • One short story with a problem, your action, and the result.
  • Two examples that show the strengths listed on your CV.
  • A clear reason why this role and company interest you.
  • Your availability, preferred work style, and salary expectations.

Ask them

  • What would success look like in the first 90 days?
  • What are the main problems this hire should help solve?
  • How does the team give feedback and measure good work?
  • What does a normal working week look like for this role?
Practice line

I am interested in the Oracle OTBI / BI Publisher Consultant role because I can bring practical experience in Data Analysis, MySQL and Remote Collaboration, learn the team quickly, and contribute to the outcomes Arcturus Consulting Services needs from this hire.

Related jobs.

More roles from this company or category.