Scott McGuffin

Author's details

Name: Scott McGuffin
Date registered: July 14, 2016

Biography

Scott McGuffin is a Principal Consultant who has been with Dev Technology for over 13 years. Scott has worked on various projects at ICE supporting mission critical systems and leading complex database migrations.

Latest posts

  1. The Caveman’s Guide to Data Profiling: Part 3 — July 19, 2016
  2. The Caveman’s Guide to Data Profiling: Part 2 — July 18, 2016
  3. The Caveman’s Guide to Data Profiling: Part 1 — July 15, 2016

Author's posts listings

The Caveman’s Guide to Data Profiling: Part 3

In Part 2, we discussed how to create a script to generate SQL to check for potentially invalid source data prior to beginning work on an ETL project. In our final installment, we’ll discuss some of the other data issues that you will want to evaluate and what your final meta-data script might look like. …

Continue reading »

The Caveman’s Guide to Data Profiling: Part 2

In Part 1, we discussed why you need to get started immediately with profiling your data on an ETL project and why you’ll probably need to jump in with Caveman tools. These tools are simple SQL statements, some thing to handle the control logic, and the data dictionary where your source data resides (or is …

Continue reading »

The Caveman’s Guide to Data Profiling: Part 1

Normally on our blog, our Director of Technology and all around rock star, Adam D’Angelo, fills you in on the latest technologies and techniques that we are using at Dev Technology Group to deliver value to our partners and exceed expectations by design. But this year, Adam added a new title to his resume, “Dad.” …

Continue reading »