Rishith Kothapalli

Background

About Rishith Kothapalli

I am a results-driven Data Engineer with 5+ years of hands-on experience building scalable, cloud-native data solutions and architecting modern data platforms across diverse industries, including energy, finance, airlines, and telecom. My expertise spans across end-to-end data engineering, including data architecture, ETL pipeline development, real-time streaming, API integrations, and LLM-powered AI applications. I specialize in leveraging cutting-edge tools like Google Cloud Platform (GCP), Microsoft Azure, Snowflake, MemSQL (SingleStore), Oracle, and Apache Airflow to deliver high-performance data ecosystems. At the core of my work lies: Building privacy-compliant, automated ETL workflows using Apache Airflow, Azure Data Factory, and PySpark. Designing Star and Snowflake schema data models, optimizing data accessibility and query performance. Architecting cloud data warehouses in Snowflake and Synapse Analytics, enabling real-time analytics and executive-level dashboards. Developing FastAPI-based service layers in Python for seamless communication between UI and databases. Implementing stored procedures (Oracle PL/SQL, MemSQL, SQL Server) and managing large-scale data migrations across cloud and hybrid systems. Driving innovation through LLM integration, prompt engineering, and AI-powered visualization workflows for internal applications. I’ve delivered impactful solutions using Power BI, Tableau, SSRS, and integrated tools like Tealium, Adobe Analytics, and Cognos, always ensuring end-to-end data integrity, governance, and scalability. Passionate about cross-functional collaboration, I thrive in agile environments and work closely with product teams, data scientists, and business analysts to deliver actionable insights and support enterprise decision-making.