Data integration – Job skills required for success

0

Data integration, on any project, can be very complex – and it requires a tremendous amount of detail. The person I would pick for my data integration team would have the following skills and characteristics:

  1. Has an enterprise perspective of data integration, data quality and extraction, transformation and load (ETL):
    1. Understands data quality, data profiling and ETL tools.
  2. Understands the need for enterprise data management:
    1. Including data modeling for the enterprise and each data integration project.
  3. Understands database performance for load and retrieval of data:
    1. This should include indexing, partitioning and views.
    2. Reporting environment implementation.
    3. Propagating data to other systems (if necessary).
  4. Possesses the ability to write highly optimized SQL and/or consult with developer to achieve results:
    1. Once in a while we have to “roll our sleeves up” and help out.
    2. Code reviews and testing will be required.
  5. Participates in gathering and prioritizing the requirements:
    1. Collaborates in writing the scope, requirements and detailed technical document.
  6. Is a MASTER at spreadsheets:
    1. Mapping from one or more sources to a target requires documentation on the process, quality of the data, anticipated values and any other technical notes required for the data integration project.
  7. Works well with others in a complex, intense development environment.
  8. Possesses leadership skills:
    1. Working and delegating to other team members.
    2. Reporting progress to project managers and upper management (when required).
      1. PowerPoint is a MUST.

1439322506230Sounds like a SUPER person doesn’t it? Actually, data integration requires a super-person who understands the business needs and can articulate that information into technical documents. Not an easy job to fill, and it may take multiple people to accomplish these tasks. If you find someone with these qualities, hang onto this person. They are worth their weight in gold.


SAS is a leader in Gartner Magic Quadrant for data integration tools for the fifth consecutive year.

Share

About Author

Joyce Norris-Montanari

President of DBTech Solutions, Inc

Joyce Norris-Montanari, CBIP-CDMP, is president of DBTech Solutions, Inc. Joyce advises clients on all aspects of architectural integration, business intelligence and data management. Joyce advises clients about technology, including tools like ETL, profiling, database, quality and metadata. Joyce speaks frequently at data warehouse conferences and is a contributor to several trade publications. She co-authored Data Warehousing and E-Business (Wiley & Sons) with William H. Inmon and others. Joyce has managed and implemented data integrations, data warehouses and operational data stores in industries like education, pharmaceutical, restaurants, telecommunications, government, health care, financial, oil and gas, insurance, research and development and retail. She can be reached at jmontanari@earthlink.net.

Leave A Reply

Back to Top