As a SQL Server, SSIS Consultant, your key responsibilities will include :
Should be able to design and develop production ready code and SSIS packages to handle the business data.
Complete the build of code on time and as per application coding standards, and perform unit testing
Should have worked in SQL Server 2016, SSIS 2015 version.
Working with delivery teams and users to manage Change Requests Issues, Risks and Assumptions associated with delivery.
Tune the existing queries and achieve optimal database performance for the business reports.
Schedule, manage and monitor the ETL loads.
Design and develop end to end solutions to improve current state of Product(s) improving the test coverage and improving the time to production
Communicate technical solutions in a clear and concise manner
Defining innovative and effective solutions that meet the business requirements within architecture standards.
Pro-active team player with focus on delivery