Data Warehouse Developer - Southend-on-Sea, United Kingdom - Steria Recruitment

Steria Recruitment
Steria Recruitment
Verified Company
Southend-on-Sea, United Kingdom

1 month ago

Tom O´Connor

Posted by:

Tom O´Connor

beBee Recruiter
Description
Intelligent Resource Recruitment is working in partnership with a major Client in the UK. We are currently recruiting for
Data Warehouse Developerto be
Southend/Remote based out


Job Title= Data Warehouse Developer

Location =Southend/Remote

Duration= 3 months

Description:


  • Excellent understanding of T-SQL
  • Familiar with stored procedures, functions, indexes, constrains, CTE, views, temp tables, table variables, linked servers, openquery, dynamic SQL etc.
  • Query Performance tuning
  • SQL Automation using SQL Agent
  • SSIS (different versions including 2008 and development, troubleshooting and package deployment.
  • MS SQL Server (different versions including 2008 R2 and 2019)
  • Query Optimization
  • Understanding of SQL Server security, access, permissions etc.
  • Excellent communication, analytical, interpersonal and project management skills (actions, escalations, deadlines)

Experience:


  • Involved in SQL database migration ideally from SQL 2008 R2 to SQL 201
  • Worked with different versions of MS Visual Studio (including BIDS 2008, VS 2019)
  • Experience with upgrading SSIS packages (including dts) from Package Deployment Model to Project Deployment Model, familiar with SSIS catalogue.
  • Experience in creating, maintaining, and troubleshooting ETL processes
  • Error handling and debugging (ETL, SSIS and SQL coding issues)
  • Possible experience with "Query Tuning Assistance" tool available from SSMS 18.0 used for guidance on recommended compatibility level upgrade process suggests hintbased improvements that can be deployed for individual queries.
  • Created IT technical documentation, hand over documentation, user guides etc.

Desirable:


  • C#, VB.NET (there are script tasks using those programming languages within SSIS packages that we might need to rework)
  • Use of versioning tool (any, dev ops, team foundation, git hub)
Intelligent Resource Recruitment is committed tbarrier-free and inclusive recruitment. We are a Disability Confident recruiter, and a RIDI 100 and Business Disability Forum partner organization.

Intelligent Resource is committed to barrier-free and inclusive recruitment. We are a Disability Confident recruiter, and a RIDI 100 and Business Disability Forum partner organisation.
More jobs from Steria Recruitment
See all jobs of Steria Recruitment