Job Description :
OBIEE DEVELOPER

IMPORTANT SKILLS: DAC,INFORMATICA,EBS,OBIA,BICS,12c

Work Location: Sunnyvale, CA

Duration: 6 months +

Summary:



Eight years of expertise in developing Data Warehousing Applications including design, development, testing, maintenance and documentation.

Very strong experience in OBIEE Administration Tool, Presentation Services/analytics, Interactive Dashboards, Delivers/iBots, Cache Management and Scheduler Configuration.

Hands on experience in Project methodologies/SDLC, DW, BI infrastructure and architecture using middleware OBIEE, OBIA, data loading, scheduling, monitoring workflows/jobs and dimensional modelling in Data warehouse life cycle.

Worked onFinancial, Sales, Oracle Process Manufacturing Procurement & Spend Analytics, Supply Chain and Order Management Analytics.

Expertise in OBIEE Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series and Cache Management.

Expertise in installation, configuration, troubleshooting, performance tuning and administration of OBIEE.

Experience in Designing and developing Star, Snow flake and multi-dimensional Schemas.

Experience in BI Publisher (XML Publisher) and Oracle Business Intelligence Discoverer.

Experience in 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.

Knowledge of Database architecture for OLTP and OLAP applications, Data Analysis, ETL, Reporting processes in developing Data marts and Enterprise Data Warehouse.

Experience in Installation and configuration of Informatica Power Center, creating Mappings, Mapplets, Sessions and Workflows.

Thorough knowledge in Data Warehousing Concepts with expertise in ETL methodology for supporting data extraction, loading and transformation processing using Informatica Power Center.

Informatica experience working on transformations depending on requirements (Join, Filter, Lookup, Union etc

Developed Mappings and Workflows with Worklets and Tasks using various Transformations for Informatica to feed data from multiple sources to data warehouse.

Experience in DAC with Importing Subject Areas, building Execution plans, registering the Informatica Work flows, Metadata management and Scheduling.

Strong experience in writing SQL queries/reports, PL/SQL Stored Procedures, Functions, Packages, triggers for Oracle 11g/10g and tuning of SQL queries/scripts.



Key Skills:



Experience in various OBIA modules such as HR, Projects, Financial, SCM, Manufacturing, Sales, Procurement and Spend Analytics

Experience in Oracle EBS Finance Modules (GL, AP, AR, PO) and SCM Modules (INV, OM), OPM (Oracle Process Manufacturing)

Experienced in Design, Development, Maintenance and Support in OBIEE/OBIA environment

Experience in data warehouse designing and Kimball’s data modeling techniques.

Experience in Oracle, SQL Server, Essbase and databases
             

Similar Jobs you may be interested in ..