Author Topic: finally got the job offer  (Read 8745 times)

婕喜

  • Core Package
  • Full Member
  • *
  • Posts: 246
  • Karma: +4/-1
finally got the job offer
« on: July 16, 2016, 04:48:38 PM »
Dear Laoshi and Lucky,

I finally got the job offer from another hospital in downtown area yesterday. The pay is higher and the job title is also senior level. It took me nearly  three months and I went through 7 on site interviews. I'd like to share some experience with students who are in Canada.

Compare to two years ago I think there are more BI related job opportunities on job market however also more competition.  That's just my experience could be wrong. you also need to spend lots of time to modify your resume make it very close to job requirements.

Regarding the on site interviews, I got two sql tests. One was a position in government. Very easy, even didn't have to do table joins only select statement. i didn't get the position though as one reason I think I'm over qualified. this position uses excel a lot to do reporting. Another sql test was with a financial company. The test was not too easy also not too hard either. Used 3 tables to get information and also used group functions. I did test better than two years ago but didn't get the position. The salary company only can afford to pay was much lower than my expectation. Anyway except these two sql tests are technical things, all my interview questions were behavior questions and all of them can be found on these forum:

what kind of manager you like to work with? have you ever had any bad managers? describe what's the good manager or bad manager?

how do you handle conflict with your coworkers or manager or end users?

if end user asked you to create a report using lots of parameters, how do you handle it?

what's your biggest challenge you have ever met at work? how did you act and what's the outcome?

how do you prioritize multi tasks?

if dead line is approaching you think you can not deliver the reports to the end user, what would you do?

why did you apply this position?

what do you know about our organization?

how would your manager and coworkers describe you?

what's your salary expectation?

describe a situation you made a recommendation to improve the system performance.

describe a situation you did trouble shooting fixed the application error.

do you have experience to communicate with cross function departments and senior management?

how do you handle mistakes? what did you learn?

describe how do you gather the requirement from the end users?


I think that's all about my on site interviews. For me, I prepared lots of stories.

Another thing I want to say is Laotu laoshi not only lead me to this data base field but also opened another door for me. Now I can apply jobs not only related to back end but also related to application front end:)

Thanks Laoshi and Lucky and other students.

Jessie
 

mtdbe2

  • Core Package
  • Sr. Member
  • *
  • Posts: 307
  • Karma: +0/-0
Re: finally got the job offer
« Reply #1 on: July 16, 2016, 05:00:56 PM »
祝贺祝贺,功夫不负有心人呐。
 :) :)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 3755
  • Karma: +35/-11
Re: finally got the job offer
« Reply #2 on: July 16, 2016, 09:30:09 PM »
祝贺咱国文科生 婕喜同学 跳到BI高级职位BI!


Martin2014

  • Core Package
  • Jr. Member
  • *
  • Posts: 66
  • Karma: +0/-0
Re: finally got the job offer
« Reply #3 on: July 16, 2016, 10:49:53 PM »
恭喜你Jessie!你的故事非常鼓励我,感谢你的分享!

婕喜

  • Core Package
  • Full Member
  • *
  • Posts: 246
  • Karma: +4/-1
Re: finally got the job offer
« Reply #4 on: July 17, 2016, 12:37:49 PM »
Thanks :)

Jessie

lkh99

  • Core Package
  • Newbie
  • *
  • Posts: 34
  • Karma: +0/-0
Re: finally got the job offer
« Reply #5 on: July 17, 2016, 08:20:34 PM »
Congratulations!

jchiefland

  • Core Package
  • Newbie
  • *
  • Posts: 44
  • Karma: +0/-0
Re: finally got the job offer
« Reply #6 on: July 18, 2016, 05:31:46 AM »
Congratulations!
Are you coming back Wednesday night?

如月

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1678
  • Karma: +17/-2
Re: finally got the job offer
« Reply #7 on: July 18, 2016, 07:04:53 AM »
Congratulations!  Thanks a lot for your sharing !

婕喜

  • Core Package
  • Full Member
  • *
  • Posts: 246
  • Karma: +4/-1
Re: finally got the job offer
« Reply #8 on: July 18, 2016, 09:14:29 AM »
Thanks:)

Jessie