I applied through university. I interviewed at Mastek (Ahmedabad) in Aug 2023
Interview
Gd Aptitude L1 interview L2 interview The interview was kind of difficult but not that much difficult. They wanted to test my sql skills . Also they want some hands on knowledge of java
GD
Aptitude test
Interview Level 1(technical and logical questions)
Interview level 2(technical questions about project worked upon and HR questions )
I went through all the stages and passed it but later rejected it due to its bond.
Interview questions [1]
Question 1
SQL query about group by, aggregate functions and having clause
First round is Group Discussion
Second round is based on SQL and PL SQL concepts , All type of commands ddl,dml,dcl,TCL,dql, Clauses , Aggregate Functions, joins,operators, What is SQL databases and basic queries
Interview is very tough.There are 4 rounds.Aptitude, Group discussion, Technical round,HR round.The questions are from Java,Data structures and algorithms,python,SQL,OS. Take more care on java basics and python basics.As my role is oracle technical consultant so they focus on java