Interview was conducted in three sessions. At the inperson interview, the first session was on Oracle PL/SQL. Interviewer gave a paper and asked to write code snippets. The second session was on Datawarehousing and Database concepts. This session was more oriented towards oracle internals which was bit difficult. Third session was on Informatica powercenter which was oriented towards data intergration. When you go to S&P, prepare well enough of the 'know how' of database internals. One of my friend then gave a feedback that eventhough the technologies used are not that much very great. But the interview questions are focussed in areas where its not touched at work.