Analyze the complex data on various target systems and provide resolutions to the data issues. Validate all requirements, perform interviews with all users and developers. Perform tests and validate the data flows. Prepare ETL processes according to business requirements and incorporate all business requirements into design specifications. Develop data warehouse models and prepare reports for all meta data integration into systems. Draft ETL scripts and prepare required reports for all end users.