·         Minimum 3 year SSIS experience, in a project or BI Development role and involvement in at least 3 full ETL project life cycles, using the following methodologies and tools

o    Excellent knowledge of ETL concepts including data migration & integrity, focusing on SSIS.

o    Extensive experience with SQL 2005 products, SQL 2008 desirable.

o    Working knowledge of SSRS and its integration with other BI products.

o    Extensive knowledge of T-SQL, stored procedures, triggers (Table/Database), views, functions in particular coding and querying.

o    Data cleansing and harmonisation.

o    Understanding and knowledge of indexes, statistics and table structure.

o    SQL Agent – Scheduling jobs, optimisation, multiple jobs, DTS.

o    Troubleshoot, diagnose and tune database and physical server performance.

o    Knowledge and understanding of locking, blocks, table and index design and SQL configuration.

·         Demonstrable ability to understand and analyse business processes.

·         Experience in creating business rules on best practices for data services.

·         Experience in working with, supporting and troubleshooting MS SQL servers running enterprise applications

·         Proven ability to work well within a team and liaise with other technical support staff such as networking administrators, system administrators and support engineers.

·         Ability to create formal documentation, work procedures, and service level agreements.

·         Ability to communicate technical issues at all levels including to a non technical audience.

·         Good working knowledge of MS Word, Excel, PowerPoint, Visio and Project.