ERP Specialist

NTT America, Inc.; Dadri; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

NTT America, Inc. is seeking a seasoned Oracle BI developer to design and optimize OBIA and OAC dashboards, reports, and data models. You will translate business needs into efficient SQL and data structures while ensuring secure, scalable solutions.

The role requires hands-on experience with OBIA, OAC, OBIEE, OTBI, and BIP reporting, plus strong RCA skills and collaboration with stakeholders to meet regulatory requirements.

Qualifications

• Hands-on experience with Oracle BI Applications (OBIA) dashboards and data flows.
• Hands-on experience with Oracle Analytics Cloud (OAC) dashboards and data flows.
• Experience with RPD development (logical, physical, presentation layers).
• Translate business requirements into SQL queries and data models.
• Design secure subject areas and implement row-level security.

Responsibilities

• Investigate performance issues related to reports, queries, agents, and data refresh jobs.
• Perform root cause analysis (RCA) and implement permanent fixes.
• Design and develop Oracle BI Publisher (BIP) and OTBI reports/dashboards to meet regulatory reporting requirements.
• Optimize reports for performance and scalability through tuning and efficient data set design.
• Provide production support and user guidance for BIP/OTBI reports.

Skills

OBIA

OAC

RPD development

SQL queries

Dimensional modelling

Performance tuning

Root-cause analysis

BIP/OTBI reporting

Data modeling

Security & row-level access

Report scheduling/bursting

Production support

Communication with stakeholders

Tools

OBIEE

OTBI

Oracle Analytics Cloud (OAC)

BIP

RTF/Excel/XSL templates

Job description

• Hands-on expertise with Oracle Business Intelligence Applications (OBIA) including dashboards, data visualization, and data flows
• Hands-on expertise with Oracle Analytics Cloud (OAC) including dashboards, data visualization, and data flows
• Experience with RPD development (logical, physical, presentation layers)
• Investigate performance issues related to reports, queries, agents, and data refresh jobs.
• Perform root cause analysis (RCA) and ensure permanent fixes and preventive measures.
• Design and develop Oracle BI Publisher (BIP) and OTBI reports/dashboards to meet functional and regulatory reporting requirements.
• Translate business requirements into data models, SQL queries, and report layouts, ensuring accuracy, usability, and performance.
• Build and maintain data models, templates (RTF/Excel/XSL), bursting definitions, and subject areas aligned with Oracle Fusion data structures.
• Optimize reports for performance and scalability, including query tuning, parameterization, and efficient data set design.
• Implement and maintain security, row-level data access, and report scheduling/bursting in line with organizational policies.
• Provide production support, root-cause analysis, and enhancements for existing BIP/OTBI reports, including documentation and user guidance.
• Understanding of dimensional modelling
• Ability to design secure subject areas and implement row-level security
• Experience troubleshooting and optimizing OAC/OBIEE performance
• Strong communication skills to translate business needs into analytics solutions.