ETL Architect/Designer - Informatica

Dublin  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Description

ETL Architect/Designer/Developer

Responsibilities

- Create template jobs to accelerate development and enforce consistency

- Design the error handling, scheduling, job dependencies/interdependencies, alerting, file transfer and management, audit log, test and debug logging.

- Design the lineage and metadata management strategy to be incorporated in all jobs.

- Identify and design key reusable functions and mapplets to accelerate and standardise the banks Informatica environment.

- Perform proof of concepts showing the strengths and weaknesses of ETL vs ELT designs assessing the values of pushdown processing and the effect on lineage capture

- Design the staging layer, integrated layer, data mart and history data model.

Requirements

- Strong SQL skills

- Good knowledge/exposure to DWH

- Informatica PowerCentre ETL design (Essential)

- Teradata integration

- Ability to translate business functional requirements to technical design

- Datamodelling desired

- Unix Scripting desired

- Informatica PowerExchange preferred.

For more information and a confidential discussion please call Michael or email (see below)

Start date
n.a
From
CPL Solutions
Published at
28.05.2015
Project ID:
912734
Contract type
Freelance
To apply to this project you must log in.
Register