What methodologies, procedures, or tools have you used for planning a data integration project?

In fact, there is no widely accepted methodology for data integration.  But you can just mention the standardized systems development lifecycle methodology and explains the general steps to make data integration project going.  Here is a sample answer:

“I’ve worked on several data integration projects in the past.  I am not aware of any widely accepted methodologies specific for data integration.  In general I adapted systems development lifecycle methodology and worked through each phase of the data integration lifecycle.  The data integration projects I worked before were either focused on data conversion or data consolidation.  The first step was always analyzing the requirements and making a work plan.  Data mapping was one of the most important tasks.  In most of the projects I wrote my own customized scripts for data migration.  I used Informatica’s data conversion ETL tools in a few projects.  Database design tools like Oracle Designer and ERWin were very handy for me to manage repository and meta data for the data integration projects.”

Leave a comment

0 Comments.

Leave a Reply


[ Ctrl + Enter ]