Candidatei-me online. O processo levou 2 semanas. Fui entrevistado pela Kinertia (Reading, PA) em set. de 2024
Entrevista
Job seekers, beware. Waste of time. Don't bother interviewing here (as the other reviews correctly suggest) and don't work here if an offer is made. They got me to speak to multiple people for hours upon hours and even meet them in person only to provide an offer and then rescind it since they couldn't pay the promised compensation... which they were suggesting in the first place because they liked my background and thought I could quickly move into a leadership position. They pay the Accenture analysts $200K so I guess everyone else will be underpaid. They mentioned to me that there may be an opportunity for career advancement but when it came time to setting up those details, they shied away and couldn't promise anything since there just isn't really an opportunity for that here - you should simply shut your mouth and do the work to make the execs rich. The founder/CEO (f/CEO) is very full of himself despite having limited professional success (he established a no-name brand) and not much academic brilliance (he studied football??? and never became a player or coach). The HR department is completely useless with only being available 4 days/week because they're too clueless to know what "work" to fake on the 5th day, Fridays; Hiring more people would definitely make them realize that they're all less than average in intelligence and even more so in value to a business so you're bound to be rejected so they're not found out. There really isn't much of an opportunity for stimulating technical work either as all it is will be SQL analysis, day in and day out, with no real data science analysis despite the f/CEO claiming that this is what is being sold to his one client... but how is that possible when the entire team is just a bunch of analysis with no real formal education or training in anything advanced? See for yourself the turnover that this company has undergone - earlier in 2024, someone left after 3 months. Shows you that this is a volatile workplace where aggressive "executive" personalities dominate with no real justification as to why they are there. Looking forward to working with them though here and there!
Perguntas de entrevista [1]
Pergunta 1
What does ALTER TABLE do?
Moves a table from one database to another.
Transposes the rows and columns in a table
***Modifies a table
When there are multiple conditions and we need to choose something on the basis of these conditions, what function can we use?
CASEBY
***WHEN
IFTHEN
JUMP
What does the following SQL code do?
SELECT name, MAX(salary) FROM Employees WHERE salary < (SELECT MAX(salary) FROM employees); (Notice the mistake in the question here... idiots testing us on concepts they don't know well)
***Returns all the rows that are less than the max salary
Returns the row with the highest salary
Returns the row with the second highest salary
How do you execute a stored procedure in SQL?
EXECUTE procedure_name
PROCEDURE procedure_name
RUN_PROC procedure_name
***EXEC procedure_name
Which JOIN does the following: returns all the values from the right table, plus matched values from the left table or NULL in case of no matching join predicate.
FULL OUTER JOIN
LEFT JOIN
INNER JOIN
***RIGHT JOIN
In Google Analytics, what does the metric "Bounce Rate" represent?
***The percentage of visitors to your website who navigate away from the site after viewing only one page.
The total number of times visitors returned to your website after their first visit.
The number of new visitors to your website compared to the total number of visitors. answer (great, can't even have proper answer choices... the smartest people around)
The average amount of time visitors spend on your website during a single session.
Candidatei-me online. Fiz uma entrevista na empresa Kinertia.
Entrevista
I was invited to complete a Coderbyte assessment - they send a long, comprehensive test prior to any contact trying to get to know you or even speak to you. I completed the assessment and was completely ghosted after despite doing well. It's disappointing to say the least to not even receive contact from a company for a job that I thought would be a good opportunity and I think speaks volumes for the company. Unprofessional on all fronts from my experience.
Perguntas de entrevista [1]
Pergunta 1
None, they start with a full test before getting to know you
