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
Work on upgrading of older version of SQL Server viz.2008R2 to higher 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
The S kills youll need i n order to be successful in this role, you must have the following skills & experience :
Experience in creating and analysing stored procedures, Views, User Defined functions, Sub-queries and joins for complex queries involving multiple tables.
Experience in query tuning, fixing performance related issues and provide corrective measures.
Experienced in SQL Server upgrade / migration of SQL Server 2008 R2 to higher versions.
Expertise in using SSIS Transformations to implement complex ETL logic as per the business requirement.
Experience in working on DataWarehousing, Scheduling and maintaining ETL packages.
Hands on experience on developing and deploying multiple SSIS packages and components on different servers using SSIS package configurations.
Should be able to support implemented BI solutions by monitoring data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues.
Good to know C# and Visual Basic.
Experience in financial services / investment banking environment and products