BI Developer

OSI Digital, Inc.; Hyderabad; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

OSI Digital, Inc. in Hyderabad is seeking an experienced BI Developer with 5+ years to design, develop, and maintain enterprise analytics solutions using Oracle Analytics Server (OAS) and related tools.

Collaboration with business stakeholders and onsite leads is required. The role covers semantic modeling (RPD), dashboarding, ETL integrations (ODI, GoldenGate), data warehousing concepts, and performance tuning.

Qualifications

• 5+ years of hands-on OAS/OAC/OBIEE experience.
• Strong repository (RPD) development and semantic modeling skills.
• Proficiency in SQL and Oracle database performance tuning.
• Experience with ODI and Oracle GoldenGate for ETL/integration.
• Data warehousing concepts including star schemas and dimensional modeling.
• Experience supporting production incidents and ticketing systems (Jira/ServiceNow).

Responsibilities

• Design, develop, and maintain OAS reports, dashboards, and dataflows.
• Build and optimize semantic models across layers (Physical, BMM, Presentation).
• Implement Writeback and manage OAS reports, bursting, and templates.
• Develop and troubleshoot ETL pipelines using ODI/GoldenGate.
• Write advanced SQL and perform data discrepancy analysis.
• Provide production support and incident management via Jira/ServiceNow.
• Handle deployments and migration documentation across environments.
• Collaborate with onsite leads and stakeholders to gather requirements.

Skills

OAS/OAC/OBIEE

RPD Development

DV/BI Publisher

SQL & Oracle

ETL & Data Integration

Data Warehousing

Strong communication

Tools

ODI

Oracle GoldenGate

Redshift

Oracle Database

Jira

ServiceNow

BI Publisher

Job description

About Role

We are seeking an experienced and self-driven

Role: BI Developer

Experience : 5+ Years

Location: Hyderabad

About Role

We are seeking an experienced and self-driven Oracle Analytics Server (OAS) Developer with 5+ years of hands-on expertise in building end-to-end analytics solutions, semantic modeling, report development, and ETL integrations. The ideal candidate will possess deep technical knowledge of OAS/OAC/OBIEE, strong database skills (Oracle and Amazon Redshift), and experience with data integration tools such as Oracle Data Integrator (ODI) and Oracle GoldenGate. In this role, you will work closely with business stakeholders, cross-functional teams, and onsite leads to design, develop, maintain, and troubleshoot enterprise reports, dashboards, and underlying data pipelines.

Key Responsibilities

• Analytics & Visualization: Design, develop, and maintain OAS Classic Reports, Interactive Dashboards, Workbooks, Datasets, and Dataflows within Data Visualization (DV).
• Semantic Modeling: Build, enhance, and troubleshoot RPD/Semantic Models across Physical, Business Model & Mapping (BMM), and Presentation layers.
• Advanced OAS Features: Implement and maintain OAS Writeback functionality and manage complex BI Publisher reports, templates, and bursting definitions.
• ETL & Data Integration: Maintain, optimize, and troubleshoot ETL data pipelines (using tools like ODI, Oracle GoldenGate, or similar) to ensure seamless, reliable data flow from source systems into the Data Warehouse and reporting layers.
• Query & Data Troubleshooting: Write advanced SQL queries and perform root-cause analysis to resolve data discrepancies between source systems, staging areas, and OAS reports.
• Production Support & Incident Management: Provide tier-2/tier-3 application and production support through Jira and ServiceNow, addressing user access issues, security configurations, report failures, and performance bottlenecks.
• Deployment & Governance: Handle object migrations and deployments across environments (Dev, QA, Prod), maintain thorough migration documentation, and ensure compliance with governance standards.
• Stakeholder Engagement: Collaborate directly with business analysts, onsite leads, and end-users to gather requirements, conduct UAT, and resolve reporting incidents.

Required Skills

• Core OAS/OAC Expertise: 5+ years of hands-on experience with Oracle Analytics Server (OAS), Oracle Analytics Cloud (OAC), or OBIEE.
• Semantic Model / RPD Development: Deep expertise in repository (RPD) development, including complex join strategies, logical columns, variables, security filters, and performance tuning.
• Reporting & Data Visualization: High proficiency in OAS Classic, Data Visualization (DV), BI Publisher, Bursting, and Writeback configurations.
• SQL & Database Proficiency: Strong SQL querying, tuning, and troubleshooting skills on Oracle Database and Amazon Redshift.
• ETL & Integration Experience: Hands-on experience or familiarity working with ETL/ELT tools, specifically Oracle Data Integrator (ODI), Oracle GoldenGate, or equivalent data integration platforms.
• Data Warehousing & Modeling: Solid grasp of core Data Warehousing concepts, including Dimensional Modeling, Fact/Dimension tables, and Star Schema designs.
• Support & Ticketing Systems: Proven experience troubleshooting production incidents, user permissioning/security, and tracking SLAs via ServiceNow and Jira.
• Deployment & Process: Experience documenting migration paths, preparing release notes, and promoting code across multi-tier deployment environments.
• Experience developing, tuning, and troubleshooting data integration and real-time replication pipelines involving Amazon Redshift and Oracle GoldenGate.
• Expertise in writing custom ODI interfaces/mappings, knowledge modules, and package orchestrations.
• Strong communication skills with prior experience directly supporting business/onsite users.