automated procedures for end-to-end etl and cleanse of legacy data