Knowledge of SQL Server 2005, 2008, 2008 R2, 2012 (Pref). Designing SQL Databases. Knowledge of Normalization & De-Normalization concepts. Maintenance of existing databases
Knowledge of Keys (Primary, Foreign, Composite), Constraints, CHECK, DEFAULTS
SSIS - Data Transformation, Sequence Container, Lookup, Derived Column, Conditional Split, Merge, Union All, Execute Package Task, Execute SQL Task, Managing & Optimizing Jobs or Packages. SSRS - Sub Reports, Matrix, Tables, DataSets.