Job Description :
Position: OBIEE Developer
Location: Sunnyvale, CA
Duration: Long Term Contract

Requirement Details:
· 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.