Accessibility Links

BI Data Warehouse Specialist - Oracle Data - Batch Processing

  • Salary: £450 - £495 per day
  • Job type: Contract
  • Location: Nottingham, Nottinghamshire
  • Sector: IT
  • Date posted: 30/04/2018
  • Job reference: J384308A

We're really sorry, but it looks like this job has already been filled.

Register your CV with us, see our latest jobs or use the search below.

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
Similar jobs
View more similar jobs