High Tech

Data Engineering

Cloud Integration for Largest Independent Real Estate Brokerage

  • 40+ offices across 20+ US cities and regions
  • 12,000+ agents
  • $6.4B in assets

Business Need

  • Cloud data warehouse
  • Integrate online and 3rd party vendor applications to capture real-time data and customer feedback
  • Convert legacy (Python) ETL to cloud data integration platform with AWS Redshift


  • Complex Python ETL with no data model or system documentation
  • Online application data on no SQL databases or 3rd party vendor applications
  • 100M online transactions per day
  • Limited in-house knowledge for analytics and execution

Solution & Results

  • Informatica cloud application real-time integration of Qualtrics feedback, Survey System and MongoDB
  • Converted 100+ complex Python ETL interactions with IICS data mapping and replication tasks to AWS Redshift
  • Increased access to data via AWS Redshift by 63%
  • Real-time integration, reducing client effort by 2X
  • Drove the opportunity to further optimize the workforce