I interviewed at PowerPlan (Atlanta, GA) in May 2021
Interview
1st Interview with HR where they go over your resume and ask you about why are you looking for this job?
2nd Interview with managers and they go over your background and ask you behavioral questions in the first hour and second hour consists of SQL questions.
3rd Interview with Senior Manager to discuss about your background and why power plan
Interview questions [1]
Question 1
1. Explain the difference between INNER JOIN and OUTER JOIN and FULL OUTER JOIN.
2. How would you handle a situation if the client came back to you at the last minute and added an requirement right before the go live? How would you approach this?
3. Can you fetch me this information from the data (SQL test questions)
4. How do you handle your accomplishments?
5. Tell me about the projects you have worked on and why was it interesting to you.
6. Tell me about a time you had an difficult time working with the client and how did you overcome those situations.
I applied through an employee referral. I interviewed at PowerPlan
Interview
Resume review and then multiple rounds of interviews with people managers. It was structured over multiple days and mostly involved interacting with managers in the hiring department as well as the HR department initially.
Interview questions [1]
Question 1
Describe a time where you struggled to work with others.
What's you most significant accomplishment?
Asked to walk through resume several times. Know your resume, and have a few stories to tell to show you're character/work ethic/whatever you want the recruiter to know about you. Two rounds, three interviews: one round over the phone, the second consisting of two interviews. One was with a couple of younger employees, the other with a more senior level title.
Interview questions [1]
Question 1
Tell a story which exemplifies you're technical ability.