Best Option

Find the right accountancy solution for your requirements

Share
  • Location: Yeovil, Somerset
  • Rate: Up to 0.00
  • Start Date: 13/08/2019
  • Duration: 24 months

 


DataStage ETL Developer – Yeovil – 24 month contract plus extensions


A Government organisation based in Yeovil are looking to hire a 2x DataStage ETL Developer on a 24-month contract to maintain and support Supply Chain & Engineering Middleware solutions & data feeds, in fulfillment of large scale contracting for availability and contracted logistics supply contracts. Working as part of a technical in-house team with responsibility for the development and maintenance of logistics data feeds to industry and other services. The team consists of system designers and business analysts, architectural and data SMEs. Working primarily in IBM Information Server 11.5, (currently upgrading from 8.7), part of their Infosphere toolkit there is a need to read, develop/amend and test against existing code for the business continuity of the industry data feed services. This will include fault determination and prognosis, fault fixes, maintenance release development and testing, impact assessment against application and data source refreshes. Working with those projects to ensure the ongoing business continuity of the service.


  • Outside of IR35

  • SC Clearance is required prior to commencement of the contract


Essential skills and experience


  • Must have very strong understanding of SQL, including execution and use of functions and stored procedures for Oracle, Informix, DB2 & Teradata DBMS

  • Must demonstrate they have strong data management and data handling skills, including experience in handling a wide variety of data types including BLOB, CLOB and unstructured data types

  • Must demonstrate their ability to read and understand DataStage code, in particular Universe code & procedures and set application parameters

  • Must be able to write and develop DataStage code

  • Must demonstrate their experience and understanding of Entity Relationship Diagrams and data mapping documentation

  • Extensive experience in data integration techniques with DB2, Oracle, Informix, Teradata, SQL and Postgres DBMS, and MQ & FTP messaging & data transfer applications

  • Must demonstrate in their response their knowledge of Architectural ETL patterns and processes

  • Must demonstrate in their response their ability to perform Data Quality operations using QualityStage & Information Analyzer

  • Must have extensive knowledge of developing XML, XML Schemas & XSLTs (Style Sheet Transformation).

  • Thorough understanding of the OAGI Supply Open Standards framework

  • Must demonstrate in their response their ability to analyse, diagnose and resolve complex logic and coding issues in development and test environments

  • Must demonstrate in their response their ability to follow strict standards for performing unit and link testing of software components

  • Must demonstrate in their response their ability to Produce module design artefacts, specifically module specifications and logic flow diagrams

  • Must demonstrate in their response their ability to clearly and confidently communicate with other technical and non-technical stakeholders, both verbally and in writing


Nice-to-have skills and experience


  • Must clearly define their knowledge of Linux operatings systems

  • Must clearly define their experience of working within Virtualised environments using Remote access workstations usng Citrix

  • Must clearly define their knowledge of HP's BTO Service Manager for incident management

  • Must clearly demonstrate their understanding of ITIL Service Management function

  • Must clearly define their familiarity with current Software Development Lifecycles & delivery frameworks (eg V model, Agile)


If you are an experience DataStage ETL Developer looking for an exciting contract opportunity – apply for immediate consideration.


Apply