Consultant (SQL Server and SSIS)
6h ago
source : Shine

As a SQL Server, SSIS Consultant , your 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.
  • 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 S kills youll need i n order to be successful in this role, you must have the following 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 DataWarehousing, 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
  • Step 2
    Add to favorites
    Remove from favorites
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Application form