Should be able to connect with multiple data sources like excel, csv, SQL server oracle etc.

 Should be able to use the transformations components to transform the data

 Should possess knowledge on incremental load, full load etc.

 Should Design, build and deploy effective packages

 Should be able to schedule these packages through task schedulers

 Implement stored procedures and effectively query a database

 Translate requirements from the business and analyst into technical code

 Identify and test for bugs and bottlenecks in the ETL solution

 Ensure the best possible performance and quality in the packages

 Provide support and fix issues in the packages

 Writes advanced SQL including some query tuning

 Experience in the identification of data quality

 Some database design experience is helpful

 Experience designing and building complete ETL/SSIS processes moving and transforming data for

ODS, Staging, and Data Warehousing Skills:- Microsoft SSIS, ETL, SQL Server Integration Services (SSIS), SQL and SQL server