MOD, Defence Equipment and Support
Information Server DataStage ETL Developer
4 Incomplete applications
3 SME, 1 large
5 Completed applications
2 SME, 3 large
Important dates
- Published
- Monday 19 February 2018
- Deadline for asking questions
- Wednesday 21 February 2018 at 11:59pm GMT
- Closing date for applications
- Monday 26 February 2018 at 11:59pm GMT
Overview
- 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 3 April 2018
- Expected contract length
- 12 months with option of 6 month extension
- Location
- East of England
- Organisation the work is for
- MOD, Defence Equipment and Support
- Maximum day rate
About the work
- 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 works with the DE&S Support Chain Information Services (SCIS) Development Partner, BDUK and consists of system designers and business analysts, architectural and data SMEs
- What the specialist will work on
- Working primarily in IBM Information Server 8.7 DataStage (may move to later version within contract period), part of their Infosphere toolkit there is a need to read, develop/amend and test against existing code for the business continuity of the MOD's industry data feed service. 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.
Work setup
- Address where the work will take place
- RAF Henlow. Bedfordshire SG16 6DN
- 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 terms and conditions
-
We reserve the right to extend for 6 months.
We will follow MOD T&S policy, however at the beginning of each SOW we will have a conversation with the winning supplier to understand the travel required. 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.
- 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 (min 3 yrs experience) - 2%.
- 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 - 1%
- Must demonstrate their ability to read and understand DataStage code, in particular Universe code & procedures and set application parameters - 1%
- 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 components - 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 operatings 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 function - 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 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
- 1. Please could you advise the max day rate?
- There is no maximum day rate set and all rates will be considered
- 2. Would you be willing to put candidates through SC Clearance?
- 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.
- 3. What is the IR35 status of the role?
- This position has been assessed against the Crown Commercial Services framework as being outside of IR35.