Description
ETL Designer - 6 months
Role/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, DataMart and history data model.
Mandatory:
- Data Warehouse Knowledge (Inmon Style)
- Excellent SQL skills
- Informatica PowerCentre
- Teradata Integration/ETL design
- Experience Ability to translate Business/Functional requirements to Technical Design
Nice to Have:
- Control-m UNIX Scripting
- Oracle Application Express
- Informatica PowerExchange GCFR
- FSLDM DataMart Experience (Kimball Style)
- Datamodelling