Technical Analyst 3 - Support

Our Ideal CandidateWe 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 7 to 10+ years and should: Have hands-on experience in implementing/supporting Oracle Business Intelligence Applications for heterogeneous sources like EBS/Siebel/Taleo/Fusion Cloud. 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

/IC4

Career Level - IC4

As an integral part of the CSS Analytics 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