Job Description
The role involves designing, developing, optimizing, and maintaining enterprise reporting and analytics solutions, collaborating with business stakeholders, and leveraging modern development practices including cloud technologies, automation, and AI-assisted development tools
Required Technical Skills
- The ideal candidate should have 5–8 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.
Responsibilities
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.
Qualifications
Career Level - IC3
About Us
Only Oracle brings together the data, infrastructure, applications, and expertise to power everything from industry innovations to life-saving care. And with AI embedded across our products and services, we help customers turn that promise into a better future for all. Discover your potential at a company leading the way in AI and cloud solutions that impact billions of lives.
True innovation starts when everyone is empowered to contribute. That's why we're committed to growing a workforce that promotes opportunities for all with competitive benefits that support our people with flexible medical, life insurance, and retirement options. We also encourage employees to give back to their communities through our volunteer programs.
We're committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know by emailing [Confidential Information] or by calling 1-888-404-2494 in the United States.
Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.
