What are your considerations on business and technical aspects if you are asked to analyze a data consolidation project which brings enterprise data from multiple business functions and platforms to a centralized RDBMS?
If you cannot catch up all the information like this one, you may ask for repeating the question. Try to grab the keywords when listening. A long question may sound complicated, but if you can catch the key aspects, it shouldn’t be too hard. The key to answer this question is to explain the purpose of data consolidation.
“Data consolidation in general is to improve data accuracy and data availability. From the business point of view, I would start to analyze the purpose of the data consolidation project, why we need to consolidate the data, what users expect for this project. I would consider the requirements and expectation of users from all parties and work with them and analyze the data functions, draw data mapping, and design the data structure. On the technical side, I would consider the approaches and technologies to implement the data consolidation projects. I would evaluate and select the right software tools to run the project. In many times I might have decide between implementing commercial tools or evaluating customized process in house. “
No comments yet
![[Valid RSS]](http://www.it-job-interview.com/wp-content/themes/andyblue-ver-1/images/valid-rss.png "Validate my RSS feed")