Post by DHANASEKARAN D

Walmart Interview Experience Compensation: 30-35LPA Position: Data Engineer 1️⃣ How would you design a data pipeline to process and analyze customer review data at scale? 2️⃣ Write a SQL query to find customers who placed orders on consecutive days. 3️⃣ Explain the difference between ROW_NUMBER(), RANK(), and DENSE_RANK(). 4️⃣ Daily sales reports suddenly show incorrect numbers after a deployment. How would you investigate the issue? 5️⃣ How would you handle schema evolution in a production data pipeline? 6️⃣ You need to migrate a large on-premise data warehouse to the cloud with minimal downtime. What would be your approach? 7️⃣ Explain the difference between repartition and coalesce in Spark. 8️⃣ How would you optimize a SQL query running on billions of records? 9️⃣ Multiple upstream systems send late-arriving data. How would you ensure accurate downstream reporting? 🔟 How would you implement data validation and reconciliation between source and target systems? 1️⃣1️⃣ Given a string, find the first non-repeating character. 1️⃣2️⃣ Given an array, find all pairs whose sum equals a target value. 1️⃣3️⃣ A streaming application is experiencing message backlog and increasing latency. How would you troubleshoot it? 1️⃣4️⃣ How would you design a monitoring and alerting framework for production data pipelines? 𝗜’𝘃𝗲 𝗽𝗿𝗲𝗽𝗮𝗿𝗲𝗱 𝗮 𝗖𝗼𝗺𝗽𝗹𝗲𝘁𝗲 𝗔𝘇𝘂𝗿𝗲 𝗗𝗮𝘁𝗮 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗞𝗶𝘁 𝗳𝗼𝗿 𝗳𝗼𝗰𝘂𝘀𝗲𝗱 𝗶𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗽𝗿𝗲𝗽𝗮𝗿𝗮𝘁𝗶𝗼𝗻. 👉 𝗚𝗿𝗮𝗯 𝗶𝘁 𝗵𝗲𝗿𝗲: https://lnkd.in/gTAHtzH9 Found this helpful? 𝗦𝗮𝘃𝗲 📌 and 𝗥𝗲𝗽𝗼𝘀𝘁 🔄 it! 🔔 𝗙𝗼𝗹𝗹𝗼𝘄 DHANASEKARAN D for more insights on Data Engineering!