Case Study: Revance Aesthetics achieves near real-time client reporting with Matillion

Producing client-ready reports in a fraction of the time

Revance Aesthetics used Matillion ETL to address slow client reporting and support multiple QE/dev environments with multiple microservices. Its reports previously took up to an hour to process, and it needed a way to produce near real-time reporting.

Using Matillion ETL, Revance built custom incremental loads with Shared Jobs and used Matillion APIs and Bitbucket pipelines to spin up QE/dev environments instantly and run full and incremental syncs without direct access to Matillion. With Matillion, Revance now delivers client reports with 10 minute total latency, has improved engineer productivity, reduced development times, and optimized code maintenance with proactive error alerts.

Revance Aesthetics

Vijay Tummala

Engineering Manager