Informatica ETL Developer | Contract | Glasgow

Informatica ETL Developer

Government Sector

Glasgow

Contract: 6 Months +

Competitive Daily Rates

Experience Required

-

A qualified ETL Developer with many years' experience in this field and knowledge of C++ would be an advantage.
-

Ideally they will also have Microsoft SQLServer and Oracle skills.
-

Additional skills for the Design post of ERwin, Data Modelling and SQL coding.

Key tasks and deliverables

-

Design & Build The resource will focus on various supplier products - there are limited technical resources available in-house to support this project.
-

High dependencies on external resources to allow agreed delivery dates of the in-house services to be met.
-

Due to nature of work replicating non-standard contractual processes need to secure technical resources with required skills.
-

Be competent in the use of visual Data Modelling tools, e.g. ERwin.
-

Interpret Requirements documentation accurately.
-

Interpret and understand key supplier documentation to develop Staging and Historical Data Stores (HDS).
-

Highly developed knowledge of design principles specific to a Data Warehouse including handling of history, support for slowly changing dimensions and techniques for addressing performance issues.
-

Have an understanding of code including, Microsoft SQL Server (TSQL) code, in order to facilitate the conversion to PL/SQL.
-

Work closely with technical colleagues in the Build and Test teams to ensure smooth and rapid development.
-

Maintain data security for all collected and processed data Informatica, ETL Developer
-

Develop the process of maintaining all the relevant sources of data and ensuring that it is being stored properly.
-

Develop the ETL processes and in designing and preparing the codes that meet the program specifications as well as the client requirements.
-

Implement Informatica programs and workflows, carry out unit testing, ensures customer requirements are met, carry out defect fixing.
-

Convert existing code, including C++, SIR and Microsoft SQL Server (TSQL) code to Oracle code (PL/SQL), ensuring consistency and accuracy of data processing.
-

Maintain data security for all collected and processed data
-

Document algorithms and procedures to Velocity© standards.
-

The successful candidates will help develop effective strategies that manage and expand