I applied online. The process took 2 months. I interviewed at Celonis in Dec 2023
No offer
Positive experience
Average interview
Application
I applied through an employee referral. The process took 1 week. I interviewed at Celonis (Bengaluru) in Sep 2023
Interview
There will be around 5 rounds I applied via refferal First HR recruiter screening Second SQL assessment you have to score 50% Third one to one interview (technical) Fourth case study round Fifth and sixth upline more like behavioural or with director HR has been the best during the whole recruitment process,very responsive,helpful and prompt.
Interview questions [1]
Question 1
He asked qs on SQL like cte, constraints,2 SQL queries,one challenging situation at work place,what all have you used or worked on ,nothing from my projects,when to use which database,is azure olap or oltp,things to make sure while loading data into database like data redundancy,when will be the first thing you need to ask customer while setting up a database,how do you differentiate between b2b or b2c via source system.The interview is not grilling or too much technical,it was very basic that you must have used already in your projects but be through with the business knowledge and the data being used since the interviewer sounded very sound with the techno business knowledge and you need to be in a facing role in this job profile.I wish he would have grilled more on technical aspects but it's just 30 mins so makes sense. The interviewer was quite intimidating,late for interview and no proper net connection:P
I interviewed for the Galaxy program at RDU.
A phone screen in the first round.
An interview with a Project Manager for the second round.
An SQL assessment in the third round.
A consultant challenge that required over 15 hours of training, Followed by a project/demo that you will present to the PM and a senior consultant.
A final round with an executive.
-- The instructions of the challenge were very broad from my experience what they want is someone who is client-centered. They don't care if you learn the training material and most of the questions were about bringing the dollar amount to the table by leveraging Celonis Solutions. Good Luck!
Interview questions [1]
Question 1
Q:
Tell me about yourself.
Why are you applying for this position?
How would you explain our technology to a client?
Filter an activity in your analysis.
How is the source system connected to the EMS platform.