JOB DESCRIPTION

Req ID: 392699

We are currently seeking a Systems Integration Advisor to join our team in Chennai, Tamil Nādu (IN-TN), India (IN).

Role Purpose

Design and build the SQL Server data foundation for the monitoring solution, converting raw SSAS/ALETL telemetry into traceable, historised, queryable and Power BI-ready information.

Key Responsibilities

- Perform source-to-metric mapping for ALETL logs, Run Context, SSAS DMVs and Extended Event outputs.
- Design logical and physical data models covering raw, staging, curated, dimension, fact, snapshot, configuration, audit, exception and serving layers.
- Define fact grain, keys, conformed dimensions, SCD/history patterns, indexing and retention design.
- Develop advanced T-SQL procedures, views and transformations for monitoring and observability data.
- Parse dbo.ALETL_Log messages into structured category, object, status, duration, error and correlation fields.
- Correlate processing events using available identifiers and Run Context information without relying only on timestamps.
- Implement duplicate detection, malformed/incomplete event quarantine, auditability and protected rerun/reprocessing patterns.
- Build derived metrics, snapshots, baselines, trends and threshold-supporting data structures.
- Create approved SQL serving views for Power BI and support source-to-report reconciliation.
- Optimise SQL queries, indexes and data structures for expected monitoring volumes and collection frequencies.
- Package database changes using SSDT/DACPAC/Git-aligned deployment practices.
- Perform developer unit testing and support SIT/UAT defect analysis and correction.

Mandatory Skills

- Advanced T-SQL and strong SQL Server development skills.
- Logical and physical data modelling.
- Dimensional modelling: facts, dimensions, grain and conformed dimensions.




- Historisation patterns including snapshots and SCD1/SCD2 where appropriate.
- Stored procedures, views, functions, indexing and query optimisation.
- Log parsing, event correlation and data transformation.
- Error handling, auditability, duplicate prevention and safe rerun design.
- SSDT/DACPAC and Git/source-control based database delivery.
- Ability to build Power BI-ready serving views.

Desirable Skills

- SSAS Multidimensional data/metadata familiarity.
- Experience with monitoring, telemetry or operational data.
- SQL Agent or equivalent scheduling experience.
- Banking or regulated-enterprise data-platform experience.

Recommended Experience

Recommended: 8+ years in SQL Server/data engineering, with robust hands-on experience designing production-grade data models and transformation logic.

Expected Project Deliverables / Contribution

- Logical and physical monitoring data model.
- ALETL parsing and event-correlation logic.
- Raw/staging/curated/fact/dimension/snapshot/configuration/audit structures.
- Derived metric and threshold-supporting SQL logic.
- Power BI serving views and deployment artefacts.

About NTT DATA

NTT DATA is a $30 billion business and technology services leader, serving 75% of the Fortune Global 100. We are committed to accelerating client success and positively impacting society through responsible innovation. We are one of the world's leading AI and digital infrastructure providers, with unmatched capabilities in enterprise-scale AI, cloud, security, connectivity, data centers and application services. our consulting and Industry solutions help organizations and society move confidently and sustainably into the digital future. As a Global Top Employer, we have experts in more than 50 countries. We also offer clients access to a robust ecosystem of innovation centers as well as established and start-up partners. NTT DATA is a part of NTT Group, which invests over $3 billion each year in R&D.;

📌 Systems Integration Advisor (India)
🏢 NTT
📍 India