Celonis Interview Questions, Process, and Tips

Types of joins in SQL include inner join, left join, right join, and full outer join.

• Inner join: Returns rows when there is a match in both tables.

• Left join: Returns all rows from the left table and the matched rows from the right table.

• Right join: Returns all rows from the right table and the matched rows from the left table.

• Full outer join: Returns rows when there is a match in either table.

Process mining is like a digital detective that analyzes event logs to uncover how processes are actually being executed.

• Process mining uses event logs to reconstruct and visualize processes

• It helps identify inefficiencies, bottlenecks, and deviations in processes

• Examples include analyzing customer journey on a website or tracking the steps in a manufacturing process

The most technical project I worked on was designing a complex valuation model for a large infrastructure project.

• Developed a detailed financial model incorporating various factors such as cash flows, discount rates, and risk assessments

• Utilized advanced Excel functions and financial modeling techniques to accurately value the project

• Collaborated with cross-functional teams to gather relevant data and ensure accuracy o...read more

Roberta and Deberta are both transformer-based language models, with Deberta being an extension of Roberta.

• Roberta is based on BERT architecture while Deberta is an extension of Roberta with dynamic masking and disentangled attention mechanisms.

• Deberta introduces two new techniques: disentangled attention mechanism and dynamic masking, which help in capturing long-range dependencies and improving performance on downstr...read more

RAG (Red, Amber, Green) techniques are used in project management to visually indicate the status of tasks or projects.

• RAG techniques involve assigning colors to tasks based on their status - red for critical issues, amber for potential issues, and green for on track.

• These techniques help project managers quickly assess the status of multiple tasks or projects at a glance.

• RAG reports are commonly used in project meetin...read more