Minimum 7 years of IT Experience, in Data warehousing projects on MS SQL space.
Strong T-SQL Programming experience with ability to produce production-quality code complete with internal documentation.
Ability to quickly analyze existing T-SQL code and make improvements to enhance performance of queries, transactions, exception handling and take advantage of new SQL features, close security gaps, and increase robustness and maintainability of the code.
Develop and maintain SSIS packages, and ability to do Data Migration from different sources to SQL Server.
Good understanding of SQL Server database design concepts and ability to understand the underlying data model, to develop optimized code.
Experience in SSRS reports development.
Experience in processing huge volumes of data
Understand the performance measures that impact the application; create solutions to remove bottlenecks across any layer (reports/environment/extraction layer/database) to ensure that the overall application SLAs can be met
Create performance oriented code
Understanding of the data warehousing concepts - including Snowflake and Star schema and normalization concepts
Preparing scripts / tools to help automate development and testing, as appropriate
Perform exhaustive unit testing and deliver defect-free product
Good understanding of the full development life cycle, development methodologies, and version control.
Be responsive. Take accountability for deliverables.
Solid teamwork and interpersonal skills; ability to work well on cross-functional project teams and foster team commitment to tasks.
Strong written, verbal, and graphical communications skills with the ability to express complex technical concepts effectively
Ability to work well with people from different disciplines with varying degrees of technical experience
Ability to work both independently and with minimal guidance, as well as with a team.
Interest and ability to learn new technologies, a tireless appetite for learning new things.
C# and .NET MVC - although the project is mostly about data, there is also an in-house app called Plato built using C# and .NET MVC and if the dev knows these technologies, the more the resource can contribute
Angular JS and React JS - Front-end of the Plato app. At the moment, Plato is using Angular and the client may look to refactor the code and transition from Angular to React. This was mentioned to me last year that they may re-code the front-end to use React. With the familiarity of the resource on the different applications, this will be a good initiative and seize new SOWs.