Zykoon Technologies - SSIS Consultant - SQL Server/ETL (3-7 Yrs) Bangalore (Systems/Product Software)

As a SQL Server, SSIS Consultant, 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.
-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.
-Defining innovative and effective solutions that meet the business requirements within architecture standards 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 Data Warehousing, 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

Required Skills : English