Associate Staff Engineer (OBIEE/OAS Developer, RPD - Oracle BI Repository)

<p></p><p><b>Job Description </b> </p> <p></p> <p><b>Requirements </b> </p><li>Experience : 4 - 6.5 Years </li><li>Proven experience in OBIEE/OAS involving RPD &amp; Metadata modelling and OBIEE Interactive Dashboards design and development. </li><li>Strong expertise in designing and developing the physical layer, business model and mapping layer, and presentation layers of the OBIEE Repository using the Administration tool. </li><li>Demonstrated ability to implement security at both data level and object level. </li><li>Experience in developing OLAP reports for reporting and ad-hoc query requirements. </li><li>Solid understanding of data normalization and de-normalization, as well as performance tuning techniques. </li><li>Hands-on experience in tuning OBIEE/ODI processes to meet performance requirements for reports. </li><li>Sound understanding of RDBMS concepts, preferably Oracle. </li><li>Expertise in writing advanced Oracle SQL queries, including DML and DDL statements. </li><li>Experience implementing Multi-user development environment structures. </li><li>Familiarity with best practices in DevOps and Agile delivery methodologies. </li><li>Proven track record of high-quality project deliveries and technical achievements. </li><li>Strong analytical and debugging skills with an innovative approach to technology and problem-solving. </li><li>Excellent communication, presentation, and interpersonal skills to effectively engage with stakeholders at all levels. </li><li>Ability to thrive in a rapidly changing and expanding environment. </li><li>Capable of working collaboratively with data analysts, business analysts, database administrators, and business project teams. </li><p><b>Responsibilities </b> </p><li>Design, develop, and implement complex reports and dashboards using OBIEE/OAS, ensuring they meet business requirements and performance standards. </li><li>Collect and analyze implementation requirements from stakeholders and convert them into tangible, actionable deliverables. </li><li>Develop reports, charts, and dashboards with various views using OBIEE presentation services, tailoring outputs to user needs. </li><li>Manage and maintain the OBIEE Repository, including the physical, business model, mapping, and presentation layers, to support evolving data structures and business rules. </li><li>Apply security configurations effectively at both data and object levels to ensure appropriate access controls. </li><li>Optimize report performance through data normalization, de-normalization, and performance tuning techniques across OBIEE and ODI processes. </li><li>Write and maintain advanced Oracle SQL queries for data extraction, manipulation, and definition as part of development and troubleshooting activities. </li><li>Collaborate within a multi-user development environment, ensuring version control and consistent practices across the team. </li><li>Adhere to DevOps and Agile delivery practices, contributing to continuous improvement in development workflows. </li><li>Troubleshoot and resolve issues related to reporting, data integrity, and system performance, applying strong analytical and debugging skills. </li><li>Communicate effectively with technical and non-technical stakeholders, translating complex technical concepts into clear business language. </li><li>Adapt to changing priorities and project requirements, maintaining a high standard of delivery in a dynamic environment. </li><li>Support the overall data warehouse strategy by working closely with cross-functional teams to ensure reporting solutions align with organizational goals. </li><p></p><p><b>Qualifications </b> </p> <p></p><p>Bachelor’s or master’s degree in computer science, Information Technology, or a related field. </p>