ETL Developer

ETL Developer

Our client, a major blue-chip company, require an ETL Developer whose main skills will be focused on C#, SQL 2014, Meta Data, Dimensional modelling and SQL.

Job Description

ETL Developer (C#, SQL 2014, Meta Data)
London
6 months

Our client, a major blue-chip company, require an ETL Developer whose main skills will be focused on C#, SQL 2014, Meta Data, Dimensional modelling and SQL.

The ETL Developer will have responsibility for the successful development of extract/transform/load (ETL) data warehouse solutions and providing quality data required to support evidence based business decision making and will also conduct data mapping, design, develop and implement extract/transform/load processes using custom ETL or ETL tools.

Key interfaces will include -
o With the customer experience Business Analysis team who, in consultation with the business, compile business requirements in terms of the reports, scorecards and dashboards which contribute to the effective monitoring of Operating Businesses.
o With the Business Intelligence Development team to deliver the business requirements in terms of business intelligence reporting.
o With the Test team to unit and system test the ETL solution
o With Third Parties with whom the Customer Experience directorate has a relationship, including: Ticketing systems contractors, ATOC/RSP/Train Operating Companies and the Customer Database Manager

The ETL Developer will have good knowledge of -
o ETL
o Data warehousing
o Data modelling
o Dealing with big data and the approaches
o Knowledge of star schema structure & design, understanding of Kimball & Inmon data warehouse design
o Understanding of Agile development approach
o A degree in a relevant technology/computer science subject/equivalent technical qualification plus sound on the job experience of the platform specialism
o Knowledge and interest in the latest and emerging technologies likely to be employed in designing and delivering Enterprise Wide quality solutions in the chosen platform
o Knowledge of best practice data encryption techniques and standards
o Knowledge of relevant national and international legislation pertaining to the Government/Public Sector IT - e.g. Data Protection Act, EU Procurement Directives and Freedom of Information Act, including knowledge of basic confidentiality and data protection requirements that apply to the processing of customer information.
o Knowledge of London's public transport system

Skills required will include -
o ETL design, development and testing
o Microsoft SQL Server 2008 onwards
o SQL SSIS, SQL SSRS, SQL SSAS
o Writing/Reading Complex Queries
o Performance tuning & monitoring
o Knowledge of Oracle 11g
o Skilled at solving and communicating problems collaboratively, applying knowledge and technology to the full
o Strong analytical skills
o Communicates all needs, instructions and decisions clearly. Adapts the style of communication to meet the needs of the audience. Checks for understanding
o Proficient at use of standard computer packages
o Exceptional stakeholder engagement skills
o Excellent writing style including translating technical information

Experience/Background -
o Has worked within the IT industry as an business intelligence developer in a large scale data warehouse system
o Recent experience in the latest techniques and methodologies in delivering quality solutions
o Experienced in large enterprise business /data warehouse implementations
o Experience of operating in a dynamic working environment, handling multiple tasks and deadlines, delivering to time, budget, and quality
o Detailed experience of developing and supporting queries on databases that contain Financial and/or Customer information which is used by many business groups
o Experience of working with the Data Protection Act and Data Security managers

This vacancy is being advertised by Advanced Resource Managers. ARM is a specialist talent acquisition and management consultancy. We provide technical contingency recruitment and a portfolio of more complex resource solutions.

Our specialist recruitment divisions cover the entire technical arena, including some of the most economically and strategically important industries in the UK and the world today. We will never send your CV without your permission.

Advanced Resource Managers IT Limited operates & advertises as an Employment Agency for permanent positions and as an Employment Business for contract/temporary positions.

Key Consultant

Elliott Brooks-Stephenson

Elliot Brooks-Stephenson Profile

I focus on delivering IT staffing solutions to our high-profile clients, on a contract basis. I cover a wide range of roles across a variety of corporate clients, using my expertise to quickly source the ideal candidate.

* Indicates a required field

* Indicates a required field