Data Engineer Senior

Prashanth.A

Senior Data Engineer Teradata, Snowflake & BigQuery Python, ETL & BI Expert

******************@*****.*** 813-***-****

Professional Summary

8+ years designing scalable ETL pipelines and optimizing SQL across Teradata, Snowflake, and BigQuery. Proven success in cloud migration, performance tuning, and dashboard acceleration using Python, Shell scripting, and CI/CD. Expert in query optimization, cross-platform SQL translation.

Technical Skills

ETL & Data Tools:Teradata Utilities (BTEQ, FastLoad, MultiLoad), KNIME, Data Pipeline Design, Data Ingestion, Data Transformation Programming & Scripting: Python, JavaScript, SQL (Teradata, BigQuery, Snowflake), Shell Scripting, UNIX. BI & Reporting:Looker, ThoughtSpot, Tableau, KPI Reporting, Executive Dashboards. DevOps & Scheduling: GitLab, Git, CI/CD (Jenkins), Airflow, Control-M, Monitoring & Alerting Databases & Cloud: Teradata, Snowflake, BigQuery, Oracle, GCP, Cloud Storage, Cloud Migration. Optimization & Translation: EXPLAIN plans, AMP distribution, indexing, join strategies, cross-platform SQL translation. Professional Experience

HDR Inc., – Senior Data Engineer Jan 2023 – Present Remote

● Built ETL pipelines in Python and Shell on Linux; improved processing speed by 45% across 700TB+ datasets.

● Migrated workloads to BigQuery and developed dashboards in Looker and ThoughtSpot; cut analytics delivery time by 30%.

● Automated ETL workflows UNIX and CI/CD (Jenkins, GitLab); cut deployment time by 50% and boosted reliability.

● Designed schema and indexing strategies to resolve query skew and enhance parallelism in Teradata

● Delivered cost and margin analytics using Snowflake and Teradata; reduced query latency by 60% and enabled financial reporting across GCP and AWS

● Mentored junior analysts on Teradata performance tuning and documented workflows supporting enterprise reporting for engineering and ops teams; enabled cost and margin visibility. PLS Logistics Services., – Data Engineer Apr 2022 – Jan 2023 Remote

● Tuned Teradata queries for freight cost analysis; reduced runtime by 60%

● Resolved data skew using EXPLAIN plans and BYNET optimization

● Built advanced SQL logic for shipment KPIs and real-time ops insights

● Implemented UPI/NUPI strategies to improve join performance across large tables

● Leveraged Snowflake elasticity to scale freight analytics and join semi-structured shipment data with Teradata cost history; enabled real-time KPI dashboarding

Comcast., – Data Engineer Jul 2017 – Mar 2022 Remote

● Enhanced churn prediction models using Python and Teradata SQL across 500M+ records, reducing execution time by 70%

● Tuned joins and aggregations using EXPLAIN plans and indexing, improving dashboard refresh rates

● Built analytical views for customer segmentation and usage patterns, supporting targeted marketing

● Diagnosed performance issues and implemented fixes for data skew and suboptimal joins Projects

● Churn Analysis Tool: Python + SQL model with 85% accuracy; enabled proactive retention strategies

● P&L Dashboard for Ice Cream Chain: Delivered insights that increased projected margins by 12% Certifications

● Google Cloud Professional Data Engineer

● Google IT Automation with Python (Coursera)

Education

Master of Computer Application(MCA), Osmania University, India.

Contact this candidate