Send me more jobs like this

Consultant (SQL Server and SSIS)

Keywords / Skills : SQL, SQL server, sql server 2008 R2, SSIS, ETL, Dataware housing, Data warehouse, ETL developer, Scheduling, maintaining, SSIS Developer, BI Solutions, C#, Visual Basic, Financial Services, Investment Banking

4 - 5 years
Posted: 2019-05-01

IT/Computers - Software
Other Software/Hardware/EDP - Consultant (SQL Server and SSIS)
Any graduate
Posted On
1st May 2019
Job Description
1. Should be able to design and develop production ready code and SSIS packages to handle the business data.

2. Complete the build of code on time and as per application coding standards, and perform unit testing

3. Work on upgrading of older version of SQL Server viz.2008R2 to higher version.

4. Working with delivery teams and users to manage Change Requests Issues, Risks and Assumptions associated with delivery.

5. Tune the existing queries and achieve optimal database performance for the business reports.

6. Schedule, manage and monitor the ETL loads.

7. Design and develop end to end solutions to improve current state of Product(s) improving the test coverage and improving the time to production

8. Communicate technical solutions in a clear and concise manner

9. Defining innovative and effective solutions that meet the business requirements within architecture standards.

10. Pro-active team player with focus on delivery

The Skills you’ll need

In order to be successful in this role, you must have the following skills & experience:

1. Experience in creating and analysing stored procedures, Views, User Defined functions, Sub-queries and joins for complex queries involving multiple tables.

2. Experience in query tuning, fixing performance related issues and provide corrective measures.

3. Experienced in SQL Server upgrade/migration of SQL Server 2008 R2 to higher versions.

4. Expertise in using SSIS Transformations to implement complex ETL logic as per the business requirement.

5. Experience in working on DataWarehousing, Scheduling and maintaining ETL packages.

6. Hands on experience on developing and deploying multiple SSIS packages and components on different servers using SSIS package configurations.

7. 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.

8. Good to know C# and Visual Basic.

9. Experience in financial services / investment banking environment and products

No. of vacancies: 02
Salary: Upto 9.5LPA

About Company

The company is a leading UK/India based IT Consulting firm primarily working with major banks in UK and India. It is a young, dynamic and fast moving business and technical management consultancy that is currently redefining the way business, technology and data solutions are delivered to the Financial Services Industry.
Similar Jobs
View All Similar Jobs

Walkin for you