Can you name some of the popular data migration tools available to database administrators?
"Choosing a data migration tool depends on several factors. These include the environment, the data sources, the data warehouse, and the platforms you are using. The tools I like include Power center Informatica, Elixir repertoire for data migration, data migrator (IBI), and SQL Server integration services (SSIS.) These cover 90% of my needs, are flexible, and are easy to work with."
By asking this question, the interviewer is seeking to understand what tools you are familiar with and whether the tools you use are the same ones they are currently using. Keep in mind that they may also be interested in whether you can bring new tools into their organization. Again, having done your research, you should be familiar with what they already use and can structure your answer to either match their tools or suggest new ones.
"There are several excellent data migration tools currently available. The ones I prefer include Oracle warehouse builder, SAP data services, IBM infosphere information server, and SAS data management. These address my needs and integrate well with the systems I typically use."
