Job Summary

The Oracle HR Reports Developer designs and manages enterprise HR reporting and analytics across BIP, OTBI, FDI, and FAW / Lakehouse, turning business requirements into reliable reports, dashboards, data pipelines for global HR, Compensation, Talent, Payroll, and Operations teams.

This role partners with the AI System Architect and HR Technology lead to ensure reporting solutions are accurate, scalable, and governance aligned.

Job Details

- Department: HR Technology
- Reports To: Technical Manager, HR Technology - Platform & Engineering
- Location: Hybrid - India
- Employment Type: Full-Time
- Level: Mid to Senior Individual Contributor
- Platforms: Oracle BIP OTBI Oracle FDI Oracle FAW / Lakehouse

Key Responsibilities

- Oracle BI Publisher (BIP) Design, develop, and maintain BIP reports and templates (RTF, Excel, and eText) for HCM, Talent, Benefits, and Compensation.
- Build and optimize data models, SQL queries, and flexfield-based reporting solutions.
- Configure report bursting, scheduling, and automated distribution.
- Develop regulatory, compliance, audit, and operational reporting extracts.
- Manage BIP catalog governance, security, version control, and environment migrations.
- Oracle Transactional Business Intelligence (OTBI) Develop and maintain OTBI analysis, dashboards, KPIs, and self-service reporting solutions across Oracle HCM modules.
- Design user-friendly analytics using filters, prompts, hierarchical views, and interactive dashboards.
- Govern OTBI content through catalog administration, naming standards, usage audits, and lifecycle management.
- Enable business self-service reporting through user support, training, and best-practice guidance.
- Assess and remediate report impacts resulting from Oracle quarterly releases and subject area changes.
- Oracle Data Intelligence (FDI) Design, develop, and maintain enterprise-grade FDI dashboards, reports, and analytics solutions supporting HR, Finance, Compensation, Talent Management, and Workforce Planning functions.
- Configure and manage FDI subject areas, semantic model extensions (SME), custom calculations, KPIs, dimensions, and measures to meet evolving business reporting requirements.




- Implement and troubleshoot FDI security, including row-level security, data access roles, Area of Responsibility (AOR)-based security, and custom subject-area access controls.
- Develop interactive dashboards, visualizations, drill-through analyses, and executive scorecards for leadership teams and business stakeholders.
- Integrate data from Oracle Fusion HCM, Payroll, Recruiting, Compensation, and Workforce Management modules into unified analytics and reporting solutions.
- Support quarterly Oracle releases, regression testing, validation activities, and production issue resolution for FDI analytics environments.
- Oracle Fusion Analytics Warehouse (FAW) / Autonomous Data Warehouse (ADW) Configure, administer, and optimize FAW environments, including pipeline activation, data synchronization, incremental refresh schedules, and semantic model enhancements.
- Extend the FAW/FDI Lakehouse architecture by ingesting and integrating non-Oracle HR and workforce data sources into Oracle ADW using ODI, OCI Object Storage, APIs, and custom ETL frameworks.
- Develop and maintain custom ADW data models, staging structures, and transformation processes to support advanced reporting and cross-functional analytics.
- Design and publish workforce analytics dashboards covering headcount, attrition, hiring, promotions, compensation, diversity, compliance, and organizational effectiveness metrics.
- Monitor and troubleshoot data pipelines, refresh jobs, synchronization failures, schema changes, and data quality issues across FDI, FAW, ADW, and ODI environments.
- Maintain data governance standards, documentation, lineage tracking, security policies, and audit-compliant access controls across analytics platforms.
- Cross-Platform & Governance Maintain reporting inventory, data classification,



and refresh schedules. Administer row-level security (RLS) and role-based access controls. Support analytics data integration from Boomi, HCM Extracts, and other enterprise sources. Lead regression testing and remediation activities for Oracle quarterly releases. Contribute to HR analytics and AI reporting strategy through continuous improvement and innovation. Maintain technical documentation, data dictionaries, operational procedures, and support runbooks. Provide end-user support, troubleshoot system defects, and promote reporting best practices. Analyze business requirements, identify process improvements, and assess downstream impacts. Serve as a subject matter expert on reporting platforms, data models, and analytics solutions. Mentor, coach, and share knowledge with team members to build organizational capability. Responsible for working on critical defects and product enhancement requests, Production issues.

Required Qualifications

- 5+ years of Oracle HCM reporting and analytics experience in a SaaS environment.
- Hands-on expertise with Oracle BI Publisher (BIP), including data models, SQL, flexfields, bursting, and report development.
- Robust experience designing and maintaining BIP templates (RTF, Excel, and eText).
- Advanced knowledge of OTBI analyses, dashboards, KPIs, and Oracle HCM subject areas.
- Proficiency in Oracle SQL and PL/SQL for reporting, analytics, and data extraction.
- Experience with Oracle FDI, FAW, or Oracle Analytics Cloud (OAC), including dashboard development and semantic modeling.
- Understanding data warehousing concepts, including dimensional modeling and incremental data loads.
- Ability to translate complex business requirements into scalable reporting and analytics solutions.
- Strong analytical, troubleshooting, and data validation skills with a focus on data accuracy and governance.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

📌 Oracle HR Reports Developer (Bengaluru)
🏢 Intelex Technologies ULC
📍 Bengaluru