NTT DATA Senior Data Engineer Interview Question and Answer | Tips & Tricks Covered
Create Statement :
================
--Task : Detect strictly decreasing qty for any rolling 3-month window.
CREATE TABLE monthly_sales (product_id INT, year_month DATE, qty INT);
INSERT INTO monthly_sales VALUES
(1,'2025-06-01',100),(1,'2025-07-01',90),(1,'2025-08-01',80), -- declining
(2,'2025-06-01',50),(2,'2025-07-01',60),(2,'2025-08-01',55);
--input
select *
from monthly_sales;
🔔 Don't forget to Like, Share, and Subscribe to DEwithDhairy for more Data Engineering content!
Need Help ? Connect With me 1:1 - https://topmate.io/dewithdhairy
Let's connect on LinkedIn : / dhirajgupta141
pyspark 30 days challenge : • pyspark 30 days challenge
top interview question and answer in pyspark :
• top interview questions and answers in pys...
PySpark Installation and Setup : • Spark Installation | PySpark Installation ...
DSA In Python Interview Series : • dsa for data engineer | dsa for data analy...
PySpark Interview Series : • pyspark interview questions and answers
Keywords :
==========
NTT Data SQL interview questions
NTT Data Senior Data Engineer interview questions
NTT Data Data Engineer interview preparation
NTT Data SQL coding interview
SQL interview questions NTT Data
NTT Data interview experience Data Engineer
Senior Data Engineer SQL interview NTT Data
NTT Data technical interview questions
SQL scenario based interview questions NTT Data
NTT Data Data Engineer interview 2025
SQL interview preparation for NTT Data
NTT Data interview tips for Data Engineer
NTT Data Business Analyst SQL interview
SQL coding questions for NTT Data interview
Top SQL interview questions for NTT Data
Data Engineer interview questions NTT Data
NTT Data hiring process Data Engineer
NTT Data SQL case study interview
Data Engineer interview 2025
#dataengineering #sql #interview #technology