Executive at Zykoon Technologies Pvt Ltd
Views:212 Applications:23 Rec. Actions:Recruiter Actions:8
Zykoon Technologies - SSIS Consultant - SQL Server/ETL (3-7 yrs)
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