OBIEE Developer

Job Description

Stem Xpert is a global management consulting, technological service and outsourcing company delivering technology-driven business solutions to meet the strategically driven objectives for our numerous clients.

• We are looking for strong OBIEE developers for a enterprise level business Intelligence endeavor.
• We are delivering OBIEE 11.1.1.7 running on Red Hat Enterprise Linux Version 6 that accesses Oracle RDBMS Version 12c.
• We are using Informatica 9.6.1 for ETL.
• Expertise in full life cycle Business Intelligence implementations and have an understanding of all aspects of an implementation project using OBIEE 11.1.1.x.
• Experience in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer.
• Proficient in defining Key Performance Metrics (KPIs), facts, dimensions, hierarchies and developing Star and Snow Flake schemas.
• Experience in design and development of the three layers (Physical/Business Model and Mapping/ Presentation) of an OBIEE Metadata Repository (.rpd) using Oracle BI Administration Tool.
• Skilled at configuring OBIEE Metadata Objects including repository, variables, interactive dashboards, and reports.
• Experienced in designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.
• Strong experience in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
• Experienced in working with Variable Manager to define session and repository variables and initialization blocks to streamline administrative tasks and modify metadata content dynamically.
• Experienced in developing Dimensional Hierarchies, Level Based Measures, and adding multiple sources to business model objects.
• Skilled at creating and scheduling iBots in Oracle BI Delivers to provide real-time, personalized and actionable intelligence data to subscribers.
• Experience in creating executive reports with BI Publisher integrated with OBIEE.
• Skilled in Data Analysis, Data Modeling, Dimensional Modeling, and Data Warehousing.
• Knowledge of working with ETL Tools such as Informatica Power Center/ Power Mart 8.x/7.x in creating Source/ Target definitions, building Mappings/ Mapplets and creating and monitoring Sessions/ Workflows.
• Good experience with Data warehousing and OLAP technology – designing star schema, snowflake schema, fact and dimension tables, physical and logical data modeling using Erwin/MS Visio/Smart Draw.
• Quick learner with strong communication and people skills who can work in a team or independently.