🚩🅸🅽🆃🆁🅴🆅🅸🅴🆆 🅴🆇🅿🅴🆁🅸🅴🅽🅲🅴- 𝑻𝒆𝒏𝒂𝒏* (🆂🆃🅰🆁🆃🆄🅿)-1
✏️ There are a total of 4 rounds:
💡 Lead Technical (Round 1)-Virtual
💡 Manager Interview (Round 2)-Inperson
💡 Director Interview (Round 3)-Inperson
💡 HR Interview (Round 4)-Inperson
Result: Reached HR Round but No Offer Letter Released
Lesson Learned: Need to better prepare for HR discussions
𝐑𝐨𝐮𝐧𝐝-𝟏
----------------------------------🆂🆀🅻-------------------------------------------
Question-1:
Given the data for products over several days:
📌 Write a SQL query to get Calculate the difference in quantity for each product compared to the previous day.
📌 Write a sql Query Identify any two days where the quantity was lower compared to other days for each product in the following data:
Product Day Quantity
A 1 10
A 2 6
A 3 21
A 4 9
A 5 19
B 1 12
B 2 18
B 3 3
B 4 6
B 5 23
📌 Write a SQL Query to Employee name & manager name
emp_id, emp_name, manager_id
1 'Zaid' 3
2 'Rahul' 3
3 'Raman' 4
4 'Kamran'
5 'Farhan' 1
----------------------------------🅿🆈🆂🅿🅰🆁🅺--------------------
📌 Create a dataframe & define the schema in Pyspark
input-employee_name, department,salary
📌 Question-Write the SQL Code
Drop the duplicates
Every Department Highest Salary
📌 Write it in both SQL & Pyspark
input - city,gender,Spent_amount
output-city,total_spend,female_spend,male_spend
📌 What is an Index & different types of indexes?
📌 Under what conditions should we use Normalization and Denormalization?
📌 Why should we choose Snowflake over Redshift?
📌 What is the difference between SparkContext and SparkSession?
📌 What are the differences between RDD and DataFrame, and how is DataFrame fault-tolerant?
📌 Why is RDD not commonly used nowadays?
-----------------------🆁🅾🆄🅽🅳 2 🅱🆈 🅼🅰🅽🅰🅶🅴🆁---------------------
📌 Questions related to your project
📌 What are the drawbacks in your project that you think you can improve?
📌 Share a real-time scenario where you worked on PySpark job optimization.
📌 How do you estimate data migration optimization?
📌 How do you ensure data validation, data security, and data quality? Explain a use case where you implemented these practices.
-----------------------🆁🅾🆄🅽🅳 3 🅱🆈 DIRECTOR ---------------------
-
📌 Project Discussion
📌 Discussion on AWS Services
📌 Explain your approach to designing a complete solution
📌 Why do you want to join a startup?
📌 How will you fit into the culture, given your background in the banking industry?
-----------------------🆁🅾🆄🅽🅳 4 🅱🆈 HR ---------------------
📌 Introduction and Background Discussion
📌 How they align with this role
📌 How you will align yourself from Banking to a Startup
📌 Technical and soft skills pertinent to the role
📌 Examples of how you’ve adapted to new environments and challenges
📌 How you will fit into the startup culture
📌 What drives you to learn new tools and technologies
📌 Examples of successful teamwork and collaboration
📌 Where you see yourself in the next 3-5 years
📌Salary Discussion
#intreviewExperience
#dataenginner
