Assistant Manager - J37814

Sampoorna Computer People
  • Gurgaon
  • 12-18 lakh
  • 6-9 years
  • Views
  • 21 Apr 2017

  • IT/ Information Technology

  • IT/ Technology - Software/ Services
Job Description

T-sql with Ssas-
a. Experience with Visual Studio in creating tabular models
b. Knowledge of MS SQL Server Analysis Services (SSAS)
c. Proficient in writing SQL queries and views
d. Proficient with the DAX language
e. Have knowledge of basic database concepts including schema layout, primary keys, and foreign keys
f. Proficient with pivot tables


a. Familiar with data warehousing / data mining
b. Able to use Performance Monitor to measure efficiency and bottlenecks when processing SSAS tabular models
c. Familiar with BIDS Helper
d. Able to use DAX Studio
e. Able to script SSAS process in MS Sql Server Management Studio
f. Familiar with compression strategies
g. Optimizing SQL queries to increase performance for end user
h. Understanding of Active Directory / Network user groups for security
i. Understanding of XMLA code
j. Familiar with Team Foundation Server (TFS)

Competencies/Skill sets for this job

Data Warehousing Data Mining Sql Ssas

Job Posted By

Account Manager

About Organisation

Sampoorna Computer People