how many mapping you have done ? what kinds of mapping ? how complex mapping you have done? how do cleanse the data facts and dimensions tables procedure,package and functions used in previous projects explain with business scenerios few more questions from both
DWH theory , oracle issues and Informatica Power Center.
self intro,back ground,education back ground
Query and project .... about the client
Salary was the first question he asked in technical interview
I wasn't asked any real technical questions. they are running single node Oracle databases from the ancient ( and most likely no longer supported ) Oracle 8 to Oracle 11. they are using Oracle's "Advanced Replication" feature which was advanced ten years ago. the local office has the support staff but didn't seem to have any managers. all development is outsourced to India and Russia.
Most of the questions were related to the work and the database stuff. There were some in-depth questions dealing with database internals.
Why you are looking for job change?
Basic technical questions related to Database
Asked all the questions about Oracle basic to advaced PLSQL. Given queries to remove duplicate records and to fetch the 3rd highest salary.
Viewing 771 - 780 interview questions