J.P. Morgan Data Engineer II interview questions

1. Write a code in python to print only duplicates in the list, 2. How do I use pandas to filter rows by ID, sort by order number, and reshape the amounts into separate columns like amount_1, amount_2, amount_3 in a single output row?” 3. Question oin SCD type 2 logic in SQL 4. Pyspark questions like spark achitecture, repartion & Coleasce, Explode function, Broadcast join, ETL Scenarion based questions like how would you handle if there is fail in pipeline or if query is taking more time. 5. Difference between ETL & ELT, Asked me t expalin my current project pipeline End to end