Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

Oracle Business Intelligence Applications/Oracle Data Integrator Deve

Expired Job

Mansai Corporation Annapolis , MD 21401

Posted 4 months ago

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 datain 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 loadplan.
Install,upgrade and maintain Oracle DataIntegrator(ODI) in Production,test andQA servers.
Install,upgrade and maintain Oracle Business Intelligence Enterprise Edition(OBIEE)in Production,test andQA servers
Install,upgrade and maintain Oracle Business Intelligence Applications (OBIA) in Production,test andQAservers.
Import and export service instance using WebLogic scripting tool in AIX server to export
and import presentation services catalog,datamodel and securitypolicymetadata between environments in OBIEE 12C.
Run commands in AIX to import SSL certificate and keys to res 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 serverlogs.
Install,configure and migrate reports from OBIEE 12.2.1.0 to12.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 inBI publisher,using bursting definition and schedule reports to be delivered to anFTP folder in a remote machine based on the requirement for domestic violence reports users.
Create custom queries andviews using oracle internet directory tables for security reports.
MaintainEBAR,elicense, foster care and security reports usingBI publisher.
RunAIX scripts on the server to rename DV reports BIpublisher files and add them to the server.
Create and modify repository and session variables in OBIEE.
Create newtables and views indatawarehouse
Education
Bachelor Degree inComputer Science
Skills and

Experience
Ability to communicate effectively,orally and in writing, and to establish andmaintain effective working relationships with peers,endusers 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 BI publisher 12C
Must be able to create xmlptemplates and associate with SQLcode
Must be familiar with
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 xmlp server administrators and enterprise security groups.
Must have a deep knowledge of report design, views, materialized views, and database design for reporting.
Must befamiliar with star schema and warehouse architecture design.
Must be able to distinguish who the current userof the report is so that roles and report outputcan be designed accordingly.
Must understand the separation of business logic from the presentation of the data via xmlpserver.

Skills:
OBIEE 12C.Oracle Data Integrator 11G.Oracle BI publisher 12C,Oracle PL/SQL and xmlpublisher
Contract


See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Oracle Database Administrator

Belay Technologies, Inc

Posted Yesterday

VIEW JOBS 12/15/2018 12:00:00 AM 2019-03-15T00:00 You will be a member of a cross-functional team responsible for Oracle database administration working on IC Security Services.  You should possess an active TS/SCI with FSPoly and have experience to perform the following: <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Allocate system storage and plan for future storage requirements</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Create and maintain primary database storage structures</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Create primary database objects (tables, views, indexes) once developers have designed an application and assist developers in the design if required</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Modify the database structure, as needed</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Monitor and optimize the database performance</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Plan backup and recovery methodology</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Backup and restore the database as required</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Apply Oracle patches</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Migrate Oracle databases to new hardware as required</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Write PL/SQL stored procedures and triggers</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Write and maintain shell scripts</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Recommend new architectures, designs, and strategies for the future</li> </ul>  <br /> <strong>Lead the Way </strong><br />  <br /> Belay wants you to lead the way - push boundaries, offer ideas, create solutions, and be a part of something great with Team Belay!  Our team is full of technology pioneers who take the smartest approach, never accept the status quo, and are excited about making a difference!!<br />  <br /> Our team leads: <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Ideas; white papers, new technologies, improving existing infrastructure and introducing solutions...Belay was built on ideas</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Growth; Be the Captain of your Fate!  Share your aspirations and Belay will pave the way with conferences, education, mentorship and hands-on exposure to new and exciting things</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Development; step up, be instrumental in our growth and business efforts and you will be met with an open door to new experiences as leaders in a growing company</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Benefits; your feedback determines our offerings, which improve constantly based on your needs</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Giving: You tell us what is important to you and Belay will support your personal cause and charitable efforts, we’ve paid donations and volunteered to causes special to our team</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Fun; You give us ideas and we deliver in a big way, with go-kart racing, rock climbing, swanky casino nights, skeet shooting, happy hours and more!</li> </ul>  <br /> Make a difference and have fun with Team Belay!!<br />  <br /> <strong>Job Requirements:</strong> <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">TS/SCI Clearance with polygraph</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Bachelor’s Degree or higher in computer engineering or in a field related to the computer engineering or computer science disciplines</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">5 years of Software Engineering experience. </li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">An additional 4+ years of Software Engineering experience may be substituted for the degree for a total of 9 years.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">2+ years experience with Linux, Eclipse. Maven, and Java</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">2+ years work experience in the SIGINT, IA, or IT domains.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Oracle Database Administration 5+ years</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">PL/SQL 5+ years</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">SQL 5+ years</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Able to clearly communicate ideas and status updates</li> </ul>  <br /> <strong>Desired Requirements: </strong><br /> At least two of the following skills are desired: <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Database performance tuning</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">PERL</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Shell scripting</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Willing to take on a wide variety of tasking</li> </ul>  <br /> <strong>Perks and Benefits</strong><br />  <br /> <em>Belay Technologies offers an extensive benefits package, including:</em><br /> <br /> <em>- Up to 8 weeks in paid leave (4 weeks of personal leave, 3 days of Yay! leave, 10 paid holidays, and optional leave up to 6 days through Belay's volunteer program)</em><br /> <em>- 6% matching in 401(k) contributions vested on day one</em><br /> <em>- $5,000 annual training/tuition or the option to use that money to pay off student loans</em><br /> <em>- Rich medical coverage (100% coinsurance, no copays) with a fully funded Health Savings Account with up to $3000 in annual contributions from Belay</em><br /> <em>- Dental coverage including orthodontia</em><br /> <em>- Up to $420,000 in life insurance, life insurance and disability premiums covered 100% by Belay</em><br /> <em>- Pet insurance, generous referral bonus program, company sponsored lunches and events, and many more!</em><br />  <br /> <strong>Think you know someone who might be right for the job? Refer them to LeadTheWay@belaytech.com and you may be eligible for a referral reward up to  $10,000!</strong><br />  <br />  <br /> <strong>What We Do</strong><br /> <em>Belay Technologies provides leading technology and engineering solutions to the DoD, as well as state-of-the-art commercial products. We are a certified Service Disabled Veteran Owned Small Business in the Baltimore/Washington area, and we are an Equal Opportunity Employer.  We hire software engineers, web designers, test engineers, systems engineers, systems administrators, database engineers and other tech services.</em><br />  <br /> <em>Key words: Full Clearance, Fort Meade, SDVOSB, Service-disabled veteran owned small business, DoD, MW;SWEIIB</em><br />   Belay Technologies, Inc Annapolis Junction MD

Oracle Business Intelligence Applications/Oracle Data Integrator Deve

Expired Job

Mansai Corporation