I applied online. The process took 5 weeks. I interviewed at Wallet Hub (Curitiba) in Oct 2017
Interview
I applied online and the process took 5 weeks. I was interviewed by 3 different people and had to do some live coding challenges. Everyone was really nice and friendly.
Interview questions [1]
Question 1
They asked me to create a java application to parse an access log file.
I applied through a recruiter. The process took 1+ week. I interviewed at Wallet Hub (Remote, OR) in Jan 2017
Interview
I have been assigned to solve MySql and Java questions. I had 5 days to send them back the results. I spent my weekend and was so sure to take next step after posting the mail. Very surprised, I have been told that I didn’t pass. I couldn’t help and asked which answers was/were under their expectations. Of course, they did not bother to return.
I applied through a recruiter. I interviewed at Wallet Hub in Jan 2017
Interview
The interview process starts with some easy MySql and Java tasks. I had one week to solve and send them back the results. After 1-2 weeks after I solved the problems they got back to me and told I went well with the tests and they scheduled a technical interview through Skype. It was interesting because they didn't ask me if the appointment is ok for me or not. They just scheduled it to the next day. The skype interview is quick it is around 20 minutes. The interviewer asked me about a project I implemented earlier. I had to describe it in technical depth. After that I shocked a bit because I had to write 2 algorithm in a shared Google Docs. I've never seen thin on any interview. The 2 tasks were:
1,
public String stripHtml(String html) {
}
Ex1: stripHtml(“<h1>Hello World!</h1> <p>something</p>”)==”Hello World! something”;
2,
Write a method which updates an array such that every element becomes the product of every other element.
After I solved this the interviewer told me that the recruiter guy will tell me the result. The recruiter found me in an hour and told me that the interview went great and he would schedule the last interview with the CEO. The interview was on the same day but the CEO were late around 30 mins. He was ridiculous. :D He asked standard questions from my resume and asked how much money I earn at my current job. It was obvious from the first minute that he wanted to push down my salary somehow. I could ask a questions as well. I asked some standard questions like: 'Do you support learning, conferences ...? etc.' He answered for everything the 'we are only a startup' and 'you will learn during the job'. How can this man be a CEO anyway? :D At the end of the interview he told me that he will talk with the technical interviewer guy and call me back. He did not do that instead the recruiter guy told me that they can pay around 17$/hour. That was the funniest part. Oh no I missed the best part. They wanted to work around 55 hours a week + the recruiter guy told me that it's often requested by them to work on the weekends as well. All this for that ridiculous amount of money.
Interview questions [5]
Question 1
1) Write a query to rank order the following table in MySQL by votes, display the rank as one of the columns.
CREATE TABLE votes ( name CHAR(10), votes INT );
INSERT INTO votes VALUES
('Smith',10), ('Jones',15), ('White',20), ('Black',40), ('Green',50), ('Brown',20);
Write a procedure in MySQL to split a column into rows using a delimiter.
CREATE TABLE sometbl ( ID INT, NAME VARCHAR(50) );
INSERT INTO sometbl VALUES (1, 'Smith'), (2, 'Julio|Jones|Falcons'), (3, 'White|Snow'), (4, 'Paint|It|Red'), (5, 'Green|Lantern'), (6, 'Brown|bag');
For (2), example rows would look like >> “3, white”, “3, Snow” …
I have a table for bugs from a bug tracking software; let’s call the table “bugs”. The table has four columns (id, open_date, close_date, severity). On any given day a bug is open if the open_date is on or before that day and close_date is after that day. For example, a bug is open on “2012-01-01”, if it’s created on or before “2012-01-01” and closed on or after “2012-01-02”. I want an SQL to show the number of bugs open each day for a range of dates. Hint: There are bugs that were never closed.
Write an efficient algorithm to check if a string is a palindrome. A string is a palindrome if the string matches the reverse of string.
Example: 1221 is a palindrome but not 1121.