ETL Developer
This job does not exist anymore.
Try running a new search or browse our vacancies.
Or fill in the form below to receive job alerts.
| Job Type | |
| Location | Eastbourne |
| Area | South East, UK |
| Sector | DigitalIT & Telecoms |
| Salary | £475 Outside IR35 |
| Start Date | ASAP |
| Advertiser | Leanne Howlett |
| Telephone | 07597378032 |
| Job Ref | LH-LOT-28681 |
- Description
- •Job Title: ETL Developer
•CV Submission Deadline: 23/05/2018 @ 09.50
•The Maximum Pay Rate: £475 LTD
•Location: 1 St. Andrews Road, Eastbourne, South East
•Contract Length: 6 months with possible extension
•Clearance Level Required: BPSS/ DBS
•Additional Info: Outside IR35
•Distribution: ICT – General
Top 5 essential experience items:
- Strong knowledge of Oracle data types and Data Definition Language (DDL)
- Advanced SQL skills
- Scripting
- Preparing and updating documentation
- Oracle RPD, Datapump and SQLLoader
Experience Required
The post holder will need to be able to demonstrate experience of the following:
- Strong knowledge of Oracle data types and Data Definition Language (DDL)
- Strong SQL skills
- Scripting
- UNIX – Linux/Solaris
- Data governance and data quality
- Extract, Transform and Loading of large datasets
- Oracle database privileges
- Oracle Datapump and SQLLoader
- leading the sourcing, extracting, transforming, loading and providing access for data within the NHSBSA’s data warehouse(s)
- using their expertise to provide highly complex data to drive the development of business intelligence and insight, ensuring data are extracted from a wide range of business systems and transformed for loading in the data warehouse
- implementing plans, with project and data analytics teams to deliver data requirements to improve information, data analysis and reporting
- investigating and resolve data issues and anomalies between data sets as well as ensuring that data security and integrity are maintained
- using a range of manual and automated data movement tools and techniques and will work with very large datasets containing data which contains highly sensitive information
- providing and receive highly confidential data (personal information and commercially sensitive) ensuring that the implications for sharing and working with these data sets are understood by users before permitting access to the data in the warehouse
- being responsible for ensuring changes to the ETL technology, and changes to ETL procedures as a result of business system changes, have been tested by approving test plans and reviewing results of testing, also coordinating work with testers
- preparing and update technical documentation for the data entering the data warehouse, ensuring that physical data are reviewed for updates to data dictionaries and gaps in metadata are rectified
- analysing, investigating and resolving complex queries to identify data trends and quality issues
sharing information with IT managers, information governance and data governance to identify system errors, breaches of information security or confidentiality, and determine other causes of data issues, as well as recommending improvements to data management
- developing and training other members of the data acquisition and management team, and the wider business intelligence network
- coordinating work with the team that manages access to the information reports and reporting tools available from the data warehouse for external users
- being responsible for reviewing and planning updates to the ETL technical products, making recommendations for replacement of data warehouse technology
