| Lead OBIEE Developer at Remote, Remote, USA |
| Email: [email protected] |
| From: Roshan, Triwavesolutions [email protected] Reply to: [email protected] Hi , Location : Maryland Location Job Title : OBIEE developer 1. Installing, upgrading, and maintaining Oracle Data Integrator (ODI) in Production, test and QA servers. 2. Installing, upgrading, and maintaining Oracle Business Intelligence Enterprise Edition (OBIEE) in Production, test and QA servers. 3. Installing, upgrading, and maintaining Oracle Business Intelligence Applications (OBIA) in Production, test and QA servers. 4. Working with users to gather requirements for OBIA procurement, finance, custom OBIEE, OAS and BI publisher reports 5. Modifying OBIA repository, creating custom tables and joins for OBIA reports. 6. Creating custom reports in OBIA procurement and finance. 7. Writing custom SQL queries using PeopleSoft finance and procurement tables, to validate data in OBIA reports. 8. Customizing out of the box scenarios in ODI and adding it to the existing load plan. 9. 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. The Offeror proposed resource shall be responsible for the following: Solicitation No. K24-0028-29 Oracle Business Intelligence Applications/Oracle Data Integrator Developer mdcourts.gov/procurement Rev. 02/08/2023 Page 19 10. Migrating ODI objects (Interface, Scenarios and Packages) between environments using smart export and import. 11. Creating report in OBIEE to track ODI load status and errors using SNP tables. 12. Working with DBAs and oracle support to rectify the runtime errors on ODI load plan. 13. 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. 14. Running commands in Linux to import SSL certificate and key stores for active directory authentication. 15. Configuring security providers, and active directory using WebLogic administration console. 16. Creating users and adding them to groups in WebLogic admin console. 17. Creating roles and adding groups & users in WebLogic enterprise manager. 18. Using Linux commands to start, stop and navigate through files and folders in all Linux servers for OBIEE and ODI 19. Performing error diagnostics in OBIEE and ODI using server logs. 20. Installing, configuring, and migrating reports in OBIEE 12.2.1.0 to 12.2.1.3, and OAS 5.5 to 6.4. 21. Performing Authentication and Authorization (implement object and row level security). 22. 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. 23. Planning, developing data model, and creating custom reports in OBIEE for Alternative Dispute Reports (ADRESS) based on user requirements. 24. Modeling the ADRESS repository by importing data warehouse tables, creating new physical and logical joins. 25. 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. 26. Creating custom queries and views using oracle internet directory tables for security reports. 27. Maintaining EBAR, elicense, foster care and security reports using BI publisher. 28. Running Linux scripts on the server to rename DV reports BI publisher files and adding them to the server. 29. Creating and modifying repository and session variables in OBIEE. 30. Creating new tables and views in data warehouse. 31 . Preparing regular and ad hoc reports, including: a. Weekly project report of progress and status, Weekly time report, and Additional reports as requested. Keywords: quality analyst business intelligence active directory information technology |
| [email protected] View all |
| Thu Sep 14 23:39:00 UTC 2023 |