Data Engineering Mock Interview | Myntra

Data Engineering Mock Interview

This exciting new video presents a mock interview with a skilled and experienced Data Engineer. Through insightful questions, we explore the techniques, tools, and technologies that the interviewee has employed in their work, gaining valuable insights into the complex and ever-evolving world of data engineering.

From designing and implementing scalable, high-performance batch processing architectures to working with cutting-edge data processing frameworks like #kafka , #apachespark, Airflow, AWS etc.

Whether you're just starting out in your career or looking to take your skills to the next level, this interview is an essential resource for anyone interested in the fascinating world of real-time data processing and engineering. So don't miss out - tune in now and discover the secrets of success in this dynamic and exciting field!

𝗝𝗼𝗶𝗻 𝗺𝗲 𝗼𝗻 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:

#interview #dataengineering #bigdata #apachespark #careerswitch #job #mockinterview

[jhonsen]

Would you kindly question someone about the hardest problems he overcame and how he handled system design and data modeling? however, a great mock interview. gaining a lot of knowledge.

[PiBiNi]

Amazing Content. Amazing channel... Please keep coming up with such interviews from such companies. Great work @thebigdatashow

[RohanKumar-mhpt]

good mock interview can you please bring some data modeling design questions in your next mock interview

[avinash]

Please make interview on batch processing on AWS bigdata

[Kingstonstraddle]

Hi I’m a mobile automation test engineer so I’m planning to change my current domain from testing to data engineering and is it possible?

[prajju]

wait, where order_date = what? he didnt even mention order_date

[prajju]

SELECT customerid
FROM orders o
WHERE o.orderdate >= '2023-10-01' AND o.orderdate <= '2023-12-01'
GROUP BY customerid
HAVING COUNT(DISTINCT YEAR(orderdate) * 100 + MONTH(orderdate)) >= 2;

[avinash]

WITH EmployeeSales AS (
SELECT
e.employee_id,
e.first_name,
e.last_name,
s.sales_date,
s.sales_amount,
AVG(s.sales_amount) OVER (PARTITION BY e.employee_id ORDER BY s.sales_date
RANGE BETWEEN INTERVAL '1 YEAR' PRECEDING AND CURRENT ROW) AS rolling_avg_sales FROM Employees e JOIN Sales s ON e.employee_id = s.employee_id WHERE s.sales_date >= CURRENT_DATE - INTERVAL '1 YEAR')


SELECT employee_id, first_name, last_name, AVG(rolling_avg_sales) AS average_sales FROM EmployeeSales GROUP BY
employee_id, first_name, last_name ORDER BY average_sales DESC;