Specialist Software Engineer (MSBI, SQL Server)

Primary skills: Advanced knowledge in MS SQL Server 2017 or above. Intermediary knowledge in MSBI (SSIS/SSRS) 2016 or above Experience delivering reporting, database, data integration and cube solutions. Should understand the requirements, analyze and provide quality solutions catering the needs independently Should closely interact with onshore team for requirements and development activities Write T-SQL queries Experience in DTS, SSIS, SSRS, SSAS Create Stored Procedure, Functions, and Triggers etc. Process data migration to SQL Server from various sources Create and maintain database documentation Good interpersonal and communication skills should have worked in a model which required interaction with onshore IT & Business teams Worked on Scrum and Agile way of development & support Secondary skills: Optimization of exiting database & business logic source code. Design, test and deploy database schemas Database performance tuning including identifying bottlenecks with suitable workarounds Create performance benchmark conformance report for newly developed and altered functions. Good problem solving abilities Familiarity with .net technologies (prior development experience will be an advantage) Database analysis and Designing & database design methodologies C#, XML/XSD understanding Advatange to have worked in a pro