NTT DATA Global Delivery Services Ltd

Systems Integration Advisor

NTT DATA Global Delivery Services Ltd
Chennai
Not disclosed
Work from OfficeWork from Office
Full TimeFull Time
Min. 8 yearsMin. 8 years

Job Description

Systems Integration Advisor

Req ID: 392699 

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, apply now.

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

Whenever possible, we hire locally to NTT DATA offices or client sites. This ensures we can provide timely and effective support tailored to each client’s needs. While many positions offer remote or hybrid work options, these arrangements are subject to change based on client requirements. For employees near an NTT DATA office or client site, in-office attendance may be required for meetings or events, depending on business needs. At NTT DATA, we are committed to staying flexible and meeting the evolving needs of both our clients and employees. NTT DATA recruiters will never ask for payment or banking information and will only use @nttdata.com, @nttdatafed.com and @talent.nttdataservices.com email addresses. If you are requested to provide payment or disclose banking information, please submit a contact us form, https://us.nttdata.com/en/contact-us.

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.

Experience Level

Senior Level

Job role

Work location
Work locationChennai, TN, IN
Department
DepartmentData Science & Analytics
Role / Category
Role / CategoryData Science & Machine Learning
Employment type
Employment typeFull Time
Shift
ShiftDay Shift

Job requirements

Experience
ExperienceMin. 8 years

About company

Name
NameNTT DATA Global Delivery Services Ltd
Job posted by NTT DATA Global Delivery Services Ltd

Similar jobs you can apply for

Manufacturing / Production
Ambit Business Consultants

Engineering Trainee

Ambit Business Consultants
Moolakadai, Chennai
₹18,000 - ₹20,000
Work from Office
Full Time
Freshers only
No English Required

Laptop Service Technician

JS Computers
Porur, Chennai
₹30,000 - ₹42,000*
Field Job
Part Time
Full Time
Min. 2 years
No English Required
Aishka Technology Solutions Private Limited

Hardware & Network Engineer

Aishka Technology Solutions Private Limited
Chennai
₹18,000 - ₹22,000
Field Job
Full Time
Min. 1 year
Basic English
Lepay Services India Private Limited

Computer Hardware Technician

Lepay Services India Private Limited
Saidapet, Chennai
₹15,000 - ₹25,000
Work from Office
Full Time
Min. 1 year
Basic English
Bluspring

Junior Engineer

Bluspring
Viraraghavapuram, Chennai
₹23,000 - ₹45,000
Work from Office
Full Time
Min. 3 years
Basic English
Jeeves Consumer Services

Laptop Repair Technician

Jeeves Consumer Services
Chennai
₹23,000 - ₹27,000*
Field Job
Full Time
Min. 6 months
No English Required

You can expect a minimum salary of 0 INR. The salary offered will depend on your skills, experience and performance in the interview.

The candidate should have completed the required education and people who have 8 to 31 years are eligible to apply for this job. You can apply for more jobs in Chennai to get hired quickly.

The candidate should have sound communication skills and sound communication skills for this job.

Both Male and Female candidates can apply for this job.

No, it's not a work from home job and can't be done online. You can explore and apply for other work from home jobs in Chennai at apna.

No work-related deposit needs to be made during your employment with the company.

Go to the apna app and apply for this job. Click on the apply button and call HR directly to schedule your interview.

The last date to apply for this job is . For more details, download apna app and find Full Time jobs in Chennai . Through apna, you can find jobs in 64 cities across India. Join NOW!