Systems Integration Advisor

NTT DATA Group; Chennai; Presencial; INR 3.000.000 - 5.000.000; Jornada completa

Descripción de la vacante

NTT DATA, Inc. in Chennai seeks a Systems Integration Advisor to design and build the SQL Server data foundation for monitoring solutions, transforming telemetry into traceable, historised, and Power BI-ready information.

You will map sources, model data across raw to serving layers, implement SCD patterns, develop T-SQL, and create robust dashboards. Experience in banking or regulated data platforms is valued.

Formación

• Advanced T-SQL and 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.
• Experience with monitoring, telemetry or operational data.
• Banking or regulated-enterprise data-platform experience.

Responsabilidades

• Design and build the SQL Server data foundation for monitoring solutions.
• Perform source-to-metric mapping for logs and telemetry outputs.
• Design data models across raw, staging, curated, fact and dimension layers.
• Define fact grain, keys, conformed dimensions and SCD history patterns.
• Develop advanced T‑SQL procedures, views and transformations.
• Parse log messages into structured fields for analysis.
• Correlate events using RunContext information.
• Implement duplicate detection and safe rerun strategies.
• Build derived metrics, snapshots and baseline data structures.
• Create approved SQL serving views for Power BI.

Conocimientos

Advanced T‑SQL

SQL Server development

Data modelling

Dimensional modelling

SCD/Snapshot design

Stored procedures & views

Data parsing & transformation

Error handling & auditability

SSDT/DACPAC & Git

Power BI-ready serving views

Monitoring/telemetry data

Banking/regulatory data experience

Herramientas

Git / source-control

Descripción del empleo

Select how often (in days) to receive an alert: Create Alert

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

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, 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.
• Parse dbo.ALETL_Log messages into structured category, object, status, duration, error and correlation fields.
• Correlate processing events using available identifiers and RunContext information without relying only on timestamps.
• Implement duplicate detection, malformed/incomplete event quarantine, auditability and safe 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.
• 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.
• Experience with monitoring, telemetry or operational data.
• Banking or regulated‑enterprise data‑platform experience.

Recommended Experience

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

• 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.

NTT DATA endeavors to make https://us.nttdata.com accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at https://us.nttdata.com/en/contact-us . This contact information is for accommodation requests only and cannot be used to inquire about the status of applications. NTT DATA is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. For our EEO Policy Statement, please click here . If you'd like more information on your EEO rights under the law, please click here . For Pay Transparency information, please click here .