Oracle FIN reporting Developer

PwC; Coimbatore District; Hybrid; INR 1,200,000 - 1,800,000; Full time

Job summary

PwC in India is seeking an Oracle Analytics Cloud specialist with 3+ years of experience to design and optimize analytics solutions. You will build and test OAC dashboards, tackle report issues, and support migration from OBIEE to OAC while aligning with data warehousing best practices.

Role requires strong SQL skills, DW concepts, and experience handling datasets from various sources to deliver accurate business insights. This is a professional, full-time opportunity in Coimbatore region.

Qualifications

• Minimum 3 years of experience on Oracle Cloud analytics platforms including OAC/ADW/ODI and/or FAW.
• Hands-on expertise in OAC Analytics, Data Visualization, and Semantic Model Development.
• Experience migrating from OBIEE to OAC and between OAC instances.
• Strong understanding of Data Warehousing concepts and DW modeling.
• Proficient SQL across RDBMS and ability to troubleshoot report errors.

Responsibilities

• Develop and maintain Oracle Analytics Cloud reports and dashboards with calculated measures.
• Test report outputs and ensure accuracy and performance.
• Work on data visualization projects using OAC and datasets from SQL/Excel sources.
• Assist in migrating OBIEE content to OAC and optimize data models for performance.
• Coordinate data flow between ERP systems and the Data Warehouse.

Skills

Oracle Cloud Analytics

OAC/ADW/ODI/FAW

Data Visualization

Semantic Model Development

OAC Reports & Dashboards

Report Testing

OBIEE to OAC Migration

OAC Performance Tuning

SQL Troubleshooting

Data Warehouse Concepts

RPD Modeling

Data Flow ERP to DW

Tools

OBIEE

OAC

ODI

FAW

Job description

Role & responsibilities

• Minimum 3 years of experience on Oracle's Cloud-based analytics platforms including OAC/ADW/ODI and/or FAW.
• Strong hands-on expertise in OAC including Analytics, Data Visualization, and Semantic Model Development.
• Very good development experience in OAC-Reports and dashboards using measures, Filters, calculated measures, calculated items etc Must be able to do Report testing process
• Experience migrating from OBIEE to OAC.
• Experience migrating between OAC Instances.
• Very Good Understanding of DatawareHousing Concepts and Data Warehouse modeling.

• Thorough handson experience on SQL(on any RDBMS Source).
• Able to troubleshoot report errors and issues on OAC.
• Hands On knowledge on Building, Analysis and visualizations based on Datasets created using SQL or Excel Data Sources.
• Good Knowledge on RPD Modeling and Usage of Data modelers on OAC.
• Able to troubleshoot report errors and issues on OBIEE/OAC and understand the tool limitations for OAC.
• Should have experience in performance tuning OAC Analysis, this includes analyzing the Explain Plan of the query, tuning the data model as well as making modifications to the tables such as indexing.
• Should have good knowledge of Coding, Debugging and Design and Documentation.
• Understanding of the flow of data between ERP and Data Warehouse.