Standard / Permanent
Job Details :-
The North American IT Transversal Functions is working on implementing IT solutions to Intermediate Holding Company as well as other entities.
We are looking for a talented individual who can join a dynamic environment where they can raise the bar for the industry.
The individual will be responsible for the success of OBIEE project by developing new, maintaining existing and supporting a number of in-house/vendor applications from the data warehouse, database and business intelligence perspective. The person is expected to work in close tandem with OBIEE Development team, onshore stakeholders and other related teams and is also able to share the status updates of the activities whenever needed.
ROLES and RESPONSIBILITY
•Work with OBIEE development team to implement the OBIEE and DB objects.
•Write technical specs related to this implementation
•Work closely with other development teams and other DB architect and developers to set up interfaces and procedures by following the best practices / conventions within the team (including peer code review).
•Help deploy application to UAT and production environments, and handle bug-fixes and implement possible system redesigns during these periods.
•Consult with users, management, and technical personnel to clarify business requirements, identify problems, and suggest changes / best practices.
•Write / analyze functional requirements, then propose reporting solutions to them based on BNPP standard systems. Write technical specifications and perform workload and risk analysis related to these solutions
•Maintain and support existing applications, and participate in user trainings.
Primary skills (mandatory)
•Understand and collect requirements from business users.
•Should be aware of OBIEE structure, infrastructure and framework.
•Should be able to perform Repository modeling based on requirements.
•Working on OBIEE Administration tool.
•Should have a fair knowledge of BI-Publisher working and report bursting.
•Performance tuning of OBIEE application on repository level.
•Should be able to work on OBIEE Cache and logs.
•Should be aware of OBIEE directory structure.
•Security implementation of OBIEE repository level and OBIEE application level.
•Working with PL SQL Procedure, Functions, Packages, Views, Materialized views whenever necessary.
•Working with aggregates, hierarchies whenever necessary.
•Understand the business requirement and implement different graphs, charts as per requirement.
•Aware of Data warehousing and Data mart concepts.
•Good debugging skills and should be able to troubleshoot performance issues.
Secondary skills / knowledge (desirable)
•Exposure to any of the following tools Oracle BI Tools, PL/SQL Server BI tool set, Business Objects.
•Good understanding of Databases (Oracle, DB2, Exa Data)
•Working knowledge of job scheduling products such as AutoSys and ControlM with Oracle database.
•Knowledge of any of the Web Servers like Websphere, Weblogic etc
•Exposure in BFSI Domain.
•Excellent English written and oral communication skills.
•BE/ BS in Computer Science or related IT field, or equivalent work experience required.
•4 - 6 years of OBIEE experience.
◦A very good team player and to be able to work independently.
◦Good English verbal and writing communication skills: Be able to communicate with team mates, users and managers easily. Good French verbal communication skills are a plus
Excellent technical documentation skills.