Oracle Technical Financial Developer

SDH Systems LLC

Posted 5 years ago

Job Title: Oracle Technical Financial Developer
Location:Oklahoma City, OK 73169
Duration: 3 Years
Work Schedule: Full Time
Salary: $73,715.00/Annum + Company Standard Benefits
Job Duties:

  • Design and development of the three layers (Physical/Business Model and Mapping/ Presentation)of an OBIEE Metadata Repository (.rpd)using Oracle BI Administration Tool.
  • Working with OBIEE administration tool developing Metadata repository and OBIEE dashboards.
  • Responsible to configure OBIEE Metadata Objects including repository, variables, interactive dashboards, and reports.
  • Design customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.
  • Utilize OBIEE Answers to create SQL queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
  • Working with Variable Manager to define session and repository variables and initialization blocks to streamline administrative tasks and modify metadata content dynamically.
  • Proficient in Installation, configuration, and administration of the OBIEE platform.
  • Develop Dimensional Hierarchies, Level Based Measures, and adding multiple sources to business model objects.
  • Working on database Design, Creating DDL scripts, Normalization of design and writing complex queries / DML statements, familiarity with tools like TOAD, SQL Developer etc.
  • Define tables and their relations, views, triggers, constraints and stored procedures to the business requirements.
  • Working on Data migration using import and export and writing procedures, functions, views, materialized views as required.

Minimum Qualification: Bachelor’s degree in computer science, computer information systems, information technology, or a
combination of education and experience equating to the U.S. equivalent of a bachelor’s degree in one of the aforementioned subject.

Apply Online