Data Tester - Data Warehouse


Premium Job From Spring Group Plc

Recruiter

Spring Group Plc

Listed on

25th June 2018

Location

Chester

Salary/Rate

Negotiable

Salary Notes

Negotiable

Type

Contract

Start Date

ASAP

This job has now expired please search on the home page to find live IT Jobs.

Data Tester - Data Warehouse

Chester

6 Months

As a Data Tester you will be required to test development changes to the data warehouse, data migrations and other elements of the project built internally for The Client. With a detailed understanding and working knowledge of data warehousing, facts and dimensions and ETL processes you will assist in the Data Warehousing project team to produce high quality work effectively and efficiently. You will also be expected to provide specialist data test knowledge and support for your team and other data testers as required.

We know environment is important:

Working for this award winning business you will get the opportunity to work in their Chester office designed to be open planned and enhance the collaborative experience. Their dress code is informal and they have invested heavily in creating a friendly and supportive environment. They are all passionate about the product they deliver and the market leading service they offer!

Responsibilities:

*Identify, plan and execute appropriate testing for all types of internal warehouse related change

*Perform various types of testing for ETL, Data Warehouse loads both manual and automated

*Analyse test results and translate into meaningful data, providing a clear, concise conclusion

*Continuously identify, discuss and implement test improvements to maximise effectiveness and efficiency within the team

*Improve quality of change delivered by ensuring close collaboration with relevant parties

*Build and maintain effective working relationships and close communication with colleagues and other areas of the business

*Adhere to Test team processes and procedures where required but utilise own judgement to question and offer improvements where appropriate

*Create and maintain test documentation, including scripts (automated and manual), processes and procedures

Essential:

*Knowledge of testing ETL jobs from Ab Initio/Talend or other similar ETL tools

*Very strong SQL skills, can write complex queries and test cases in SQL

*Can perform Source and Target data comparisons performing validation/verification of the data loads

*Ability to clearly and accurately identify test requirements

*Ability to plan, schedule and execute various forms of testing

*Ability to analyse test results and form and communicate a conclusion

*Ability to analyse defects raised and perform analysis before handing over to the development team

*Ability to perform impact & risk analysis and to take appropriate action to mitigate

*Excellent knowledge of industry best practices, methodologies, techniques, tools, resources and data legislation

*Ability to understand data flow in the system and analyse schema diagrams

*Ability to test data driven software applications

*Excellent organisation, planning and prioritisation skills

*Ability to work with others to maximise effectiveness and ensure a quality product

*Ability to clearly and accurately identify test cases from mappings documents/requirements

*Skilled in various types of testing including but not limited to functional, performance, security, risk based & exploratory testing

*Able to identify some key risk area's around data and how we might mitigate these

*Knowledge of any of the following tools Microsoft SQL Server 2008 and above, or Oracle, Vertica

*Knowledge of any of the following languages: - T-SQL, Oracle, Postgres

Nice to have:

*Recognised qualification in Testing (ISEB/ISTQB/BCS)

*Commercial awareness

*Ability to provide estimates at all stages where required

*Experience of compiling reports

*Knowledge of release management tasks

*Experience of analysis of requirements and writing user stories

*Experience of identifying test requirements from various sources, including IT Technical resources

*Experience in documenting test processes and procedures

*Experience of generating test data and obfuscating test data

*Experience with Big Data tools

*Experience in testing with Vertica

*Worked with data cubes - testing fact tables and dimensions

*Familiar with Kimball Methodology in Data Warehouse design

What do you need to excel in this role?

This role offers the opportunity to work in the Technology environment, significantly contributing to the efficient and effective delivery of new projects and changes for the business. The role involves interaction with many teams across the company.

Spring acts as an employment agency for permanent recruitment and an employment business for the supply of temporary workers. The Spring Group UK is an Equal Opportunities Employer.

By applying for this role your details will be submitted to Spring. Our Candidate Privacy Information Statement explains how we will use your information - please copy and paste the following link in to your browser: www.spring.com/candidate-privacy-information-statement

You are currently using an outdated browser.

Please consider using a modern browser such as one listed below: