Venkata PST Immadestty
Dawsonville
Summary
Dynamic Sr Data Engineer with extensive experience at Verizon, specializing in cloud data engineering and ETL solutions. Achieved a 40% reduction in processing time through performance tuning and optimized data pipelines. Proven ability to lead teams and drive data governance initiatives, leveraging skills in PySpark and Snowflake to enhance data quality and analytics.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Sr DATA Engineer/Teradata Modernization Lead
Verizon
Atlanta
03.2023 - Current
- Architected modernization of Mobile AMA Reporting System (MARS) from legacy Teradata to cloud-integrated Ab Initio ingestion frameworks, enhancing data processing capabilities.
- Optimized Teradata SQL workloads, reducing processing time by 40% through indexing and data distribution strategies, improving overall query performance.
- Designed scalable ETL pipelines with TPT, BTEQ, FastLoad, and migrated workflows to ICFF datastore, streamlining data integration processes.
- Developed PySpark-based transformation pipelines and enabled end-to-end data lineage and governance.
- Implemented BigQuery-based analytics in GCP for telecom billing reconciliation and compliance reporting.
- Environment: Unix, Fixed width files, Flat files, Ab Initio GDE, Informatica Power center, TPT, FastLoad, MLoad, FastExport, BTEQ, Teradata SQL Assistant, Teradata Studio, GIT, ESP, Python, Pyspark, GCP Big Query, Oracle 12c, ICFF, Kubernetes.
Lead DATA Developer
Elevance Health (Anthem)
Atlanta
05.2022 - 03.2023
- Designed and implemented MDM golden record framework improving data quality by 35%.
- Led implementation of Snowflake data warehouse for Clinical Rule Engine (CRE DX), enhancing data accessibility and reporting capabilities.
- Built scalable ELT pipelines using Snowpipe, Streams, Tasks, and dbt.
- Automated data ingestion with AWS Glue and Lambda, significantly minimizing manual data stewardship efforts.
- Developed Databricks PySpark jobs for distributed healthcare analytics, streamlining data processing and analysis workflows.
- Environment: Teradata, Netezza, Informatica PowerCenter, Databricks, Python, PySpark, Tibco Spotfire, Snowflake, dbt (data build tool), Unix, Control-M, SQL Server, PostgreSQL, AWS Lambda, AWS Glue.
Sr ETL Developer/ Teradata Consultant
Anthem
Atlanta
10.2019 - 05.2022
- Designed enterprise Master Consumer ID (MCID) platform for unified 360 consumer view, enhancing data accessibility.
- Developed scalable Snowflake ELT frameworks and Teradata batch automation scripts to streamline data integration processes.
- Migrated analytics workloads to Snowflake and Amazon Redshift to support COVID-driven expansion, improving data processing capabilities.
- Automated ingestion pipelines from Amazon S3 to Redshift using AWS Glue and Python.
- Environment: Unix, Teradata BTEQ, MultiLoad, FastExport, TPT, Informatica 10.2.0/10.4.1, Informatica IDQ, Hadoop, AWS, Redshift, AWS Glue, Oracle, MDM, Enrich, Teradata, SQL Workbench, python, Snowflake.
Sr Teradata/ELT Consultant
PayPal
San Jose
12.2015 - 09.2019
- Led Teradata-to-Hadoop migration with Hive and Spark SQL, enhancing data processing capabilities for financial applications.
- Designed Loss Data Mart that integrated transaction, dispute, and chargeback systems to provide comprehensive loss insights.
- Implemented reconciliation frameworks that ensured regulatory compliance while optimizing Teradata workloads under strict SLA requirements.
- Environment: Teradata 15.10, Oracle 11g/10g, fixed width files, SQL Assistant, Teradata Studio, Unix, UC4, Flat Files, Teradata Viewpoint, Hadoop HIVE, PySpark, GitHub, BMC Control-m, Informatica, Abinitio.
Sr Data engineer in Data Science Team
Staples
Framingham
04.2015 - 11.2015
- Engineered scalable clickstream data platform supporting machine learning personalization and recommendation engines for Staples’ multi-billion-dollar eCommerce ecosystem.
- Designed and optimized high-volume data ingestion and transformation pipelines for capturing customer behavioral events (search, views, cart activity, purchases) enabling advanced predictive modeling and real-time product recommendations.
- Standardized, cleansed, enriched product and customer interaction datasets, contributing to $3M per month in incremental online revenue through improved recommendation accuracy and conversion rates.
Sr ETL Developer
Charter Communications
St louis
01.2015 - 04.2015
- Optimized end-to-end data pipelines to efficiently ingest, transform, and load subscriber, billing, and network performance data from diverse source systems into centralized EDW.
- Engineered scalable ETL frameworks for Charter’s enterprise data warehouse, enhancing capabilities for broadband, video, and telecommunications analytics.
- Collaborated with business stakeholders to translate complex operational and customer data requirements into effective data integration solutions.
Teradata Database Administrator
Walgreens
Lincolnshire
12.2013 - 01.2015
- Managed and maintained Teradata database system for Walgreens, ensuring optimal performance and data integrity.
- Installed, configured, and upgraded Teradata software while monitoring system performance and troubleshooting issues to uphold data security.
- Collaborated with IT teams to integrate Teradata with other systems and provided support and training to end-users.
Sr ETL Developer
FedEx
Memphis
09.2011 - 11.2013
- Designed and implemented high-performance ETL solutions that processed large-scale shipment, pricing, and customer profile data for dynamic rate calculation and revenue optimization.
- Engineered scalable data integration pipelines that consolidated operational data from multiple transportation, billing, and pricing systems into the enterprise data warehouse.
- Developed CIH/DP–Pricing Dynamic Profiles platform to enhance enterprise pricing strategy and improve shipment analytics for global logistics operations.
SQL Developer
Indus Software
07.2009 - 06.2010
- Production Planning & Control System
- Developed data acquisition system for online yarn tension monitoring across 240 positions on 115 texturizing machines.
- Generated error graphs to identify faulty positions with tension analysis.
- Facilitated online data transfer to server for real-time monitoring.
Education
Master of Science - Computer Science
University of Illinois
Springfield, USABachelor of Technology - Information Technology
JNTU
INDIASkills
- Cloud Data Engineering
- Snowflake Architecture
- Databricks
- PySpark
- AWS
- GCP
- Data warehousing
- MDM Solutions
- Data Modeling
- Dbt
- Data governance
- Performance Tuning
- Distributed Systems
- Batch Processing
- Real-Time Processing
- Data DevOps
- ETL
- ELT
- Teradata
- DB2
- MS-SQL Server
- Oracle
- Postgre SQL
- BTEQ
- Teradata Studio
- Teradata Viewpoint
- Teradata Administrator
- TOAD
- Informatica PowerCenter
- Informatica IDQ
- Ab Initio
- ICFF
- Talend
- SSIS
- Snowflake
- DBT
- ADF
- Amazon S3
- Amazon Redshift
- AWS Glue
- Google Cloud
- Big Query
- Azure
- BMC Control-M
- UC4
- ESP
- Autosys
- Clear Case
- GitHub
- Gitlab
- Bitbucket
- Tableau
- Business intelligence
- Looker
- Tibco Spotfire
- Windows
- UNIX
- Sun OS
- Shell scripting
- Python
- JAVA
- PL/SQL
- VBA
- JAVASCRIPT
- Erwin
Certification
- Teradata 12 Certified Solutions Developer, YCBKVDC2BEBQSWN1
- Teradata 12 Certified Database Administrator, 8V72PZVK1F1E1CHH
- Teradata 12 Certified Technical Specialist, E0PN3HT22JVQ1YPM
Timeline
Sr DATA Engineer/Teradata Modernization Lead
Verizon
03.2023 - Current
Lead DATA Developer
Elevance Health (Anthem)
05.2022 - 03.2023
Sr ETL Developer/ Teradata Consultant
Anthem
10.2019 - 05.2022
Sr Teradata/ELT Consultant
PayPal
12.2015 - 09.2019
Sr Data engineer in Data Science Team
Staples
04.2015 - 11.2015
Sr ETL Developer
Charter Communications
01.2015 - 04.2015
Teradata Database Administrator
Walgreens
12.2013 - 01.2015
Sr ETL Developer
FedEx
09.2011 - 11.2013
SQL Developer
Indus Software
07.2009 - 06.2010
Master of Science - Computer Science
University of Illinois
Bachelor of Technology - Information Technology
JNTU