ERP Specialist

NTT DATA, Inc.; Dadri; Sur place; INR 1 800 000 - 3 000 000; Plein temps

Résumé du poste

NTT DATA, Inc. in India seeks a seasoned Oracle BI professional to design and optimize OBIA and OAC dashboards, data visualizations, and data flows. You will translate business needs into robust data models and reports, ensuring performance and security.

The role involves developing BIP/OTBI reports, tuning queries, and providing production support with clear documentation. Collaboration with stakeholders to meet regulatory reporting requirements is essential.

Qualifications

• Hands-on experience with OBIA dashboards and data flows.
• Hands-on experience with Oracle Analytics Cloud dashboards and data workflows.
• Experience in RPD development across logical, physical, and presentation layers.
• Ability to design secure subject areas with row-level security.
• Proficient in SQL queries and data modeling for reporting.
• Experience optimizing OBIEE/OAC performance and report scheduling.

Responsabilités

• Translate business requirements into data models, SQL queries, and report layouts.
• Design and develop BIP and OTBI reports/dashboards to meet reporting needs.
• Investigate performance issues related to reports, queries, agents, and data refresh jobs.
• Provide RCA and implement permanent fixes and preventive measures.
• Provide production support and enhancements for existing reports, including documentation and guidance.
• Implement and maintain security and row-level data access.
• Build and maintain data models and templates (RTF/Excel/XSL) and bursting definitions.
• Optimize reports for performance and scalability.

Connaissances

OBIA

Oracle Analytics Cloud

RPD development

SQL queries

Dimensional modelling

Row-level security

BIP/OTBI reports

Performance optimization

Data visualization

Reporting scheduling/bursting

Data modeling

Data security

Root cause analysis

Troubleshooting OBIEE/OAC

Communication skills

Outils

OBIEE

Oracle BI Publisher

OTBI

Oracle Fusion data structures

Excel

Description du poste

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