06 Aug
|
Oracle
|
Bengaluru
We are looking for an experienced Oracle Analytics & BI Developer with strong expertise in Oracle Database, PL/SQL, SAP BusinessObjects/Tableau, and modern cloud-based analytics platforms. The ideal candidate should possess deep technical knowledge in designing enterprise reporting solutions, semantic modeling, performance optimization, and analytics development while working with large-scale enterprise data platforms.
The role involves designing, developing, optimizing, and maintaining enterprise reporting and analytics solutions, collaborating with business stakeholders, and leveraging up-to-date development practices including cloud technologies, automation, and AI-assisted development tools.
Key Responsibilities
- Design, develop, and maintain enterprise reporting and dashboard solutions using Oracle Analytics Cloud (OAC), SAP BusinessObjects, and Tableau.
- Develop interactive dashboards, pixel-perfect reports, scorecards, and analytical visualizations for business users.
- Design and maintain semantic models, including Physical, Business/Logical, and Presentation layers.
- Build reusable enterprise data models and subject areas to support self-service analytics.
- Develop and optimize Oracle SQL and PL/SQL packages, procedures, functions, triggers, and views.
- Perform SQL query tuning and database performance optimization for large datasets.
- Analyze execution plans and improve report performance through indexing, partitioning, and efficient SQL design.
- Perform impact analysis for database, reporting, metadata,
and configuration changes.
- Troubleshoot complex production issues, perform root cause analysis, and implement permanent fixes.
- Create technical documentation, knowledge articles, solution designs, and operational runbooks.
- Collaborate with business analysts, architects, DBAs, and cross-functional teams to translate business requirements into technical solutions.
- Follow secure coding standards, coding best practices, and enterprise governance processes.
- Support release management, deployment activities, and production support.
Required Technical Skills
- The ideal candidate should have 5–10 years of hands-on experience in SAP BusinessObjects (BI 4.x) , including Web Intelligence (WebI), Crystal Reports, Universe Design (UDT/IDT), semantic layer modeling, and enterprise report/dashboard development .
- Strong expertise in Oracle Database, SQL, and PL/SQL with experience in query optimization, performance tuning, stored procedures, packages, functions, triggers, and impact analysis is essential.
- Exposure to Oracle Analytics Cloud (OAC) and/or Tableau is preferred.
- Candidates should possess working knowledge of Python or Java , REST APIs, scripting/automation, Oracle Cloud Infrastructure (OCI) , Git, and Agile development practices.
- Familiarity with AI-assisted development tools such as GitHub Copilot, Claude, Codex, or ChatGPT for coding, debugging, documentation, and productivity enhancement will be an added advantage.
📌 SAP Business Objects Developer (Bengaluru)
🏢 Oracle
📍 Bengaluru