SQL Server and SSIS development
Practice writing an optimized T-SQL query and outline how you would build an SSIS package to load a dimensional table.
The Data Warehouse Developer role requires developing T-SQL code and SSIS packages for the data warehouse.
Source posting