* Experience in area SQL Server having SQL, T-SQL i.e. procedural programming

• 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

• Should have team handling experience