Oracle Business Intelligence Applications/Oracle Data Integrator Developer
| Job Title: | Oracle Business Intelligence Applications/Oracle Data Integrator Developer |
| Location: | Annapolis, MD |
| Salary/rate: | $55-62/hour |
An Oracle Business Intelligence Applications/Oracle Data Integrator Developer provides expertise in performing application development, configuration and unit testing of Data Integration (using ODI, PL/SQL, SQL), and Oracle Business Intelligence (OBIEE) applications including HR Analytics (prebuilt Warehouse, ELT, & OBIEE models) for the project. They will participate in the development, integration, and deployment of solutions. They are responsible for designing, developing, and supporting BI solutions based on client requirements.
Responsibilities:
- Installing, upgrading, and maintaining Oracle Data Integrator (ODI) in Production, Test, and servers
- Installing, upgrading, and maintaining Oracle Business Intelligence Enterprise Edition (OBIEE) Production, test, and QA servers
- Installing, upgrading, and maintaining Oracle Business Intelligence Applications (OBIA) 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 table
- 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, 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 Linus command 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 reports and additional reports as requested
- Proven knowledge and 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, and Work closely with Oracle database administrators and Oracle xmlpserver
- Understanding of the separation of business logic from the presentation of the data via xmlpserver
- Articulating and finding ways to add unit test/integrated tests to legacy systems using Junit and Mockito to debug issues
- Providing accurate estimates for Jira tasks using Scrum development process
- Documenting the legacy system code and approach used with flow diagrams
- Understanding and capability to code in event driven, microservices, and SOA architectures
- Experience with:
All Categories
Tags
adobe illustrator
adobe photoshop
business needs
dc government
facebook
FRD
govdelivery
Hibernate
Illustrator
instagram
ITIL
J2EE
java
Java 8
java engineer
job hunt
job search
LINUX
management
Marketing
Mockito
new opportunity
Oracle
Oracle 12
PERL
PMP
Primefaces
project management plan
project manager
project risk
project schedule
RTM
SDLC
site assessment
SME
social media
software requirements
Spring
strategic objectives
system requirements
tiye consulting
twitter
washington dc
XML
•