Data modelling, SQL, Advanced SQL, Python, ETL.
Data Interview Questions
133,957 data interview questions shared by candidates
Indexing in SQL. Types of Joins. Difference between Truncate & Delete. Query for salary of second last employee in a record. Basic SQL questions.
1)Hive, Spark, Java and Python
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.
Viewing 1531 - 1540 interview questions
See Interview Questions for Similar Jobs
Computer OperatorDatacenter TechnicianNoc OperatorConfiguration Management AnalystCirculation ManagerMedical ClerkManager AnalyticsMailroom ClerkMail SorterMedical Office ReceptionistMedical Office ClerkMail Room ClerkMedical Record Retrieval SpecialistManual Software TesterMedical Office SpecialistManager Marketing AnalyticsMedical Claims ProcessorMedical Billing ClerkMarketing Analytics Manager