Unprofessional and unorganized. Avoid this company.
After an initial call, I was given an assessment that asked questions and scenarios related to HTML, CSS, Excel, and Databases. It turns out that Press Ganey really wanted for the position was fluent CSS knowledge which was not apparent in the job application, instead, they asked for knowledge and understanding of CSS.
After the assessment, I had an awkward, poorly formatted technical interview where I was watched while taking an assessment. The person that I was speaking with did not seem to know what they were hiring for.
Lastly, even if I wasn't ghosted, I would not have accepted an offer due to the awkward and ill-formatted interviews. I did not receive any communication regarding my interview, rather I was ghosted by the company.
Perguntas de entrevista [2]
Pergunta 1
SQL questions:
1. List all providers who’s last name is “Smith” and are part of an active organization.
2. Count how many providers are working at more than 1 location and are linked to an active
account.
3. For each organization, count the number of providers that are not working at any location and
have been added to an account after Jan 1st 2021
Excel Questions:
1. Split the full name column in 2 by adding one column populated with the first name and one
column with the last name
2. Color-code the people with an age above the average of this dataset
3. Compile a list of unique locations (some addresses might have different formats but point to
the same location), and count how many people are associated with each of them