back Back to Jobs

Oracle BI Developer – ETL, OBIEE

Location: Portland, OR
Job # 11120687
Date Posted: 07-05-2018
Mavensoft is looking for Oracle BI Developer – ETL, OBIEE  in Portland, Oregon for 6  months contract. If you are interested and meet below requirements please email or apply online for immediate considerations with your salary expectations.  Thank you for your time.
 
Job Title:  Oracle BI Developer – ETL, OBIEE
Location:  Portland, Oregon
Duration:  6 months 
 
Skills: BI development, OBIEE, ETL, Oracle BI, Data Warehouse Administration Console (DAC), developing Reports and Dashboards, Informatica Power Center
Nice to have skills: PeopleSoft Finance, Supply Chain and HR systems is a plus
 
Project Description:
  • PGE’s Analytic Center of Excellence (PACE) serves as the Enterprise Data Warehouse and Governance Structure for PGE’s enterprise reporting and analytics.
  • PACE serves all PGE employees and sees nearly 300 active users log-in each day. PACE continues to enhance and develop business intelligence products that provide meaningful insights to our clients to enable operational, managerial and strategic reporting & analytics.
 
Required Experience/Skills:
  • Experience implementing enterprise-scale Business Intelligence (BI) systems with an understanding and ability to apply leading practice design principles to BI projects.
  • Experience in OBIEE, developing Reports and Dashboards with multiple views using presentation features; including drill-down / dynamics, cascading style sheets, pivot tables, visualizations and tabular with local and global filters.
  • Experience in OBIEE creating, configuring, customizing and maintaining repository design to support custom subject areas and modifications to out of the box Oracle BI applications.
  • Experience in Extraction, Transformation, Loading (ETL) data from various sources into data warehouses and data marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange and Power Connect.
  • Experience with the Data Warehouse Administration Console (DAC) to configure, manage and load the Oracle Business Analytics Warehouse.
  • Custom data warehouse design experience using Star Schema/Snowflake modelling, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and logical data modelling, and Oracle Designer.
  • Good verbal and written skills with the ability to connect and educate client’s technical team with regard to BI topics and future design vision.
 
Description of Work to Be Performed:
  • Responsible for developing new and enhancing existing Reports and Dashboards in OBIEE using presentation features including drill-down / dynamics, cascading style sheets, pivot tables, visualizations and tabular reports with local and global filters.
  • Responsible for creating, configuring, customizing and maintaining repository design to support custom subject areas and modifications to existing Oracle BI applications.
  • Responsible for ETL design and development for a consolidated reporting solution that integrates PGE enterprise system data
  • Responsible for end user support, break/fix and enhancements to existing enterprise data warehouse solutions
  • Support OBIA/OBIEE and source system data extract technologies including the resolution of performance issues and the development of new dashboards, reports, and metrics
  • Other BI functional and technical support, as required.
 
 
Skills to be successful in this role:
  •  Practical BI development experience
  •  Experience working in an Agile delivery method
  •  Works well with a team of peer BI developers, business analysts and quality assurance resources
  •  Familiarity with PeopleSoft Finance, Supply Chain and HR systems is a plus
 
 
 
Please Apply Online. To learn more about Mavensoft visit us at www.mavensoft.com
 
this job portal is powered by CATS