Oracle FIN reporting Developer

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.