9. You have decided to delete doctors that contained the name ‘John’ in their name. You have a function in the lib schema called item_remove where the first item in the function is the table and the second item is the provider_id. Write a shell script that will connect to the database and loop through the provider_id into the function.
Apart from the weird/non related questions by devops guy, interview was mostly focused on fundamentals of data engineering. VP round was mostly focused on software development fundamentals.
Describe a project you're proud of
What is your weakness point
If you have a raw dataset, what will you do? Explain how are the steps your programming skill applies on this dataset.
What are some of my strengths.
How will you predict if i ask you how many people are going to wear red T-shirt on a following day in New York city.
How do you deal with missing data?
How is CNN different from other neural networks? When would you use it?
Given Email-id of the sender, location, timestamp, id, subject of the mail and mail content. Come up with a way to appropriately classify mails as Spam or No-Spam. Labels for the dataset is given(Supervised). How will you vectorize the input? Also write code for classification algorithm. How would you use sender's id, location and timestamp to your benefit?
Viewing 1531 - 1540 interview questions