Post job
zippia ai icon

Automatically apply for jobs with Zippia

Upload your resume to get started.

Senior obiee developer skills for your resume and career

Updated January 8, 2025
4 min read
Below we've compiled a list of the most critical senior obiee developer skills. We ranked the top skills for senior obiee developers based on the percentage of resumes they appeared on. For example, 13.3% of senior obiee developer resumes contained interactive dashboards as a skill. Continue reading to find out what skills a senior obiee developer needs to be successful in the workplace.

15 senior obiee developer skills for your resume and career

1. Interactive Dashboards

Here's how senior obiee developers use interactive dashboards:
  • Created Interactive Dashboards using filters and with drill-down capabilities appropriately to avoid excessive data.
  • Developed interactive dashboards, defined prompts as columns and presentation variable.

2. Presentation Layer

Here's how senior obiee developers use presentation layer:
  • Involved in modifications of physical, business and presentation layers of metadata repository using OBIEE Administration Tool.
  • Customized the Physical, Business and Presentation layers using Oracle Business Intelligence Administration tool.

3. ETL

Here's how senior obiee developers use etl:
  • Involved in identifying bottlenecks/errors and troubleshooting ETL related issues.
  • Worked closely with ETL team to have the good mappings and missing columns to be created in the database we use.

4. Informatica

Informatica is a cloud data management that provides data integration and transformation. This is an ETL extract, transform and load tool that helps connect and retrieve data from multiple data sources and load it into various target databases and file systems.

Here's how senior obiee developers use informatica:
  • Designed and developed transformations, mappings and sessions using Informatica to load target database.
  • Worked extensively on EBS Source Qualifier Queries to built/Modify New/Existing Informatica mappings.

5. Business Model

A business model describes the core of a company's profit-making plan. The model states how an organization creates, delivers, and captures value in economic, social, or cultural contexts. It helps define what products or services a company will sell.

Here's how senior obiee developers use business model:
  • Customized and developed Business Model and Mapping layer.
  • Designed and built the physical and logical models in Physical and Business Model & Mapping Layer in the OBIEE Administration tool.

6. PL/SQL

Here's how senior obiee developers use pl/sql:
  • Registered PL/SQL functions using Discoverer Administrator 10g.
  • Customized the Oracle stored procedures to aggregate the data into different metrics based on Business Unit using PL/SQL.

Choose from 10+ customizable senior obiee developer resume templates

Build a professional senior obiee developer resume in minutes. Our AI resume writing assistant will guide you through every step of the process, and you can choose from 10+ resume templates to create your senior obiee developer resume.

7. Fact Tables

Here's how senior obiee developers use fact tables:
  • Defined Primary key-Foreign key relationships, complex joins between dimension tables and Fact tables in the physical layer and BMM Layer.
  • Created mappings for Dimension Tables using SCD Type 2 and populated fact tables and modifying existing mappings according to customer requirements.

8. Data Warehouse

Data warehouse, often abbreviated as either DW or DWH is a system used in computing for data analysis as well reporting. The DW is also considered to be an integral component of business intelligence as they also provide storage facilities for both real-time and historical data. ETL and ELT are the two driving forces behind a data warehouse system.

Here's how senior obiee developers use data warehouse:
  • Developed various Interfaces, Packages and Procedures using ODI to load data from Flat file & Relational Sources to Data Warehouse.
  • Identified Facts and Dimensions (with levels & hierarchy) and made required changes to the data warehouse per gaps.

9. Toad

Toad is software that manages non-relational and relational databases that database analysts, developers, and database administrators use. Toad helps in minimizing the cuts in delivery timelines of projects. It also helps in maximizing the investment made by users in the field of data technology by automating all the processes.

Here's how senior obiee developers use toad:
  • Used SQL tools like TOAD 9.5 and SQL Developer to run SQL queries and validate the data in warehouse.
  • Used Toad extensively for query optimization.

10. RPD

Here's how senior obiee developers use rpd:
  • Maintained the RPD (Repository) and made ongoing changes * Deployed any new OBIEE objects to Test and Production.
  • Worked as an Administrator of WebLogic and OBIEE with RPD, design of new subject areas/ reporting areas within OBIEE.

11. BI Applications

Here's how senior obiee developers use bi applications:
  • Participate in evaluating and analyzing utilities and tools offered by BI applications/tools vendors.
  • Supported existing BI applications, on bug fixes/enhancements, ongoing releases etc.

12. DAC

Here's how senior obiee developers use dac:
  • Created the DAC Execution plan reports in Answers to analyze the Load Plans.
  • Executed full load and then incremental loads using refresh dates in DAC.

13. Physical Layer

Here's how senior obiee developers use physical layer:
  • Defined foreign key join in the physical layer and complex join in logical layer to add dimension tables to star schema.
  • Created the Metadata Repository designing the Physical Layer and Business Layer to optimize the Query Performance in the Admin Tool.

14. Cache

Here's how senior obiee developers use cache:
  • Implemented Automatic Cache Clearing Strategy.
  • Involved in setting up Agents to run reports after the load for Cache Seeding to Improve Query Performance using Caching.

15. Windows XP

Here's how senior obiee developers use windows xp:
  • Prepared a production monitoring and support handbook Environment: Informatica power center 6.1/7.1, Oracle, windows XP, MS office Suite
  • Do the detail unit/integration testing Environment: Informatica Power Center 8.6.0, Oracle 10g, Windows XP, UNIX.
top-skills

What skills help Senior Obiee Developers find jobs?

Tell us what job you are looking for, we’ll show you what skills employers want.

List of senior obiee developer skills to add to your resume

Senior obiee developer skills

The most important skills for a senior obiee developer resume and required skills for a senior obiee developer to have include:

  • Interactive Dashboards
  • Presentation Layer
  • ETL
  • Informatica
  • Business Model
  • PL/SQL
  • Fact Tables
  • Data Warehouse
  • Toad
  • RPD
  • BI Applications
  • DAC
  • Physical Layer
  • Cache
  • Windows XP
  • Financial Analytics
  • Level Security
  • Oracle 11G
  • Schema
  • Linux
  • LDAP
  • Unix
  • Data Models
  • SQL Server
  • QA
  • Oracle 10G
  • Dashboards
  • HR
  • Calculation
  • Analytics Views
  • Pivot Tables
  • Development Environment
  • Test Cases
  • Oracle Bi
  • UAT
  • Metadata Repository
  • Business Analysts
  • Windows Server
  • Oracle Ebs
  • Publisher Reports
  • Oracle Sql
  • Production Environment
  • Drill-Down Capabilities
  • Gl
  • BMM
  • HTML
  • Obiee Repository
  • ODI
  • Aggregate Tables
  • Functional Specifications

Updated January 8, 2025

Zippia Research Team
Zippia Team

Editorial Staff

The Zippia Research Team has spent countless hours reviewing resumes, job postings, and government data to determine what goes into getting a job in each phase of life. Professional writers and data scientists comprise the Zippia Research Team.

Browse computer and mathematical jobs