Oracle Federal Financials Developer

Industry: Information Services


Not Specified years

Posted 361 days ago

Optimal Solutions & Technologies (OST, Inc.) is focused on excellence. We specialize in providing Management Consulting, Information Technology, and Research Development and Engineering services. OST is one of an elite set of companies worldwide to be externally appraised CMMI Level 5.   The fundamental distinction of the OST team is its business knowledge in both the public and private sectors. We serve the aerospace & transportation, association & nonprofit, defense, education, energy, financial, healthcare, and technology & telecommunications industries. OST is successful because we listen to our clients, we learn from our clients, and we know our clients.   Description of specific Duties in a typical workday for this position:

  • As an Oracle OBIEE developer you will participate as a team member in the development/customization of Oracle OBIEE for HR, Financials, Procurement and Projects.
  • Participate in the design and development of customizations to the ETL, DAC, and RPD to enhance the delivered reports in HR, Financials, Procurement and Projects. Provide hands on support for Oracle OBIEE environment. Design and implement the integration of Custom data sources with the OBIEE data warehouse.

  Position Requirements:

  • Expert technical knowledge of Oracle BI Architecture
  • Expert working knowledge and experience with ETL/Data integration using Informatica
  • Expert working knowledge of OBIA, DAC, OBIEE
  • Expert Oracle SQL, and PL/SQL skills
  • Expertise in performance tuning in Pl/SQL and OBIEE
  • Expert data warehouse design & build experience including star schema and data modeling
  • Knowledge of key metrics and reports included in the packaged applications and the data fields supported by OBIEE and source system(s)
  • Experience designing and developing ETL strategies
  • Experience with Oracle Data Integrator tool
  • Experience with OBIEE modeling layers including presentation, logical, and physical Mapping Data Elements from various data sources
  • Experience loading DW objects including dimensions, hierarchies, fact tables, aggregates
  • Experience building the Reporting Metadata layer and the Reports 
    Proven Data Warehouse/Business Intelligence professional
  • Excellent organizational, communication & documentation skills with high attention to detail
  • Experience in systems analysis, design and a solid understanding of development, quality assurance and integration methodologies
  • Requires a solid foundation with Oracle ERP 12, Oracle relational databases, PL/SQL, and Oracle reports
  • BachelorDegree
  • Active Public Trust clearance or ability to obtain one
  • US Citizen