candidate should have exposure on table design, writing complex stored procedures/functions etc. and optimized queries.
Should be familiar with creating custom workflows using script tasks and interacting with database using.
Extensive experience in developing and debugging complex packages with various control flow and data flow controls are required from SSIS side.
Should be a quick learner and be ready to own the task allocated and deliver with less/no supervision.