Manufacturing, Supply Chain & Logistics

Cloud

Cloud Data Migration for American Supplier of Hand & Power Tools

  • Portfolio of innovative brands + select premier private label tools in 30+ countries
  • ~$1.3B annual revenue

Business Need

  • Retire legacy technology (Alteryx)
  • Reduce technical debt
  • Optimized and efficient integration
  • Move to a cloud-based data warehousing platform (Snowflake)
  • Futureproof integration processes using Informatica IDMC

Challenge

  • Expedited migration required before legacy tool renewal deadline
  • Client gap in knowledge to make the data migration to the cloud
  • Complicated existing integration code required rewrites for efficiency and accuracy

Solution & Results

  • Increased efficiency via enhanced and automated data conversion from Informatica CDI to Snowflake
  • $100K+ annual savings in legacy technology maintenance
  • 99% reduction in integration time (from 72 hours to 30 minutes)
  • Enhanced and futureproofed processes with simple and reusable templates, scripts, and methodology
    • –50% reduction in integration flow components
    • –98% decrease in data structure build (2 days to 30 minutes)
  • Simplified data maintenance for improved agility