Job Description
Job Title-SQL Developer
Client-Global Consulting Firm
Day Rate-£300-£350 (Outside IR35)
Duration-1-3 months (extendable)
Location-London (Remote only)
Essential skills & experience:
- 4+ years of experience as SQL Developer
- Expertise in SSIS with version 2016
- Good exposure to Data Projects dealing with Data Design and Source to Target documentation including defining transformation rules
- Understanding of different components like Data flow, Control flow, Package Explorer & Event Handler
- Expertise in CICD process
- Exposure to Azure Service Pack to connect to different resources in Azure
- Experience in designing, developing and deploying packages to higher environments
- Good knowledge on File formats for flexible usage, File location Objects (SFTP, FTP, local, HDFS, ADLS, BLOB, Amazon S3 etc.)
- Strong knowledge in T-SQL queries
- Design and create tables, views, triggers, partitions, complex stored procedures, functions, indexes and other database objects
- Support extracting and transforming data using DTS/SSIS Import Export Data, Bulk Insert, BCP and DTS/SSIS Packages
- Good development experience with SQL Server 2016 and 2012.
- Ability to work with Database Team on best practices and abiding coding standards