Oracle BI Programmer 2603576

Employment Type

: Full-Time

Industry

: Miscellaneous



eiWorkflow Solutions, LLC is a cloud software consulting firm based in Albany, NY. eiWorkflow Solutions, LLC is currently looking for a consultant for the following role.


Oracle BI Programmer


Tasks the role will be performing:

• Develop ETL Scripts using PL/SQL and ODI
• Dimensional Data Modeling using BI Applications
• Participate in the development of technical design documentation for various stages of the BI implementation 
• Create Dashboards/Reports on OBIEE environment based on business requirements
• Collaborate with Client/Stakeholders and Business Analysts to discuss reporting requirements.
• Set up security to authenticate users and grant permissions and privileges to appropriate users.
• Deploy BI APPS objects (Repository) and OBIEE objects (reports) to other environments
• Debug complex SQL queries
• Prepare effort estimates for design and development
• Create performance reports (Usage tracking) to be reviewed by the technical team
• Designing tables, views and materialized views for use in BI Applications
• Perform Integration Testing along with end to end Data validation

Requirements for the position:

  • 60 Months of experience in Extensive Design, Development and Deployment Experience of Oracle BI Apps, OBIEE Analysis, Dashboards
  • 60 Months of experience in Dimensional Modeling
  • 60 Months of experience in ETL using either PL/SQL and/or ODI
  • 60 Months of experience in Oracle Database Designing tables, views and materialized views for use in BI Applications
  • 36 Months of experience as an Architect on a Datawarehouse project
  • 36 Months of experience in Setting up security to authenticate users and grant permissions and privileges to appropriate users. 
  • 36 Months of experience in Relational database design (relational models, star schema, keys, common terminology)
  • 36 Months of experience in development of technical design documentation
  • Bachelor’s Degree in Information Technology
  • Powered by JazzHR


    Launch your career - Create your profile now!

    Create your Profile

    Loading some great jobs for you...