SSIS:

1) Transformations?
2) Control flow and Data flow?
3) Can we create temp table in control flow? If Yes, How?
4) If we want to ignor blank columns from Source to Destinations in Excel Sheet?
5) Variable vs Parameters?
6) Package Deployment?
7) Package Configuration?
8) What files can use in flat file source?
9) How can we arrange logical sequence of tasks?
10) Script Task?
11) SSIS Package design challenges?
12) Synchronous vs Asynchronous Transformations
13) Using Checkpoint, How can we start execution of package from start?
14) How can we secure configuration values? (Username and Password)
15) Security of SSIS Packages
16) SCD

SQL:

1) Sql Server Profiler?
2) Temp Tables
3) Table Variable
4) Sp Debugging
5) Query Optimisation
6) Magic Tables
7) Cursor
8) CTE?
9) Recursive SP
10) Ntile
11) Coalesce
12) SSRS Reports?