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
- 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
- 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