SQL Developer

Oyster Consultants
London, UK
03 Sep 2019
09 Sep 2019
Contract Type
Full Time
SQL / ETL Developer

Purpose of the Role:

Our client is seeking an experienced individual with past involvement in deploying and managing new ETL processes that could culminate in the creation of multiple sourced SCV deployment and more general custom hosted solutions.

Additionally the role will involve maintaining and enhancing specific ETL processes for bespoke customer solutions as well as internal processes for proprietary product builds and deployment.

The ETL process will be used to prepare data for storage in customer hosted solutions which makes up a piece of the Marketing database solution.

Duties and Responsibilities:

·Understand the ETL specifications and build the ETL applications

·Take a lead role in the design and scoping of new projects.

·Ensure that the data feeds from various sources like relational and flat file sources can be integrated.

·Create the mappings, sessions and Workflows as per requirement of business to implement the logic

·Perform the Unit Testing on developed code and workflows

·Ensure ETL flow can integrate with all phases of Data Warehousing like Analysis requirement gathering and Design and Development of code

·Create a mapping document based on High level design document

·Assist development team to maintain all data sources and data storage options

·Coordinate with development team to create all ETL processes

·Provide an efficient interface with brand for all processes across various platforms

·Evaluate functional requirements and map the documents.

Desired skills:

* Proven Knowledge of SQL SSIS

* Past experience with ETL workflow tools such as Talend, Datastage, Informatica etc a must.

* Knowledge of SCV creation and maintenance

* Familiar with Apteco Faststats, and Peoplestage

* Past experience of PAF processing HelpIt

·Basic understanding of Java and Python an advantage

Similar jobs

Similar jobs