Initial Phone Screen . Interviewer was super helpful. Nice Experience\n\nBehaviourial : 4 Leadership Question\na. Tell me when you said no to customer and how you handle it\nb. Tell time when you helped the team mate who is not able to deliver the work\nc. Tell me the approach you took which benfit the organiztion.\nd. Tell me the most difficult project you handled.\n\n\n\nETL :\nDesign a Ingestion Pipeline which can scale to consume any number of excel/csv file landing on S3 . For example  currently consuming 500 what if it have 2000  tommrrow.Define your approach.\n\nPython:\nhttps://leetcode.com/problems/find-the-difference/\n \n\n\nSQL : \nA seller on amazon seller wants to see his/her  total products and total revenue per day.Design a data model and which data modeling technique you pick (dimensional or ER model) for same and write the sql for it.\n\nWhat is Index and what purpose they serve? What consideration to keep in mind while defining index .\n\nWhat is difference between views,temp table and staging table.\n \n \n \n \n\n\n\n\n\n\n\n\n

Initial Phone Screen . Interviewer was super helpful. Nice Experience\n\nBehaviourial : 4 Leadership Question\na. Tell me when you said no to customer and how y