Sonata Software North America
Agoura Hills, California, United States
Job type: fulltime
Job industry: I.T. & Communications
Seeking for Sr Developer MSBI
Location Agoura hills, CA, USA
Start Date Sep-19
Duration 6 months + 1 year.
Min. 8+ experience in implementing applications built using Microsoft Business Intelligence tools Microsoft SQL Server Database, T-SQL, SSIS,SSAS(MDX), SSRS
Strong skills in MS SQL / T-SQL Development (queries, stored procedures, views, triggers, functions) and Performance Optimization Experience.
Knowledge on AWS is a plus
Should have Data Warehouse Data Modelling design experience.
Expertise in T-SQL, Stored Procedure development.
Ability to take complete ownership of building MS BI solutions from start to rollouts
Design and develop Extraction, Transformation and Loading (ETL) processes using SSIS
Design, Configuration and Deployment of Packages
Usage of Scripts Task
Error handling and Error Logging
Scheduling Packages and Security
Design and develop cubes using SSAS
Using Cube data in SSRS
Good Communication skills
Adaptable to new technologies