Technical Solutions Architecture Analyst

- Microsoft SQLServer - T/SQL - Expert - Should know to develop procedures, functions, triggers - Should know performance tuning - Should have worked projects involving large data sets - SSIS - Expert - Should have worked large data loads - Should know parallel execution - Should have worked on performance tuning - SSAS - Intermediate - Should have built cubes, measures. - Should know how to refresh cubes - Should be able to write multi dimension queries - Power BI - Expert - Should have hands on experience in developing multiple types of report - Should have knowledge on how to create custom visualizations - Should have worked on DAX queries - Should have experience in working with large datasets - BigQuery - Beginner - Should be familiar with big query functions (partitioning, windowing etc.) - Should know how to load data into bigquery from external files Primary skill should be 5+ years of relevant skill Secondary skill for Power BI /SQL server, 2+ years of relevant skill and for BigQuery - 1+ year of relevant skill