Prathmesh Amrale

I’m a Data Engineer with ~4 years at Tata Consultancy Services (TCS), delivering enterprise Data Engineering solutions on the Stellantis account. I focus on hands-on ownership across requirements, pipeline design, deployment, and production support for analytics at scale.

On the Stellantis Order-to-Delivery (O2D) platform, I built and maintained a Single Source of Truth (SSOT) data model in Snowflake and orchestrated SQL-based ELT pipelines with Apache Airflow. I also author Python-based Airflow DAGs and PySpark scripts for transformation and validation, including timezone-aware logic for U.S. time zones and Daylight Saving Time.

I’ve improved production reliability and performance—diagnosing Snowflake warehouse resource contention to cut runtime from ~2.5 hours to ~45 minutes (~70% reduction). Recently, I extended the platform into AI-powered self-service analytics using Snowflake Cortex AI and Streamlit, reducing recurring ad-hoc SQL requests by enabling governed natural-language querying.