Data Warehouse Analyst - Informatica
Skills & Experience
"Key Responsibilities• Gathering requirements for Data Warehouse related developments" "• Contributing to high level design of Data Warehouse solutions relating to development initiatives• Implementation of the AP related stages of the System Development Life Cycle" "• Ensure stability and reliability of deliverables to Production• Prepare/maintain all documentation relevant to the development process" "• Assist in the analysis and troubleshooting of application software• Support IT/Business stakeholders on an as required basis" "Essential skills and experience:• 5+ years of experience with Informatica (v8 or greater), primarily the following Powercenter modules - Designer, Workflow manager, Monitor and Repository manager" "• Testing and Deployment of Informatica code• Expert SQL skills" "• Strong understanding and practice of logical and physical database designs and concepts• Knowledge of dimensional modelling and other data warehouse design techniques• Extensive experience in ETL design, development and maintenance"
"• Industry knowledge - workers compensation products & processes (3-5 years)• Strong analytical background ideally obtained from the insurance or financial services industry" " (Workers’ Compensation preferred)• Application knowledge: MACS, Jade, WC Data Warehouse• Technical knowledge:" " • Sybase IQ (v12 or greater) • Remedy"
© Allianz Cornhill Information Services