First is a take home SQL test with 2 days deadline, then on-site interview on the office with the user and the the HR. Not getting any info from them afterwards
J'ai postulé en ligne. J'ai passé un entretien chez cermati (Jakarta) en août 2023
Entretien
There were 4 steps overall. First, you will be given a take home test regarding SQL and data analysis. The second one is phone interview with recruiter. Third one is panel interview with BI leads from Indodana and Cermati. Last is interview with VP. I failed at the third one.
Questions d'entretien [1]
Question 1
HR one was pretty basic HR questions like: why choose us, why changing job, expected salary, current package, current responsibilities and etc. The panel interview was more difficult. They are trying to gauge you by what you have done in your previous company, like what the insights and actionable item you can get from your dashboards or reports. Then they will gave you case study: 1. They will show you two tables: transaction and price. They wanted you to: a) take the price of every transactions (easy left join) b) the price table don't have the price for weekends while transactions happens all the time. They wanted to take the price of the last Friday as the price of weekends on that week. (Difficult one) They gave you 10 minutes to do this task. I panicked so I only gave whatever I could think of at the time. 2. You are asked to give idea of a dashboard for credit monitoring performance. They asked you to tell in detail what would be in the dashboard from top to bottom.