Dieses Jobangebot ist archiviert und steht nicht mehr zur Verfügung.
Vakante Jobangebote finden Sie unter Projekte.
Vakante Jobangebote finden Sie unter Projekte.
ETL Designer - Informatica
Eingestellt von CPL Solutions
Gesuchte Skills: Design, Designer, Unix, Sql
Projektbeschreibung
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 ETL 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 (see below)
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
- 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 (see below)
Projektdetails
Geforderte Qualifikationen
-
Kategorie:
IT Entwicklung, Medien/Design