Please feel free to leave a comment...
Interviewing for a data manager
Monday, October 11, 2010
If you work in schools, you know this person. They enter / edit / delete information from you Student Information System. They keep the data clean, they write SQL, they run diff's, yadda yadda.
We are interviewing for this position at my school and I'm asking some fairly straight forward technical questions, so I can ascertain the technical competence of the people applying for the job.
1. Using SQL, how do you select data from multiple tables?
2. Using SQL, how do you identify unique records?
3. Please look at this regular expression. [0-9] what would this find?
4. Please provide an example how you compare two different tables?
5. Do you know any shell / script programming? Give me an example of a shell / script program you've written.
6. How do you identify duplicate data in your tables?
These strike me as fair questions, no "gotchas", and reasonable.
Why are the applicants having such a hard time answering these questions?
We are interviewing for this position at my school and I'm asking some fairly straight forward technical questions, so I can ascertain the technical competence of the people applying for the job.
1. Using SQL, how do you select data from multiple tables?
2. Using SQL, how do you identify unique records?
3. Please look at this regular expression. [0-9] what would this find?
4. Please provide an example how you compare two different tables?
5. Do you know any shell / script programming? Give me an example of a shell / script program you've written.
6. How do you identify duplicate data in your tables?
These strike me as fair questions, no "gotchas", and reasonable.
Why are the applicants having such a hard time answering these questions?
Commenting is not available in this weblog entry.
Bill MacKenty, Chief Zuccini
I make a difference in the life of kids. You want to tell me what's more rewarding?
Resume
This is my full resume. It has all my work experience since I graduated from college in 1992, including certifications, professional memberships, and descriptions of my work.
Polish Resume
This is my full resume translated into Polish. My wife tells me it is a literal translation, and as such might convey a slightly different meaning to Polish speakers.