Description
Business experience required:
- Experience as ETL developer on SQL server platform.
- Experience as a SQL server database developer (tables, views, triggers, unions, joins, complex queries, stored procedures)
- Experience as BI developer on SQL Server based technologies
- Experience as technical architect on SQL Server solutions projects (BI and/or operational DB applications)
- Experience in dashboard & scorecard (with SQL server)
Technical experience required:
- Extensive knowledge and hands-on in SQL Server 2014 and 2017 (tables, views, triggers, unions, joins, complex queries, T-SQL & stored procedure programming).
- Extensive knowledge and hands-on in ETL (SSIS)
- Fluency with appropriate tools including SQL Management Studio, Profiler, Performance Monitor and other SQL Server management tools or related tooling as the MS Office suite.
- General Knowledge on SQL server working
- Extensive knowledge & hands-on Performance tuning & index management
- Experience in solving performance related problems specifically on database applications.
- Extensive knowledge and hands-on experience in reporting with SSRS
- Extensive Knowledge of BI Reporting: OLAP SSAS tabular design, implementation & overall framework
- Good knowledge of Power BI
- Knowledge .NET C# & traditional data access techniques such as ADO.NET
- Knowledge of popular technologies & framework built around SQL Server
- Being aware of best practices, trends & evolutions of the IT industry and most particularly Microsoft SQL Server technologies stacks.
Functional experience required:
- Database modelling via modelling tools such as Erwin or Visio
- Architecture, functional & technical analysis on database, ETL & BI solutions
- Understanding of Best Practices for SQL Server Database, data warehousing, ETL & BI solutions across the Enterprise