Informatica Developer

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

Description

ETL Designer
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 design
- Teradata integration
- Ability to translate business functional requirements to technical design
- Datamodelling desired
- Unix Scripting desired
- Informatica PowerExchange preferred.
For more information about this role please contact Luke

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