Systems Integration Advisor
ChennaiFull-time8–14 yrsPosted over a month ago
Leadership software engineering role at NTT Data in Chennai. Needs 8+ years.
About the role
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.
What you'll do
- Perform source-to-metric mapping for ALETL logs, RunContext, 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
- Correlate processing events using available identifiers and RunContext information without relying only on timestamps
What you need
- SQL
- Git
- Power BI
- Data structures
- SQL Server
- Data modelling
Good to have
- Unit testing
- Reconciliation