Astronomer's the Dataflow Cast

Scaling Airflow for Enterprise Data Platforms at PepsiCo with Kunal Bhattacharya

PepsiCo’s data platform drives insights across finance, marketing and data science. Delivering stability, scalability and developer delight is central to its success, and engineering leadership plays a key role in making this possible.

In this episode, Kunal Bhattacharya, Senior Manager of Data Platform Engineering at PepsiCo, shares how his team manages Airflow at scale while ensuring security, performance and cost efficiency.

Key Takeaways:

(00:00) Introduction.

(02:31) Enabling developer delight by extending platform capabilities.

(03:56) Role of Snowflake, dbt and Airflow in PepsiCo’s data stack.

(06:10) Local developer environments built using official Airflow Helm charts.

(07:13) Pre-staging and PR environments as testing playgrounds.

(08:08) Automating labeling and resource allocation via DAG factories.

(12:16) Cost optimization through pod labeling and Datadog insights.

(14:01) Isolating dbt engines to improve performance across teams.

(16:12) Wishlist for Airflow 3: Improved role-based grants and database modeling.

 

Resources Mentioned:

PepsiCo website

Apache Airflow

Snowflake

dbt

Kubernetes

Great Expectations

Monte Carlo

Thanks for listening to “The Data Flowcast: Mastering Apache Airflow® for Data Engineering and AI.” If you enjoyed this episode, please leave a 5-star review to help get the word out about the show. And be sure to subscribe so you never miss any of the insightful conversations.

Be Our Guest

Interested in being a guest on The Data Flowcast? Fill out the form and we will be in touch.

Build, run, & observe your data workflows.
All in one place.

Build, run, & observe
your data workflows.
All in one place.

Try Astro today and get up to $500 in free credits during your 14-day trial.