I applied through a recruiter. The process took 4 weeks. I interviewed at Sime Darby Industrial (Shah Alam) in Dec 2023
Interview
It will be a technical interview where they focus on your abilities and past experiences in using SQL, Power BI and performing Data Modelling. Then there will be a portion of behavioural based interview (BBI) where they will ask questions to gauge your stakeholder management skills, time management and prioritisation skills, problem solving skills.
Interview questions [1]
Question 1
How do you retrieve all columns from a table named "employees"?
What is the purpose of the SELECT statement?
Write a query to calculate the average salary of employees in a table named "salaries".
What is a subquery, and how is it different from a JOIN? Provide an example.
What is a stored procedure, and how can it be beneficial in a database environment?
How do you optimize a slow-performing SQL query?
Can you explain how to remove duplicate records from a table in SQL?