SSAS testing

JD

Core Responsibilities

Design and maintain OLAP cubes

and tabular models using SSAS.

Optimize multidimensional queries

and manage data aggregation strategies.

Collaborate with Power BI and SSIS

teams

to ensure seamless integration across reporting platforms 1.

Monitor and troubleshoot SSAS performance issues , including memory usage, query latency, and processing times.

Support AMS (Application Management Services)

for SSAS platforms, ensuring 24x7 uptime and SLA adherence 3.

Technical Skills Required

Strong expertise in

SQL Server technologies : SSAS, SSIS, SSRS.

Experience with

ETL workflows, batch job management , and

performance tuning .

Familiarity with

ITSM tools

like ServiceNow for incident and problem management 3.

Exposure to

BI tools

and

cloud platforms

(Azure, DaaS / IaaS) is a plus 4.