BI Data Warehouse Specialist - Oracle Data - Batch Processing

This job has now expired please search on the home page to find live IT Jobs.

BI Data Warehouse Technical Specialist - Oracle Data Warehouse - OBIEE - ETL - GoldenGate - TTS - SQL Loader - Batch Processing

My client a leading Utilities organisation is seeking a BI Data Warehouse Specialist to join an existing team responsible for supporting and developing Data Load Processes e.g. ETL, Oracle Streams/GoldenGate, TTS, SQL Loader, External Files, FTP and SFTP, batch processing and troubleshooting BI tools, systems, software and reports.

Core Duties:

* Provide support/development and capability to undertake Data Load Processes e.g. ETL, Oracle Streams/GoldenGate, TTS, SQL Loader, External Files, FTP, SFTP

* Creation and maintenance of batch process for warehousing activities.

* Writing and tuning complex SQL

* Provide support to other technical resources or business teams on complex issues and projects

* Troubleshoot BI tools, systems, software and reports; performance-tune as necessary.

* Assist with requirements and prototyping possible solutions in conjunction with BIS BA's.

* Develop technical designs for BI solutions including data warehouse and BI application elements.

* Create technical documentation for BI solutions.

* Develop and test solutions for BI solutions within a data warehouse and OBIEE or other suitable BI tool.

* Maintain knowledge of the BI Infrastructure and Architecture

* Identify and implement improvements to the current BI Systems

* Out of hours work / On Call if required.

* Provide demonstrations of currently used BI Tools to the Business (MI Teams, Report Consumers)

Key skills:

* Oracle Database / Data Warehouse Knowledge

* Demonstrable Expert/Advanced SQL/PL SQL skills.

* Data Load Processes e.g. ETL, Oracle Streams/GoldenGate, TTS,SQL Loader, External Files, FTP, SFTP

* Batch / Job Scheduling and Processing

* Good Understanding of Data Warehouse Design and Principals

* Performance recognition and tuning

* Unix/Linux navigation

* Hardware Appreciation storage/SAN, I/O, CPUs etc

* OBIEE and Qlikview, development and Administration

* DBA Process awareness

* Code Control usage and adherence

* Good working knowledge of SQL tools (e.g. SQL Developer, SQL*Plus, etc)

* Ability to work with Server Technologies (e.g. Windows Server 2003)

* Strong ability to analyse user requirements

* Knowledge of JavaScript, XML, CSS, HTML