CLOUD INTEGRATION FOR LARGEST INDEPENDENT REAL ESTATE BROKERAGE

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

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

Challenge

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

Z

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