Proven experience in a (Senior) Software Developer or Software Engineer role
Excellent SQL Database design and delivery skills with a good amount of proven experience
Experience in the delivery of Data Manipulation using the MS SQL Server product (TSQL , stored procedures, functions, DDL, DML, SQL Agent driven batch processes)
Experience in MS SQL Server Integration Services, this being critical to the management of data and interactions with integrated systems (i.e. File transfer management and processing of batch jobs)
Experience in the delivery of MS SQL Server Reporting Services
Ability to establish process from the codebase and understand extremely complex structures
Unit testing mindset when approaching change to legacy codebases
Self-starter with an ‘enquiring mindset’
Ability to perform unsupervised but works well as part of a team/squad
Experience of working in Agile teams and projects
Good communication and stakeholder management
Exposure to large legacy codebases and migration of code/data
Can offer technical leadership to more ‘technically junior’ developer members of the team/squad
Experience in the delivery of SQL Server Analysis Services
Any Project specific Prerequisite :-
MS SQL Server products
Work proactively with existing IT and business staff to increase the understanding of how the entire YorBill and ICE applications work.
Develop detailed and consistent test scripts to logically test the breadth and depth of the solution.
Analyse and define the breadth and depth of test data used by the YorBill and ICE applications as well as working with the SMEs to establish a prioritisation of that data for achieving a sensible balance of risk while executing testing in addition in order to ensure coverage of data types across repeated runs of regression.
Execute scripts in an effective, efficient, and high-quality way; capturing defects, issues and improvements effectively and using the agreed and most effective communication tools.
To be able to develop these scripts into an automated, repeatable testing suite, within the framework of an agreed automation solution.
Be an open and active member of the Agile scrum team operating within a SAFE delivery framework.
Contribute across the complete test cycle of software development from requirements testing to user acceptance and release testing.
Analysing the requirements, user stories, solution designs, and project documentation for performing static testing and providing input to project team members.
Design and produce test scenarios and cases, collaborating with business analysts and development teams to test amended software and their effect on existing systems using best practice testing techniques in-line with the defined test strategy.
Design, develop and execute re-usable and maintainable scripts using available testing tools in line with defined testing frameworks and applicable best practices.
Find, validate and report defects appropriately.
Prepare and publish test progress and product quality reports on a regular basis.
Contribute to continual improvement processes within the QA, Test & Release function.
Contribute to capturing of KPIs to measure the ongoing effectiveness of strategies and processes.