Description
The objective of the job:
Design, development & support on SQL server solutions:
- Application/operational relational databases based on SQL Server 2014 or higher including SSIS/SSAS Tabular.
- BI solutions (analysis/reporting/dashboarding) based on SQL Server 2014 or higher including SSIS/SSAS/PBI/DAX.
- Support on user requirements gathering & analysis, functional & technical analysis of specific requirements when related to SQL server ETL or BI.
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 on Power BI
Technical experience required:
- Good knowledge and hands-on experience in SQL Server SQL Server 2014 and SQL 2017 (tables, views, triggers, unions, joins, complex queries, T-SQL & stored procedure programming.
- Good knowledge and hands-on experience in ETL (SSIS)
- Knowledge of BI reporting: OLAP SSAS tabular design & implementation & overall framework
- Knowledge of Power BI
- General Knowledge on SQL server working