MSBI (GENERAL) REAL TIME INTERVIEW QUESTIONS FOR EXPERIENCE

1)      Please introduce yourself?

2)      Please explain about your recent Project?

3)      You’re rating in SQL?

   4)      Is your company CMM I level 5 certified ?

   5)      Aim of your project?

   6)      Size of the database?

   7)      What does design document contain?

   8)      Is design document in word format?

   9)      How do you perform quality check?

  10)  Flow of your project?

  11)  Project architecture?

  12)  Which report do you prefer to display month wise year wise  and product wise sales of a company

  13)  When is your project going to be completed?

1.      What is the life cycle of ETL Process?

2.      What is the life cycle of ETL Project Development?

  14)  Do you have idea on performance tuning?  Give me some examples which you have used in project?

  15)   

  16)  Could you explain briefly about your project? 

  17)  How many modules it has? And what are they?

  18)   You are working on which module?

  19)  How many members are working in your current project?

  20)  Could you explain one task which you struggle a lot in your current project? And how did you achieve that task?

  21)  What is the Project delivery date?

  22)  Where is your bank Head office?

  23)  How many branches it has?

  24)  Where is the main branch in Hyderabad?

  25)  Do you ever interact with your client?

  26)  You have trace out one issue whom will you report?

  27)  Write down the project url?

  28)  What is the frontend application using in your project?

  29)  What is the name of your reporting manager and his mail id?

  30)  What is the name of your project manager?

  31)   Did you get chance to fight against with your management during the last 6 months?  

  32)  How many authentications we have in SQL?

  33)  Customer came to the bank to deposit money how many transactions will happen and tell me the backend process?

  34)  How do you cancel the user1 permission?

  35)  How do you connect to the server?

  36)  How many members are working in your current project?

  37)  Could you explain one task which you struggle a lot in your current project? And how did you

a.      Achieve that task?

  38)  Do you have idea on performance tuning?  Give me some examples which you have used in project?

  39)  I entered login ID and Password click for login but it is taking so much of time to login how will you tune for performance

  40)  Did you ever worked with checkpoints?

  41)  You are loading data from different servers (10) and this should directly go to the destination on the other day server number increases then where and how you will manage the data?

  42)  Name the ssis configurations with which you have worked? 

  43)  Tell me about your self

  44)  Take your time and explain in detail the flow between SSIS, SSAS and SSRS by realtime scenarios which encountered in your project and which u have worked on? If you have nt worked on all 3 at a time then tell me how and where u get files to perform your activity in detail and how you perform and what you do after performing activity in detail with a real time example?

1)      How many modules it has? And what are they?

2)      You are working on which module?

3)      How many members are working in your current project?