MOD, Defence Equipment and Support

Information Server DataStage ETL Developer

Incomplete application

1
Incomplete application
0 SME, 1 large

Completed applications

4
Completed applications
3 SME, 1 large
Important dates
Opportunity attribute name Opportunity attribute value
Published Thursday 25 July 2019
Deadline for asking questions Thursday 1 August 2019 at 11:59pm GMT
Closing date for applications Thursday 8 August 2019 at 11:59pm GMT

Overview

Overview
Opportunity attribute name Opportunity attribute value
Specialist role Developer
Summary of the work Working in a joint MOD team to maintain and support Supply Chain & Engineering middleware solutions & data feeds, in fulfillment of large scale contracting for availability and contracted logistics supply contracts.
Latest start date Tuesday 1 October 2019
Expected contract length 24 months with option of 6 months extension
Location South West England
Organisation the work is for MOD, Defence Equipment and Support
Maximum day rate Up to £900.00 per day, inclusive of travel and subsistence; no other fees to be charged

About the work

About the work
Opportunity attribute name Opportunity attribute value
Early market engagement None
Who the specialist will work with 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 comprises of system designers, analysts, architects and data SMEs
What the specialist will work on Working primarily in IBM Information Server DataStage 11.5, (currently upgrading from 8.7) part of their Infosphere toolkit there is a need to develop and test against emerging requirements for business to business, data integration and data migration services. This will include new customers of existing services, new data source requirements and new delivery endpoints working with new and existing stakeholders within industry and internal to MoD.

Work setup

Work setup
Opportunity attribute name Opportunity attribute value
Address where the work will take place RNAS Yeovilton, Yeovil. Somerset BA22 8HW
Working arrangements Five days a week on-site working as part of a technical in-house team and reporting to the team leader who will allocate work priorities. DE&S IT will be provided. This post does not support remote working.
Security clearance SC Clearence is required prior to commencement of the contract

Additional information

Additional information
Opportunity attribute name Opportunity attribute value
Additional terms and conditions We reserve the right to extend for 6 months.
We will follow MOD T&S, however at the beginning of each SOW we will have a conversation with the winning supplier to understand any travel required to other sites. This position has been assessed against the Crown Commercial Services framework as being outside of IR35.

Skills and experience

Buyers will use the essential and nice-to-have skills and experience to help them evaluate suppliers’ technical competence.

Skills and experience
Opportunity attribute name Opportunity attribute value
Essential skills and experience
  • Must have very strong understanding of SQL, including the execution and use of functions and stored procedures for Oracle, Informix, DB2 & Teradata DBMS (min 3 yrs experience) - 1%
  • Must demontsrate 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 - 1%
  • Must demonstrate their ability to read and understand DataStage code, in particular Universe code & procedures and set application parameters - 2%
  • Must be able to write and develop DataStage code (min 3 yrs experience) - 2%
  • Must demonstrate their experience and understanding of Entity Relationship Diagrams and data mapping documentation - 1%
  • Extensive experience in data integration techniques with DB2, Oracle, Informix, Teradata, SQL and Postgres dbms, and MQ & FTP (min 3 yrs exp) messaging & data transfer applications - 1%
  • Must demonstrate in their response their knowledge of Architectural ETL patterns and processes - 1%
  • Must demonstrate in their response their ability to perform Data Quality operations using QualityStage & Information Analyzer - 1%
  • Must have extensive knowledge of developing XML, XML Schemas & XSLTs ((Style Sheet Transformation).(min 1 year exp) - 1%
  • Thorough understanding of the OAGI Supply Open Standards framework (min 1 yr exp) - 1%
  • Must demonstrate in their response their ability to analyse, diagnose and resolve complex logic and coding issues in development and test environments - 1%
  • Must demonstrate in their response their ability to follow strict standards for performing unit and link testing of software component - 1%
  • Must demonstrate in their response their ability to produce module design artefacts, specifically module specifications and logic flow diagrams - 1%
  • Must demonstrate in their response their ability to clearly and confidently communicate with other technical and non-technical stakeholders, both verbally and in writing - 1%
Nice-to-have skills and experience
  • Must clearly define their experience of working with MoD data - 0.5 %
  • Must clearly define their knowledge of Linux operating systems - 0.5%
  • Must clearly define their knowledge of MoD Supply Chain & Engineering Information systems, notably MJDI, GoldESP, LITS - 1%
  • Must clearly define their experience of working within Virtualised environments using Remote access workstations usng Citrix - 0.5%
  • Must clearly define their knowledge of HP's BTO Service Manager for incident management - 0.5%
  • Must clearly demonstrate their understanding of ITIL Service Management functions 0.5%
  • Must clearly define their familiarity with current Software Development Lifecycles & delivery frameworks (e.g. V model, Agile) - 0.5%

How suppliers will be evaluated

How suppliers will be evaluated
Opportunity attribute name Opportunity attribute value
How many specialists to evaluate 3
Cultural fit criteria
  • Demonstrates flexibility (e.g. the Ability to shift tasks to meet changing priorities)
  • Share knowledge and experience with other team members
  • Take responsibility for their work
Assessment methods
  • Work history
  • Interview
Evaluation weighting

Technical competence

70%

Cultural fit

10%

Price

20%

Questions asked by suppliers

Questions asked by suppliers
Supplier question Buyer answer
1. Will you support the SC process? The work will take place at a secure MOD site and SC clearance is required prior to commencement. The timescale for the project start date does not allow sufficient time for SC clearance to be obtained for any applicants that do not already hold it.
2. Is there a current incumbent? There is a current incumbent for the role, which ends on 30 September 2019. The existing role ending 30 September 2019 is based at another UK location.
3. We have a candidate who is located in the North of England, are you flexible with a start time on Mondays and leaving on Fridays assuming at least 40 hrs are spent on-site during the week. There could be some flexibility, but the site security policy restricts work before 07:00 and after 18:30, so any flexibility would be limited.
4. Due to the nature of the role, can we ask if candidates are expected to be UK national. Non UK nationals are not restricted for the role providing they meet all other criteria.
5. Request you to please clarify following: the below mentioned two published MoD-Information Server DataStage ETL Developer roles have been duplicated by mistake or are they two separate roles? They are two separate roles.
6. There is a total of 21 essential and nice-to-have skills, is there any way this can be shortened? It may be difficult for suppliers to secure the best possible talent given the lengthy application criteria, with no guarantee of even an interview? The totality of the essential and nice-to-have skills are considered the best way to obtain a candidate with the range of skills required to fulfil the role.
7. Would NPPV3+SC Clearance suffice? The security clearance for the role is SC.
8. The start date provided is 1st October, this would suggest there would be enough time to clear a consultant to SC, please can you confirm? The time to obtain SC clearance following shortlisting and successful interview is not considered sufficient in this case.
9. Is this inside or outside of IR35? This position has been assessed against the Crown Commercial Services framework as being outside of IR35.
10. We are not in a position to guarantee any individual candidate successful selection and the SC process does not guarantee a successful application, regardless of previous held clearance; therefore, we would be unable to consider candidates that do not currently hold the correct level of security clearance. We are not in a position to guarantee any individual candidate successful selection and the SC process does not guarantee a successful application, regardless of previous held clearance; therefore, we would be unable to consider candidates that do not currently hold the correct level of security clearance.