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)