I am very urgently looking for a software programmer for a long term(4-5 years) duration for a project with following skills- ASP.NET, C#, MVC.NET, Angular.js,JQuery, JavaScript, SQL Server and SQL Server Integration Services(SSIS) on monthly basis -- 2

I am looking for a software programmer for ASP.NET, C#, [login to view URL] ,Angular.js,JQuery, JavaScript, SQL Server and SQL Server Integration Services(SSIS) expert having experience of around 4/5 years in developing web and mobile applications who also have working experience of DevOps and GIT. This is a test task for our projects to test technical skills: Test Task : 1. Create a basic drag and drop schedule using angular using the documentation provided in the attachment link. Preferred technology to be used: Dotnet, Angular (front end) (Material Preferred), SQL Server backend. 2. Run the script in the SQL script to initialize the table and the output. The task is to create a basic stored procedure-based logic to generate Redemption Number based on the Redemption Id and ProductType with these conditions: a. if there is more than one line for a product type add the alphabet to the redemption to separate out the redemption. b. if there is only one line for the product type for a redemption Id then no need to add the alphabet the number will be the redemption ID itself. c. if the redemptions lines are more than 26 i.e overflows the A-Z limit additional lines can be generated as XYZ - AA, AB, AC etc. Please see the attachments- Please let me know if you have any questions on this. As its a long term project so I would hire a programmer only after reviewing his coding skills.