Oracle Business Intelligence Applications/Oracle Data Integrator Developer

Oracle Business Intelligence Applications/Oracle Data Integrator Developer

Annapolis, MD (Hybrid)

2-3 years Contract

Qualifications:

• Possess a bachelor’s degree in computer science or related field.
• Ten or more years of experience in OBIA/OAS.
• Ten or more years of experience in WebLogic.

Scope of Work:

• Installing, upgrading, and maintaining Oracle Data Integrator (ODI) in Production, test and QA servers.
• Installing, upgrading, and maintaining Oracle Business Intelligence Enterprise Edition (OBIEE) in Production, test and QA servers.
• Installing, upgrading, and maintaining Oracle Business Intelligence Applications (OBIA) in Production, test and QA servers.
• Working with users to gather requirements for OBIA procurement, finance, custom OBIEE, OAS and BI publisher reports
• Modifying OBIA repository, creating custom tables and joins for OBIA reports.
• Creating custom reports in OBIA procurement and finance.
• Writing custom SQL queries using PeopleSoft finance and procurement tables, to validate data in OBIA reports.
• Customizing out of the box scenarios in ODI and adding it to the existing load plan.
• Generating load plans in ODI and optimizing those using custom OBIA tables, modifying ODI interfaces and creating table indexes to reduce the ODI load running time.
• Migrating ODI objects (Interface, Scenarios and Packages) between environments using smart export and import.
• Creating report in OBIEE to track ODI load status and errors using SNP tables.
• Working with DBAs and oracle support to rectify the runtime errors on ODI load plan.
• Importing and exporting 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.
• Running commands in Linux to import SSL certificate and key stores for active directory authentication.
• Configuring security providers, and active directory using WebLogic administration console.
• Creating users and adding them to groups in WebLogic admin console.
• Creating roles and adding groups & users in WebLogic enterprise manager.
• Using Linux commands to start, stop and navigate through files and folders in all Linux servers for OBIEE and ODI
• Performing error diagnostics in OBIEE and ODI using server logs.
• Installing, configuring, and migrating reports in OBIEE 12.2.1.0 to 12.2.1.3, and OAS 5.5 to 6.4.
• Performing Authentication and Authorization (implement object and row level security).
• Using 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.
• Planning, developing data model, and creating custom reports in OBIEE for Alternative Dispute Reports (ADRESS) based on user requirements.
• Modeling the ADRESS repository by importing data warehouse tables, creating new physical and logical joins.
• Creating 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.
• Creating custom queries and views using oracle internet directory tables for security reports.
• Maintaining EBAR, elicense, foster care and security reports using BI publisher.
• Running Linux scripts on the server to rename DV reports BI publisher files and adding them to the server.
• Creating and modifying repository and session variables in OBIEE.
• Creating new tables and views in data warehouse.
• Preparing regular and ad hoc reports, including:
• Weekly project report of progress and status,
• Weekly time report, and
• Additional reports as requested.

Skills Experience & Capability:

• The ability to:
• Develop reports, design rpd, administer server, and perform server upgrade in OBIEE 12C and OAS 5.5/6.4;
• Create xmlptemplates and associate with SQL code;
• Read user requirements and understand the dependencies on roles;
• Work closely with Oracle database administrators and Oracle xmlpserver administrators and enterprise security groups; and,
• Distinguish who the current user of the report is so that roles and report output can be designed accordingly.
• Write technical communications for non-technical staff.
• Understanding of the separation of business logic from the presentation of the data via xmlpserver.
• In Depth knowledge of report design, views, materialized views, and database design for reporting.
• Experience with:

1. OBIEE security configuration (authentication and authorization),
2. Configuring active directory security in OBIEE 12C and OAS 5.5/6.4,
3. OBIA 12C, OAS 5.5/6.4, Procurement and Finance,
4. Oracle Data Integrator 12.2.1.4,
5. ODI customization, migration between environments and load plan generation.

• Familiarity with the following:

• OBIEE (Oracle Business Intelligence Enterprise Edition) 12C, OAS 5.5/6.4, Weblogic 12.2.1.4,
• Write back feature in OBIEE 12C,
• Oracle BIpublisher 12C and OAS 5.5/6.