Army Headquarters IAS Data Warehouse Tester (ARMYHQ2/00148)

Tender description

Who Speclialist Work With MOD Civil Servants, Military Personnel, Contractors What Specialists Work On Information Application Services (IAS) is a branch of Army Headquarters based in Andover, Hampshire. To achieve its mission, IAS provides IT application development on the Army’s Hosting Environment, and a limited number of web applications on a separate internet hosting environment. IAS has a portfolio of successful Oracle Apex, PHP, and .NET applications developed in-house that support Army branches and their business processes. At the core of this is the Army Data Warehouse, an Oracle DB as a central data repository providing reporting capabilities and data to the various applications. Where the Work Takes Place Army Headquarters, Andover, Hampshire, SP11 8HJ Early Market Engagement N/A Working Arrangements Place of delivery shall be on site at Army Headquarters, Andover. Army Headquarters normal working hours are Monday – Friday 0830 – 1700. Remote working acceptable. On rare occasions the specialist may be required to visit / work from other MOD locations. All specialists must successfully complete the Army HQ Induction Package; this basic package satisfies a range of administrative requirements such as, yet not limited to, health and safety; equality and diversity; and fire awareness. Specialists are to note this is a mandatory requirement. Work Location Army Headquarters, Andover, Hampshire, SP11 8HJ Security Clearance Security Cleared (SC) All incumbents should have the necessary security clearance to be able to access MOD premises and information up to SECRET – UK EYES ONLY; this is the DBS NSV SC level of vetting. Incumbents are to follow both the letter and spirit of Army Headquarters security regulations. Additional T&Cs These MOD DEFCONs form part of this Call Off Contract: 5J (Edn 18/11/16) Unique Identifiers 76 (Edn 12/06) Contractors on site 129J (Edn 18/11/16) Electronic business Delivery Form 516 (Edn 04/12) Equality 520 (Edn 18/11/16) Corrupt gifts and payments of commission 522 (Edn 18/11/16) Payment and Recovery of Sums Due 531 (Edn 11/14) Disclosure of Information 534 (Edn 18/11/16) Subcontracting and Prompt Payment 566 (Edn 07/14) Change of control contractor 642 (Edn 06/14) Progress meetings The following DEFFORMS will be used: 111 Appendix - Addresses And Other Information 10 Acceptance Of Offer Of Contract Skills & Experience Excellent knowledge in data warehouse & database migration. Strong understanding of ETL/BI/Data Warehouse Projects. Proven experience in writing complex SQL queries. Have excellent knowledge of Oracle 10g/11g/12c and RAC. Experience & knowledge of using OWB, OBIEE, APEX Toad,SQL Developer , WinScp & Putty, MobaXterm. Previous experience of testing on Windows and Linux platforms. Ability to plan, schedule and execute various forms of testing. Demonstrable ability to develop, maintain clear and concise documentation to a high professional standard. Competency and proven ability in the use of HP ALM for complete test management of requirements, test cases, execution of tests, defect tracking and reporting. Experience in using test automation tools e.g. HP Mercury QTP/UFT/F#. Competency and proven ability in writing and executing test scripts/scenarios, as well as complex installation guides. The capacity and self-motivation required to meet the demands of the tight timelines and rapidly evolving priorities. Excellent communication and co-ordination skills. A proven ability to resolve problems from first principles as well as from experience. To be able to perform non-functional testing to a high standard without the need of technical direction. The ability to document technical work including their management using SharePoint and the service management tool, Remedy. Experience on Team City/TFS (Team Foundation Server) Experience in Agile software development process and a strong knowledge of testing. Nice to Haves ISEB Foundation/Practitioner Qualification. Experience of working within a defence environment and the ability to work autonomously. Collaboratively agree the test plans in line with the project based on business priorities. Have experience in scoping the types of testing and effort required to deploy each application. At least 7 years’ experience as a Test Analyst/Engineer. At least 5 years’ experience as a Data Warehouse Tester. Experience as a DBA is also desirable. No. of Specialists to Evaluate 3 Cultural Fit Criteria Work as a team within our organisation and other suppliers. Transparent & collaborative when making decisions. Has a no-blame culture and encourages people to learn from their mistakes. Previous experience of working within a Defence environment. Assessment Method Evaluation Weighting Technical competence 50% Cultural fit 10% Price 40% Questions from Suppliers Budget range there is no minimum or maximum day rate. the level of specialist should meet the requirement set out in the advert.