Data Warehouse Architect Responsibilities and Duties

Posted in Job Responsibilities

Prepare design for all metadata according to various ETLprocesses.

Perform troubleshoot on all ETL processes and resolve issues effectively.

Prepare appropriate status reports and submit it to management.

Analyze all data warehouse architecture goals and identify skill requirement for same.

Develop both physical and logical data models.

Prepare designs for database systems and recommend improvements for performance.

Maintain and develop various database scripts and tools to facilitate automation process.

Develop various ETL processes and prepare OLAP cubes.

Provide support to all data warehouse initiatives.

Analyze all data warehouse activities and identify key resources for same.

Design various ETL processes and perform tests on data.

Define meta data standards for the data warehouse

Monitor processes and develop plans to capture and access all metadata.

Develop and implement various work plans for projects.

Evaluate all proposals requests and assist to improve structure of datawarehouse.

We know how to prepare a professional resume!