1. In depth knowledge in Index 2. What are all dB check needs to do for informatica partition 3.dynamic lookup scenario 4. Getting data from Different time zone how to load single table 5.explain plan how to see 6.SQL query taking time to run what else db check needs to do...
They asked about my previous experience and my roles and responsibility
ALL TECHNICAL QUESTIONS
Basic questions like : LookUp, SCD, Database
why did you join?
Dataware Housing Concepts, Informatica Scenarios along with theory, Unix, SQL.
Scenario based questions
Most of the questions were all behavioral based.
Tell me about a time when you challenged the status quo?
what are your weaknesses, how did you handle a difficult co worker
Viewing 1451 - 1460 interview questions