Developer /Sr. Developer - SSAS

ERM Placement Services (P) Ltd
  • Bangalore
  • 10-12 lakh
  • 5-10 years
  • 17 Sep 2015

  • IT/ Information Technology

  • IT/ Technology - Software/ Services
Job Description

SQL Server Analysis Services (SSAS)

Extensive hands-on experience on designing, building and optimizing large scale SSAS databases

Strong relational/dimensional data modelling skills

Strong multi-dimensional expression (MDX) language skills.

Worked on at-least 2 Data Warehousing projects.

SQL Server Integration Services (SSIS)

Proficient in implementing all transformations available on the SSIS toolbox.

Excellent knowledge of using variables and expressions in packages.

Experienced in creating master and child packages, package configurations and logging.

Experienced in SSIS package Auditing.

Experienced in SSIS package deployment and Scheduling

Working experience on Master Data Serveries (MDS) and Data Quality Services (DQS)

SQL Server Reporting Services (SSRS)

Experience of creation and implementation of canned reports in SSRS.

Experience of creating Scorecards, chart reports and Dashboards.

Excellent hands on experience on scheduling and the deployment of the reports and uploading files to a report server catalogue from the report manger.

Experience of delivering SQL server reports to SharePoint.

Excellent command on subscriptions, report snapshot and report cache.

Experience of configuring report server and report manager scheduling, giving permissions to different level of users in SQL Server Reporting Services (SSRS).

SQL Server

Expert in designing and implementing relational database and Dimensional model as per business needs.

In-depth knowledge of Transact-SQL (DDL, DML)- creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.

Experience in Performance Tuning and Query Optimization

Experience on tools like SQL Profiler, Index Tuning Wizard and database Engine tuning wizard

Experience in Microsoft SQL Server Database backup & recovery strategies, server logins, database permissions, creating Jobs and schedule DTS/SSIS Packages.

Competencies/Skill sets for this job

MDX SSAS SSIS DTS Sql Sql Server Sql Queries

Job Posted By

About Organisation

ERM Placement Services (P) Ltd