Oracle Business Intelligence Software Developer - Baltimore, Maryland (Job)

Oracle Business Intelligence Software Engineer: Baltimore, Maryland
Qualified Candidates Send Resumes to info<>msandtinc.com

Matrix Systems & Technologies, Inc. is seeking an Oracle Business Intelligence Software Engineer to perform:

• - Complete BI lifecycle development from design of the Oracle BI architecture from data sourcing to the end target data structures and presentation of data through dashboards and reports
• - Development of reporting framework within Oracle Business Intelligence Enterprise Edition
• - Define, Implement, and Setup of, Physical, Logical (business), and Presentation objects in OBI
• - Create and modify Sales Analytics dashboards and reports
• - Generate necessary templates for the required reports using MS tools as necessary
• - Development of OBI Reports
• - Development of ETL mappings
• - Create custom reports and dashboards
• - Perform unit testing of applications to ensure efficient execution and compliance with business and technical requirements
• - Perform system tuning
• - Review, release, and service pack notes issued by Oracle for OBI to identify changes to be applied
• - Develop appropriate testing and implementation plans
• - Work with business units to address reporting and analysis needs
• - Participate in acceptance testing to ensure client/user needs are met
• - Query management, query reformulation,query governing and prioritization
• - Familiarity with Backroom presentation server infrastructure factors such as volatility, data size, number of users, number of business processes, nature of use, service level agreements

Qualifications:

* Four plus years of Oracle BI installation
* Five plus years experience developing Oracle BI Dashboards
* Six plus years using Oracle, Oracle Forms, and PLSQL.
* Six plus years experience developing applications with the following back-end databases: Oracle, Microsoft SQL, Microsoft Access, and DB2.
* Four plus years with at least two of the following connection tools: zConnect for IMS and DB2, Connect for DB2, ODBC and JDBC for Oracle and SQL Server, ADO for .NET using SQL
* Five plus years developing applications using Microsoft Active Directory

Familiarity with the Data Warehouse Lifecycle Toolkit. - Kimball Lifecycle - Project Planning - Extract Transform Load (ETL) System Design & Development - Business Intelligence Application - Design & Development - Dimensional Modeling - Requirements Definition - Quality Assurance - MetaData - Presentation Server - Normalization - Slowly Changing Dimensions - OLAP - Usage Monitoring - Application Architecture Plan Outline and Model - Source Systems - RDBMS - Fact Tables - Keys - Granularity - Star Schema - Dimension Roles - Logical Models - Physical Data Models - Snowflake - Data Marts - Slowly Changing Dimensions - Data Cleansing - Data Security - BI Portal Interface - Analytic Applications - Dashboard Development - Direct Access Queries - Scorecards - Monitoring Activity - ANSI SQL 99 Support - Data Mining - Anomaly Detection - Testing and Verifying Applications - Deploying and Supporting Business Intelligence DW/BI Systems - Aggregates - Oracle Business Intelligence - Oracle Data Warehouse - Oracle Aggregation Navigation - Oracle Materialized Views - Oracle Materialized Views - Securing, Partitioning, and Indexing Oracle Tables.