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!
🔅 To book a Mock interview - topmate.io/ankur_ranjan/15155
𝗝𝗼𝗶𝗻 𝗺𝗲 𝗼𝗻 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:
🔅 LinkedIn - / thebigdatashow
🔅 Instagram - / ranjan_anku
#interview #dataengineering #bigdata #apachespark #careerswitch #job #mockinterview

[@PiBiNi]

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

[@jhonsen9842]

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.

[@GohilMukesh-ez5vb]

😂🎉😢😮😅😊

[@RohanKumar-mh3pt]

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

[@avinash7003]

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?

[@Tech_world-bq3mw]

yes, try learning python, SQL and after that try big data technologies like( Pyspark and Hadoop). And at last prepare personal projects on data engineering on cloud.

[@prajju8114]

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

[@TheBigDataShow]

Please let me know the timeline of the video which has confused you. There might be some issue while editing the video. I will try to explain your doubt.

[@prajju8114]

@@TheBigDataShow 47:35

[@user-np5mr6rv2o]

He is not upto SQL

[@prajju8114]

yep, i can see that clearly

[@prajju8114]

SELECT customerid
FROM orders o
WHERE o.orderdate >= '2023-10-01' AND o.orderdate = 2;

[@avinash7003]

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;