Oracle Data Integrator Developer
Job Description
Become a member of a growing team of Information Technology professionals making an impact and providing solutions for Government and Commercial clients since 1996 – Join the Domino Tech Team!
The Position:
Position Title: Oracle BI Data Integrator Developer
Location: Hybrid Remote Off-Site and On-Site in Annapolis, MD
Duration: 12+ Months
Note: Position will be 3 days on-site and 2 days remote off-site
We are seeking Oracle BI Data Integrator Developers with 10+ years of experience in OBIA/OAS and WebLogic to perform the following;
- 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.
- Modelling 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,
- - Additional reports as requested.
The Preferred Skills and Experience:
- 10+ Years: OBIA/OAS
- 10+ Years: WebLogic
- 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 (1) OBIEE (Oracle Business Intelligence Enterprise Edition) 12C, OAS 5.5/6.4, WebLogic 12.2.1.4, (2) Write back feature in OBIEE 12C, (3) Oracle BIpublisher 12C and OAS 5.5/6.4, (4) Oracle PL/SQL and xmlpublisher, (5) Star schema and warehouse architecture design.
- The ability to develop reports, design rpd, administer server, and perform server upgrade in OBIEE 12C and OAS 5.5/6.4.
- The ability to create xmlptemplates and associate with SQL code.
- The ability to read user requirements and understand the dependencies on roles.
- The ability to work closely with Oracle database administrators and Oracle xmlpserver administrators and enterprise security groups.
- The ability to distinguish who the current user of the report is so that roles and report output can be designed accordingly.
- The ability to 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.
The Company:
The mission of Domino Technologies, Inc. is to provide clients with IT solutions for their individual business processes that lead to strategic market advantages. Since its founding in 1996, the Domino Tech Team has built a solid record of performance working with clients in the Government and Commercial sectors.
The Perks:
- Excellent Market Salary
- Competitive Benefits
- Paid Holidays and Vacation
- Positive Work-Life Balance
The Location:
Domino Technologies is based in the Harrisburg area – the capital city of the Commonwealth of Pennsylvania and the county seat of Dauphin County. Located on the east bank of the Susquehanna River, Harrisburg is the anchor of the Susquehanna Valley metropolitan area.
Contact Us Today!
Meet Your Recruiter
Sudheer Vemula
Senior Account Executive
Sudheer Vemula is an IT consulting specialist with over 20 yrs of industry experience, 14 yrs of experience as Resource Manager, Account Manager, developing strategies around the Public sector IT practice that have enabled their enterprises to grow and adapt to changing market conditions. In prior management roles, developed the work-flow process, streamlined the off-shore facilities, managed mid-size IT projects, strategic consulting and founder of VarenTax.com, a financial / accounting outsource firm.
He holds Bachelors in Engineering (Mechanical) and BNCOE Alumni. Worked with MGL Americas (formerly known as Mason Global) from 1997 to 2012 at various levels until the company dissolved it’s operations and worked as independent consultant till joining the Domino Technologies in July 2018.