16/05 Sapna
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)

Bangalore Job Code: 444597

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

Add a note
Something suspicious? Report this job posting.