ETL Developer

Wave Advertising Ltd CVM people
United Kingdom
60K-75K+ Package
03 Oct 2017
03 Nov 2017
Contract Type
Full Time
Role: Ab-initio ETL Developer Location: London Salary: 65k-75k + fantastic benefits Our client is one of the biggest names in retail who really puts customers at the heart of decision making. With a well-developed and enhanced in-house DW function, the data warehousing team provides fantastic support for marketing, analysis & the insight function across the business. Their internal capability has undergone significant change and improvement over recent years, having only relatively recently being brought in-house. Therefore, this really is an exciting department with a lively, capable team dedicated to grow this functionality and delivery to all areas of the business. The role: Having worked to develop and build this team to full capability over the past year, I am now looking to recruit an experienced ETL Developer on a permanent basis to sit within this department to plug the last crucial gap. Managing the development of complex system applications, data integration and database components this is a really varied role with the opportunity to work on both small and large projects. It is really encouraged through the business to take lead and ownership of your position, therefore you would be able to actively direct development and integration approaches and work with different team members to really influence approaches/ plans and take technical responsibility on all stages in development. You: Responsibilities and Duties - Form part of a core, small team to support, maintain & enhance the ETL functionality of DW. - Take responsibility for ETL design, development, test & delivery within specific projects - Input into the quality assurance process for Ab Initio development - Maximise re-use of existing Ab Initio assets and alignment with established processes and standards - Support the identification and resolution of data quality issues - Ongoing performance tuning of live code - Maintain metadata via the Ab Initio EME - Support the update & maintenance of the batch scheduler for Ab Initio plans and its integration with systems management and operations architecture - Perform any regular maintenance activity required to optimise the Ab Initio environment - Support incident management as required Skills and Experience - 5+ years in Ab Initio development role with responsibility for supporting, designing and building new psets, graphs and plans - Experience of designing and building solutions using Ab Initio with RDBMSs such as DB2, Teradata, Oracle - Proficient in advanced Ab Initio functionality to include vectors and vector functions, type dml, extended rollups, MQ, web services, meta programming - Proficient SQL knowledge & experience - Basic shell scripting - Ab Initio v3.1, Unix, SQL, GDE and EME - Experience of metadata management and data governance processes associated with data integration - Experience with batch interface design - Experience of working with business representatives to define integration requirements and be a strong communicator - Design for performance and experience of optimisation techniques Want to find out more? ********************************** ************
This job was originally posted as