We are looking for a strong Oracle BI technical consultant who thrives on solving complex business problems by implementing and supporting various modules. The ideal candidate should:
• Be able to operate independently to provide quality work products; perform varied and complex duties and tasks that need independent judgment
• Have excellent communication skills – both written & verbal
• Have good interpersonal skills with the ability to build rapport with all stakeholders
• Have the ability to present ideas and solutions in a clear & concise manner
• Be self-motivated with a lot of energy and drive
• Have the ability and willingness to learn
The ideal candidate should be a Bachelor of Engineering/Bachelor of Technology or Master of Computer Applications with experience ranging from 4 to 7 years and should:
• Have hands-on experience in implementing/supporting Oracle Business Intelligence Applications for heterogeneous sources like OBIEEE & ODI. The functional modules should cover Financials, Manufacturing, Supply Chain, Procurement and Spend, Sales, etc.
• Have experience (In-Depth Understanding of Data Model and Business process functionality and its data flow) in Oracle Business Intelligence Applications
• Have development experience in extending the out of the box OBIA code using Type-1, Type-2 customizations
• Have experience in writing efficient and optimizing code and understanding of performance tuning techniques in the ETL tools used in OBIA such as Informatica and ODI
• Have experience of RPD modeling (All 3 layers) using the OBIEE Administration Tool
• Have experience in Report/Dashboard development using OBIEE
• Have experience in monitoring the ETL loads via DAC
Your Responsibilities
As an integral part of the ACS-OFS BI Team, you will be responsible for the following –
• Working with remote and geographically distributed customers to enable building the analytics solutions
• Be very technically hands-on and own/drive key end to end product/services
• Ensure customer success including delivering enhancements/bug fixes as needed
• Design & Development of ETLs using Informatica, Oracle Data Integrator either within the OBIA or standalone
• Design & Development of RPD/Reports/Dashboards using OBIEE
• Monitor the ODI or Informatica ETL Jobs and address any failures in a quick manner to ensure the Analytics data is current
• Monitor the OBIEE Agents and Report jobs and address any failures
• Develop and execute complex SQL queries to analyze data issues end to end
• Perform data validations from the OBIEE Reports to the respective Source systems and consolidate the data