EXPERIENCE
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%
