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
* 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.
