Req ID: 391653

NTT DATA strives to hire exceptional, cutting-edge and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.

We are currently seeking a Data Engineer Advisor to join our team in Bangalore, Karnātaka (IN-KA), India (IN).
Data Engineer (SSAS Monitoring)

Job Description

Design, implement, and support the SSAS monitoring framework for cube availability, processing performance, sessions, memory, storage, dimensions, partitions, queries, and operational events. Develop SSAS DMV collectors, Extended Events sessions, ALETL log parsing, event correlation, derived metrics, baselines, thresholds, and RAG status. Implement scheduled, auditable, restartable, and low-overhead collection processes using SSAS DMVs, XMLA, Extended Events, T-SQL, and SQL Agent. Ensure monitoring data supports historical trends, datetime filtering, capacity analysis, Power BI reporting, and operational troubleshooting. Support testing, defect resolution, controlled deployment, production validation,



technical documentation, runbooks, and knowledge transfer to support teams.

Key Responsibilities

• Develop a reusable ALETL_Log parser to derive processing category, object, status, duration, and error details.

• Correlate ALETL events with RunContext and SSAS processing events without relying exclusively on timestamps.

• Handle malformed, duplicate, incomplete, and unmatched events while preserving auditability and restartability.

• Pair cube and partition processing start and end events to calculate duration, outcome, and failure reason.

• Establish separate weekday, weekend, and heavy-processing-window baselines.

• Develop SSAS DMV collectors for cube availability, sessions, memory, object storage, databases, partitions, and dimensions.

• Implement scheduled, auditable, restartable, and low-overhead collection using SQL Agent.

• Configure SSAS Extended Events for commands, processing, qu

📌 Data Engineer Advisor (Bengaluru)
🏢 NTT DATA Services
📍 Bengaluru