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

  • • Work closely with internal and external partners to gather requirements and design complex business application extensions and data integration solutions
bangalore, KA, IN