·        Experience in SQL Server and SSIS ETL

·        Good to have: 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