ETL Developer

Tender description

Who Speclialist Work With Specialist will be working with senior BI developer and other members of the BI team as necessary. What Specialists Work On Build 3 ETL packages for the loading of data from 3 bespoke excel workbooks into a pre-existing data warehouse. Where the Work Takes Place 1 Kemble Street, London, WC2B 4AN Early Market Engagement Working Arrangements Working in the ORR's head office in London where a laptop will be supplied for this piece of work. The work will be for between 6-9 days in total. Work Location 1 Kemble Street, London, WC2B 4AN Security Clearance Basic clearance is required. Additional T&Cs Skills & Experience Minimum experience of two years’ experience of SQL Server Integration Services, 2008 R2 edition. Minimum of one year familiarity with SQL Server Management Studio; creating new tables via a script for multiple databases Understanding of the role of metadata within the ETL process. Understanding of standard data warehouse design principles including star schema, roles of staging and DW warehouses, look-up transformations. Able to create free-standing ETL packages for transferring 2-3 Excel datasets from multi-tab source to a single DW table. Nice to Haves Advise on query optimisation Understanding of source control, particularly Team Foundation Server No. of Specialists to Evaluate 5 Cultural Fit Criteria Work as a team with our organisation and other suppliers Be comfortable standing up for their discipline Can work with clients with low technical expertise Assessment Method Evaluation Weighting Technical competence 70% Cultural fit 5% Price 25% Questions from Suppliers Budget range