SSIS
  1. Explain your roles and responsibilities in your project?
  2. Any Complex scenario you have faced in your project?
  3. How to configure SSIS package in Test, UAT, Dev and Prod  environment separately?
  4. How to load multiple files one by one?  how system choose which file to be load?
  5. Package configuration
  6.  Have you worked on JSON file?
  7. Explain event handling in SSIS?
  8. How to load data if source package has error?  
  9. Logging in SSIS?
  10.  What is lookup transformation?
  11.  what is mean by full cache and Partial cache?

SQL
  1. What is difference between delete and truncate?
  2. Is delete rollback?  Is truncate rollback?
  3. What is Tirgger? Types of triggers
  4. Difference between Trigger, Procedure and Functions?
  5. Query
Input:  abc--------def--------xyzi---------pq

Output: abc-def-xyzi-pq