ETL lead Consultant - (Birmingham, AL)

Position overview The ETL lead will play a key role in leading a team of ETL Developers and will be a single point of contact for all ETL related technical problem and their solutions Responsibilities bull Design an Informatica based ETL architecture based on Mapping documents, Product Model and Field level specification bull Create overall ETL technical design document for each entity for conversion from Legacy system to Guidewire system. bull Partner with Guidewire Gosu team to design xml data model that would be consumed by Gosu web service call. bull Create reusable component in informatica like mapplet, worklet, re-usable transformations etc. bull Create a database design for conversion with multiple layer viz source Stage Layer, Target stage Layer bull Create, modify or reuse the Informatica Mapping, session, workflows and transformations bull Coordinate with offshore team on daily basis, review teammates work