Oracle BI ETL Consultant

Fixed Term Contract

Duration: 2 years

Location: County Kildare

Start Date: As soon as possible

Responsibilities:

The main duties and responsibilities of the role will include the following:

* Provide technical and process leadership for the technical team of ETL (SOA & ODI) and BI (OBIEE/OBIA) developers in all phases of the delivery process: requirements/scoping, prototyping/design, development, testing, release and support.
* Partner with program and enterprise leadership in the development of project plans to implement data warehouse solution and identify resource requirements for the Agile-Scrum based execution of work.
* Support test driven development efforts and working within a QA organization to provide continuous integration, building and module deployment.
* Be the "hands-on, end-to-end" expert in all layers of the OBIEE/OBIA stack with a proven track record of successful delivery in complex environments. Identify, recommend and best practices on ETL/OBIEE/OBIA architecture and repository development.
* Support and guide the cast of teammates performing ancillary roles within the BI teams.
* Lead source system analysis, ETL design and development and system testing to create an integrated data warehouse based on custom and Oracle BI Applications mappings and reports.
* Maintain high level of proficiency in appropriate modern technologies.
* Work in such a manner to develop and promote a progressive, professional and positive working environment within the applications team.
* Working within the Application team to ensure appropriate processes are implemented, in place and updated if required. Liaise with Operations, and application team to support each business unit to establish, track and monitor business requirements. Communicate effectively with business customers, line manager and peers.
* Proactively participate in the Performance Management process to ensure delivery of own, and the wider team's objectives.

Skills and Experience required:

* Knowledge of ITIL process and approach is desirable
* 2-3 years' experience in a similar role
* Experience of working within a technology development environment, preferably with an emphasis on utilities and Oracle BI applications
* Heavy hands on SOA/ODI ETL development in a data warehousing environment
* Heavy hands on OBIEE/OBIA architecture and repository and report developments using best practices
* Experience maintaining/modifying existing ETL code (not just new development) and data warehousing and ETL tools
* Ability to understand business requirements and develop software solutions
* Experience with the SDLC and BI tools mainly with OBIEE/OBIA
* Must have experience with STAR (SNOWFLAKE) schema techniques and experience performing user acceptance testing for applications
* Strong data analysis skills and ability to present the findings to business users along with strong documentation skills and experience using OBIEE/OBIA as a report writing tool
* Must be eligible to work in EU

Morgan McKinley is acting as an Employment Agency in relation to this vacancy.

Please note that any references to salary or pay rates in this advertisement and in the salary refinement section are indicative only and should only be used as a guide.

Email me jobs like this