At first the HR reviewed documents(PAN Card, Degree Certificate) of the candidates present. Next there were two round of interview, in the first round I was asked some basic SQL queries and a few Java questions. In the second round my resume was discussed and questions were asked based on topics mentioned in my resume.
Preguntas de entrevista [1]
Pregunta 1
Write a SQL query to find the second highest salary in an employee salary table.
Me postulé en línea. El proceso tomó 2 meses. Acudí a una entrevista en Accenture (Pune) en nov 2023
Entrevista
The interview process for an SQL Developer typically starts with a resume screening, followed by an initial phone interview to assess basic qualifications and communication skills. This is often followed by a technical assessment, either online or in-person, where candidates are tested on their SQL knowledge, query writing abilities, and problem-solving skills. Successful candidates then proceed to one or more technical interviews, often involving live coding sessions and questions related to database design, optimization, and troubleshooting. The process may conclude with a behavioral interview to evaluate cultural fit and communication skills within the team and organization.
Preguntas de entrevista [1]
Pregunta 1
1. What is the difference between `INNER JOIN` and `OUTER JOIN`?
2. How would you optimize a slow-running query?
3. How do you ensure database normalization, and why is it important?
4. How do you handle duplicate records in a table?
5. What are the advantages of using stored procedures?
1. How would you retrieve the second highest salary from an employee table?
2. How do you ensure data integrity in a database?
3. Describe a situation where you had to improve database performance.
1. How do you handle disagreements within a team about database design decisions?
2. Describe a challenging project you worked on and how you managed it.
3. How do you stay updated with the latest SQL and database technologies?
1. Where do you see yourself in five years?
2. Why do you want to work with our company?
3. What are your greatest strengths and weaknesses as an SQL Developer?
Question we’re not particular to the skill set the hire for, and the assessment is the first process here which again is direct without any guidance about the practical guidance for the exam