Should have working experience with Microsoft SQL Server Integration Services (SSIS), use of control and data flow, data sources, connection manager and package configurations.
Should have hands-on experience in SQL development background writing complex stored procedures and expressions, referential data integrity concepts and error handling.
Should have working experience with data warehouse technologies and hands on experience with data extraction, data cleansing, data transformation, data loading and data validation rules