I applied online. I interviewed at Franklin Templeton in Apr 2025
Interview
The interview focused on Python, SQL, and ETL skills. I was given some coding questions to solve during the first round. While the Python questions were relatively easy, the SQL questions were of an advanced level. They also asked a few data warehousing-related questions. The interviewer was very encouraging and aimed to assess my problem-solving abilities. Overall, it was a positive interview experience.
Interview questions [1]
Question 1
What is the difference between star and snowflake schema