Experience - 7 to 10 years
Design and development of best-in-class Reporting solutions using OBIEE 11g to support internal and external reporting and analytics requirements
Create solution architecture, perform technical designs and provide delivery estimates
Design and implement OBIEE physical, logical and presentation layer for different source systems with complete ownership of OBIEE RPD
Design and Develop reports and dashboards, alerts and agents as per the project needs
Design and implement row and column level security in OBIEE layers
Liaise with Business analysis to understand requirement and convert the same into technical design
Work with the solution architect in understanding the initial feasibility analysis and how to achieve the optimal technology solution to a business proposition
Seek necessary inputs and provide necessary guidance to ETL team to create high performing database designs for excellent report response time
Prepare implementation plan and coordinate with various teams to deploy codes to different environment
Coordinate with testing teams to review technical test cases and closure of defects
Perform proof of concepts in relevant OBIEE features and get necessary buy-ins to implement the same
Should work with TIS team to coordinate and provide input from the development perspective for the set-up, Installation and configuration of the OBIEE platform environment
Assist in configuration of various OBIEE components where required as well as change different configuration files to implement any OBIEE features as needed in the project
Define and implement technology quality controls and processes
Work as a single point of contact for the project manager while providing the requisite levels of support required for delivering the project through the development and testing phases
Provide architecture oversight and technical leadership during the course of projects
7-10 years of experience in delivering at least 2-3 project in BI, Analytics & reporting applications
Experience in integrating data warehouses, dimensional modelling design.
At least 3+ years of experience in OBIEE 11g/10g toolsets (11g preferred) with direct ownership of OBIEE implementations.
Working knowledge of the OBIEE Architecture and different toolset capabilities within OBIEE including BI Publisher and SmartView.
Excellent hands on experience on RPD (all three layers) with ability to model different database structures.
Experience on all aspects of security implementation in OBIEE including row level security
Ability to create reports, charts, pages, folders and dashboards in OBIEE.
Ability to creation alerts and agents in OBIEE
Ability to create reports in BI Publishers would be preferred
End to End knowledge of data warehouse architecture with at least 2+ years of experience in Oracle and good concepts of oracle database objects (tables/indexes/partitions)
Very good SQL querying capabilities
Desired experience to troubleshoot other general and performance issues in OBIEE
Exposure to the underlying infrastructure and understanding of different Java and BI system components to assist installation and providing guidance for configure these components where required.
Informatica Powercenter and data load experience would be added advantage
Hands on system software analysis, development, testing and experience in reporting stream (preferably DWBI & analytics)
Person should be a B-Tech, MBA or MCA in relevant stream from reputed institute
Exposure to Java scripting and Web Services would be a plus
Exposure and sound knowledge of Financial Services domain Mutual Funds and Fund Accounting would be definitive plus
Certification in OBIEE 11g is an added advantage