Senior Oracle Analytics and BI developer

Job Description

Preferred skills and qualifications 7 or more years of experience in building and delivering analytical applications.BE/BTech or higher degree in Computer Science, Computer Engineering.Excellent knowledge on OBIEE/OAC RPD development.Experience in OBIEE/OAC Reports Dashboard and/or Data Visualization Projects development.Exposure to Data Warehouse design, Star Schema modeling. Build and manage the OAC RPD models to optimize data accessibility and performance. Create dynamic, user-friendly OAC dashboards and visualizations that turn data into insights. Set up alerts and automate data flows to keep business teams informed in real-time. Collaborate on data warehouse design, data pipelines, helping shape how we store and manage data. Use ETL tools (Oracle Data Integrator) to move and transform data, ensuring it s ready for analysis. Have a good broader business understanding and mindset, while technically leading efforts in specific areas. Make effective judgments and choices on design and roadmap based on various considerations. Work with business and technical teams to understand needs and deliver effective OAC solutions. Troubleshoot and solve any issues that come up with data flows, dashboards, or OAC configurations. Stay current with OAC updates and best practices, continually improving our analytics capabilities. Excellent knowledge in development of repository at all the three layers including Physical Layer, Business Model and Mapping Layer and Presentation Layer. Knowledge in creating Logical columns, Hierarchies (Level Based, Parent Child), Measures, Aggregation Rules, Aggregations, Time Series in Business Model and Catalog Folders in Presentation layers. Good Knowledge in security set up for reports and dashboards, and OBIEE administrative activities. Experience on Oracle SQL, database performance tuning by implementing Views, Materialized views, creating indexes. Strong interpersonal and team leadership skills