StemXpert 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.
Job Description:
• 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.
Additional InformationThanks & Regards,
--------------------------
Venkat
734-550-4449
Skills Required
- Experience as an OBIEE developer
- Experience with OBIEE 11.1.1.x (11.1.1.7)
- Experience on Red Hat Enterprise Linux Version 6
- Experience with Oracle RDBMS 12c
- Experience with Informatica (9.6.1 / PowerCenter / PowerMart)
- Full life cycle Business Intelligence implementation experience
- Ability to gather reporting/analysis requirements and document report specifications
- Design and develop OBIEE metadata repository (.rpd) — Physical, Business Model and Mapping, Presentation layers using Oracle BI Administration Tool
- Define KPIs, facts, dimensions, hierarchies; design star and snowflake schemas
- Design interactive dashboards in OBIEE (drill down, prompts, filters, variables)
- Experience with OBIEE Answers, Variable Manager, initialization blocks and repository/session variables
- Create and schedule iBots in Oracle BI Delivers
- Experience creating executive reports with BI Publisher integrated with OBIEE
- Strong skills in data analysis, data modeling, dimensional modeling and data warehousing
- Experience with data modeling tools (Erwin, MS Visio, Smart Draw)
What We Do
STEM Xpert is a consulting engineering firm recognized in the engineering industry for its commitment to client service and passion for excellence. The firm provides specialized professional consulting services in the fields of science, technology, engineering, and mathematics (STEM).
