Protected: PWshinton second round F2F intrvw September 28, 2010
Protected: BA intrvw – my very first in dls after wedng September 22, 2010
expedite the process February 25, 2010
performance tuning in databases
how to implement many to many relations- not possible without a temp or third table
the table of sales data
prod id feb 10th feb 20th revenue growth
left outer join with the same table
index- clustered indexc- composite index
query plab- how do u view it
schema & how many facts and dimensions
how does cognos interact with my dwh
i was just stumped with all those queries..and even after he gave me clues..i just froze ..i need to really really work hard on the queries..i need to write and practice them and start thinking in tht manner..
areas which need improvement:
1.queries
2. db internals
3. asking the interviewer a lot of questions like “what r the skills u r looking for?” “r u looking for any specific tool knowledge or just like tht?” wht is role like? what is the specific team and specific group i ll be working in? what r the next steps of the interview? what will my typical work day look like? work culture and environment only if not covered
speak more enthusiastically, confidently and happily with a smile on face..
but, definitely i was a lot more confident in this interview..only tht i put high expectations of myself and was not able to meet my own expectations
the geneva- setting up the whole thing from begining to become no.1….a small team of 10 ppl..so prominent & significant post..its kinda cool..shucks i missed it 😦
mere aankhon ke saamne clearing tech with only olap-oltp-temp table- hr-intervw with cust ..crossing all the levels..
how enthusiastic are you abt learning new things? round 2
analytical round- analytical skill tested in round3
is it all communicatn and crap after clearing the most difficult 1 st round..looks like clearing the 1st round is the toughest and every other round is just to convince tht u fit the bill and they made a right decision.
capgmni December 11, 2009
yayyyy…capgmni interview was gr8 😀
it was a behavioral interview and not technical 😀 😀
the guy asked
background?
a roadblock and how i overcame it?
working in a team?
problems in a team?
some bonus and how would i share with the team? *impressed by my 80-20 rule 😉
how was i involved in sdlc at my prev work..the requirements..overlooking the performance requirements etc
the most uninteresting job ..something i can never do
y did i leave my job
y did i come back to school
y did i specialize taking masters in compsci instead of mba (oh God ! i wish i did tht !! i think abt tht almost every day )
yayyy.he said hes impressed by the stuff the ivy ppl have and i should be looking forward to getting into the next round ..yipppeeeeeeeeeeeee 🙂
sorting in sync November 4, 2009
sync sort – yet another place where i have to face the synchronization problems after the os,ics and yes db too
difference betwn java & c
the jvm, byte code , platform independant, garbage collector !
the garbage collector? an advantage or disadvtg?
context switch overhead !
a context switch?
2 processors 1.5 Ghz and 3 Ghz.which one is faster
faster for a file copy operation?
the processor,memory,hard disk – the bottleneck for performance
fragmentation !
the order in which the 3 get involved and y
the etl, performance reqmnts? pre-sorted data, rebuilding indexes,parallel sequences!
parallel computation
virtual memory?
index?
clustered & non clustered!