Data Science

How do I build a scalable ETL pipeline for real-time Data Engineering in a cloud environment?

RY Asked by Ryan Miller · 14-05-2025
0 upvotes 14,281 views 0 comments
The question

I am looking to move from batch processing to a real-time streaming architecture. In the world of Data Engineering, is it better to use a managed service like AWS Glue, or should I build a custom solution using Apache Kafka and Flink? I need to handle roughly 10TB of event data daily and want to ensure my schema remains consistent across all downstream consumers.

3 answers

0
HE
Answered on 18-05-2025

Transitioning to real-time Data Engineering is a major architectural shift. If your team is small, I strongly recommend a managed service like AWS Glue or GCP Dataflow to reduce operational overhead. However, for 10TB a day, the costs can spiral quickly. A custom Kafka and Flink setup offers much more granular control over backpressure and state management. The "Gold Standard" here is using a Schema Registry to prevent downstream breakage. In my experience, a well-tuned Flink job can handle millions of events per second with sub-second latency, but you’ll need a dedicated DevOps resource to manage the cluster health and scaling policies effectively.

0
JU
Answered on 22-05-2025

Are you planning to use a Lakehouse architecture like Delta Lake or Apache Iceberg for the storage layer of this Data Engineering project?

RY 25-05-2025

That is a great question, Justin! I’m actually leaning toward Delta Lake. I want to ensure that our Data Engineering pipeline supports ACID transactions so we don't end up with partial writes during a cluster failure. Using an open-table format seems like the best way to keep our data accessible for both BI tools and machine learning models without having to constantly move files around between different storage buckets and databases.

0
ME
Answered on 28-05-2025

I’d suggest looking into "dbt" for the transformation layer. It has become an industry standard in modern Data Engineering for managing SQL-based logic.

HE 31-05-2025

I totally agree with Megan! Using dbt within your Data Engineering workflow allows you to treat your data transformations like code, complete with version control and automated testing.

Share your thoughts

Your email address will not be published. Required fields are marked (*)

Professional Counselling Session

Still have questions?
Schedule a free counselling session

Our experts are ready to help you with any questions about courses, admissions, or career paths. Get personalized guidance from industry professionals.

Request a Call Back

Search Online

We Accept

We Accept

Follow Us

"PMI®", "PMBOK®", "PMP®", "CAPM®" and "PMI-ACP®" are registered marks of the Project Management Institute, Inc. | "CSM", "CST" are Registered Trade Marks of The Scrum Alliance, USA. | COBIT® is a trademark of ISACA® registered in the United States and other countries.

Book Free Session