March 27, 2012 at 4:22 am
Hello all,
I am a newbie to MSBI and got an interview for junior BI developer. Feeling really tensed abt interview please send some sujjestions about wat sort of questions i may be asked for. I have already done my telephonic round and now it's final stage face to face round.
(job spec is all abt ssis,ssrs)
thanks,
vsql.
March 27, 2012 at 4:31 am
Do you understand Data Warehousing concepts?
Does the Kimball Methodology ring a bell?
What's the difference between MDX/DMX/DAX?
Differences between MOLAP/ROLAP
How do you schedule an automatic cube processing task?
Can you define time intelligence on a dimension?
These are just a few that should set you on your way, I'm sure you'll discover a lot more when reading..
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 27, 2012 at 4:32 am
if you have BIDS (business intelligence development studio) installed on your machine, I would suggest creating a SSIS solution and a SSRS soution and see whats in the tool box for each type then play with each one there is just so much that we can say here which may or may not come up in the interview.
things in ssis I usually ask are around loops, logging, configurations, event handlers, breakpoints, checkpoints, variables, connection managers and depending how I feel I usually pick between 3 and 5 things from the tool box and quiz the interviewie on what they know about the tool box item
ssrs I usually go down the routes of parameters, data sets, report items, mapping geospatial data, deployment, connection strings
the topic of BI is so vast that it is impossible to say what you will be asked, but there are a lot of good resources out there. I would suggest a google search for SSIS 101 and SSRS 101 to get the basics and build on from that
March 27, 2012 at 4:41 am
thank you anthony for ur time it's really helpful
March 27, 2012 at 4:49 am
also if you dont know something, tell them you dont know.
as an interviewer I like the honesty as I always check the answers interviewie give to me if it is something I havn't heard before.
i started off as a general support guy fixing a keyboard here, installing a pc there, with little SQL knowledge other than basic DML, I went for a junior DBA role and anything I didnt know I said, I didnt know, I got the job on the basis that other people applied and gave the interviewer a load of garbage which wasn't correct. now my SQL knowledge has increase on an infinate scale compared to what I knew back then.
dont take it as a failure, take it as a success as you know where your skill set is failing and look it all up so your ready for the next time
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply