Req ID: 391652

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).
SQL Server Data Engineer

Job Description

Design and implement a scalable, time-series SQL Server data model for SSAS monitoring. Translate SSAS health, processing, workload, dimension growth, DMV, Extended Events, threshold, and derived metric requirements into appropriate tables, facts, snapshots, configurations, and reporting views. Develop advanced T-SQL procedures, transformations, event correlation, incremental loads, audit controls, exception handling, restart ability, and performance optimization. Ensure accurate historical trending, datetime filtering, data lineage, reconciliation, and Power BI integration. Maintain all database objects using SSDT and Git, produce validated DACPAC deployment packages, and support testing, controlled deployment, rollback,



production validation, technical documentation, and knowledge transfer to ICBCS support teams after deployment.

Key Responsibilities

• Perform source-to-metric traceability and define metric lineage.

• Define subject areas, dataset grains, entities, relationships, and conformed dimensions.

• Design logical and physical models covering raw, staging, curated, dimension, fact, configuration, and serving layers.

• Design snapshots, effective dating, SCD history, indexing, and partitioning.

• Implement the SSDT database project, schemas, tables, facts, dimensions, snapshots, configuration objects, and serving views.

• Develop ALETL log parsing, event correlation, stored procedures, and SQL Agent processes.

• Implement configurable threshold, baseline, collection, and routing structures.

• Perform developer unit testing for schemas, data flows, SCD processing, facts, snapshots, conf

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