SSIS Developer - RBS

SSIS Developer JD:
 
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
Should have worked in SQL Server 2016, SSIS 2015 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 Skills you'll need in order to be successful in this role, you must have the following skills & experience:
 
5+ Years' experience in SQL SERVER, SSIS, Data warehousing areas.
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.
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.
Experience in financial services / investment banking environment and products
Agile practitioner in SDLC & Dev Ops. TDD, JIRA, Team City SONAR, ARM etc.