FSR (Federal Staffing Resources)
  • Annapolis, MD, USA
  • Contract

JIS is seeking one (1) Contractual Resource (CR) as an Oracle Business Intelligence Applications/Oracle Data Integrator Developer.

Oracle Business Intelligence Applications/Oracle Data Integrator Developer Roles and Responsibilities

  • Work with users to gather requirements for OBIA procurement, finance, custom OBIEE and BI publisher reports.
  • Modify OBIA repository, create custom tables and joins for OBIA reports.
  • Create custom reports in OBIA procurement and finance.
  • Write custom SQL queries using PeopleSoft finance and procurement tables, to validate data in OBIA reports.
  • Customize out of the box scenarios in ODI and add it to the existing load plan.
  • Generate load plans in ODI and optimize those using custom OBIA tables, modifying ODI interfaces and creating table indexes to reduce the ODI load running time.
  • Migrate ODI objects (Interface, Scenarios and Packages) between environments using smart export and import.
  • Create report in OBIEE to track ODI load status and errors using SNP tables.
  • Work with DBAs and oracle support to rectify the runtime errors on ODI load plan.
  • Install, upgrade and maintain Oracle Data Integrator (ODI) in Production, test and QA servers.
  • Install, upgrade and maintain Oracle Business Intelligence Enterprise Edition (OBIEE) in Production, test and QA servers
  • Install, upgrade and maintain Oracle Business Intelligence Applications (OBIA) in Production, test and QA servers.
  • Import and export service instance using WebLogic scripting tool in AIX server to export and import presentation services catalog, datamodel and security policy metadata between environments in OBIEE 12C.
  • Run commands in AIX to import SSL certificate and key stores for active directory authentication.
  • Configure security providers, active directory and oracle internet directory (OID) using WebLogic administration console.
  • Create users and add them to groups in WebLogic admin console.
  • Create roles and add groups & users in WebLogic enterprise manager.
  • Use AIX commands to start, stop and navigate through files and folders in the all AIX servers for OBIEE and ODI
  • Perform error diagnostics in OBIEE and ODI using server logs.
  • Install, configure and migrate reports from OBIEE 12.2.1.0 to 12.2.1.3
  • Perform Authentication and Authorization (implement object and row level security).
  • Use Write back feature in OBIEE to implement and maintain the reports where users are able to enter data for expected budget and expenditure values and plan current and future Fiscal year Budget and expenses.
  • Plan, develop data model and create custom reports in OBIEE for Alternative Dispute Reports (ADRESS) based on user requirements.
  • Model the ADRESS repository by importing data warehouse tables, creating new physical and logical joins.
  • Create custom templates in BI publisher, using bursting definition and schedule reports to be delivered to an FTP folder in a remote machine based on the requirement for domestic violence reports users.
  • Create custom queries and views using oracle internet directory tables for security reports.
  • Maintain EBAR, elicense, foster care and security reports using BI publisher.
  • Run AIX scripts on the server to rename DV reports BI publisher files and add them to the server.
  • Create and modify repository and session variables in OBIEE.
  • Create new tables and views in data warehouse

 

Education

 

Bachelor Degree in Computer Science

 

Skills and Experience

 

A two four week training period will be provided to acclimate the selected individual(s) in the methods, processes, equipment, and software used by the Maryland Judiciary.

Ability to communicate effectively, orally and in writing, and to establish and maintain effective working relationships with peers, end users and vendor development staff, as well as all levels of management and judicial personnel as necessary.

  • Must be familiar OBIEE (Oracle Business Intelligence Enterprise Edition) 12C.
  • Must be able to develop reports, design rpd, administer server and perform server upgrade in OBIEE 12C.
  • Experience in OBIEE security configuration (authentication and authorization)
  • Must have experience in configuring active directory and oracle internet directory (OID) security in OBIEE 12C.
  • Must be familiar with write back feature in OBIEE 12C.
  • Must have experience in OBIA (Oracle Business Intelligence Applications) 12C, Procurement and Finance.
  • Must have experience in Oracle Data Integrator 11G.
  • Must have experience in ODI customization, migration between environments and load plan generation.
  • Must be familiar with Oracle BIpublisher 12C
  • Must be able to create xmlptemplates and associate with SQL code
  • Must be familiar with Oracle PL/SQL and xmlpublisher
  • Must be able to read user requirements and understand the dependencies on roles.
  • Must be able to work closely with Oracle database administrators and Oracle xmlpserver administrators and enterprise security groups.
  • Must have a deep knowledge of report design, views, materialized views, and database design for reporting.
  • Must be familiar with star schema and warehouse architecture design.
  • Must be able to distinguish who the current user of the report is so that roles and report output can be designed accordingly.
  • Must understand the separation of business logic from the presentation of the data via xmlpserver.

 

Place of Performance/Travel

  • No travel is anticipated in this role.
  • All work shall be performed at the Maryland Judiciary's JIS Department located at 2661 Riva Road, Suite 900, Annapolis, Maryland 21401, unless otherwise authorized.
  • The Department/Senior Manager must approve work prior to or after normal operation hours and all travel and lodging arrangements in writing and in advance. Mileage, toll re-imbursements and lodging re-imbursements should be invoiced to the AOC and reimbursed in accordance with the Judiciary's travel policy. http://mdcourts.gov/administration/travel.html

 

Reporting

CRs are required to report in a JIS prescribed format:

  • A weekly report communicating project progress and status,
  • Weekly time reporting on JIS provided forms, and
  • Any additional reports as assigned by the supervising manager.

 

Hours of Operation

  • Hours of work are the normal operational hours of 8:30am to 5:00pm(EST), with the flexibility to extend the coverage hours to meet deadlines. The JIS Manager or Department/Senior Manager must approve work prior to or after normal operation hours, not to exceed 2,040 hours per year.

Depending upon project requirements, the CR must be able to work a flexible schedule to include evenings, nights, weekends and holidays. CR must be available to provide on-call operational support as required outside business hours.

FSR (Federal Staffing Resources)
  • Apply Now

  • * Fields Are Required

    What is your full name?

    How can we contact you?

    I agree to iSolved Hire's Applicant Information Use Policy.*
  • Sign Up For Job Alerts!

  • Share This Page
.
logo markets job seekers working warriors about us resources contact us