OBIEE Developer

27 Oct 2024

Vacancy expired!

We are seeking an experienced

OBIEE Developer to assist the Organization in upgrading Oracle Business Intelligence from

11.1.10.2 to 11.1.1.10.3 and troubleshooting performance issues of

OBIEE environment.

Position Responsibilities:
  • Responsible for the delivery of the DW/BI project and developing the solution architecture for the project.
  • Support for the complete

    OBIA upgrade from 11.1.10.2.to 11.1.1.10.3
  • Support the upgrade process for development, test, user acceptance testing, and production environments
  • Fix any issues with the HR analytics interface
  • Validate, test, and fix any errors of the

    Oracle Data Integrator (ODI) ETL errors from source to target migration Support the migration

    ODI packages from one environment to another
  • Coordinate with the implementation partner and business functions to finalize the requirements and deliver them in a timely manner
  • Responsible for setting up the necessary infrastructure for the project and coordinating with various departments in IT for the interfacing requirements for developing the necessary extractions from source systems.
  • Leveraging BI Server Caching to get most benefits out of the Cached queries and return the same result without hitting the database multiple times.
  • Removing Snowflake across dimensions and create the Foreign Key for each Dimension into Fact to create Star model, where applicable
  • Applying Bitmap Index for all Foreign Key columns, and Bitmap Join Index
  • Ensuring that the RPD is in sync with the database to avoid full outer joins
  • Optimizing setting of NQSConfig.INI parameters such as sort memory size, sort buffer increment size, etc.
  • Managing optimally some key values like maximum session limit, and database and server execution

Position Requirements;
  • Over 10 years of professional experience with significant focus on

    Oracle Middleware specifically with

    OBIEE, OBIA technologies.
  • Sound knowledge and experience with

    DW and BI infrastructure and architecture
  • Solid experience with data loading, schedule and monitor workflows/jobs, and dimensional modelling using Star schema in Data warehouse life cycle.
  • Hands on experience on metadata modeling Architecting BI/DW projects, configuring Data Warehouse Administration Console (DAC),

    Informatica ETL Process
  • Hands-on experience in using

    SQL, PL/SQL, Oracle Stored Procedures, Packages and Object types to meet data integration and processing requirements.
  • Experience in handling Third party tools such as SQL Developer, SQLLoader and Toad.
  • Knowledge on database design – Creation of data model, Tables, Indexes, Views, Materialized views, Synonyms, Sequences for better performance of the database.
  • Has Good knowledge on

    Oracle Data integrator, Oracle ADF and BI Publisher.
  • Fluency in SQL and dimensional modeling concepts
  • 7+ years of experience in

    Oracle Fusion Middleware Administration
  • Middleware Certification is preferred
  • Ability to work closely with business partners, and project manager
  • Possess strong oral and written communication skills
No Phone Calls PleasePlease send us your resume in a word file with contact details

  • ID: #21744696
  • State: District of Columbia Washington 00000 Washington USA
  • City: Washington
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2021-10-27
  • Deadline: 2021-12-20
  • Category: Et cetera