In today’s fast-paced, data-driven world, organizations are constantly seeking ways to optimize data management and cut costs without compromising performance. Srikanth Gangarapu, a Senior Snowflake Developer, has proven himself as a vital player in data engineering with over 14 years of hands-on experience in data warehousing, migrations, and large-scale, data-driven systems. His accomplishments showcase an expert who is not only skilled in complex data architectures but also adept at delivering tangible results that translate to substantial cost savings for enterprises.
Key Career Highlights
One of Srikanth’s most notable achievements was leading the migration of over 23TB of Teradata storage to Snowflake, resulting in a 15% cost reduction for the enterprise. This initiative streamlined data management and optimized storage, giving the organization significant financial relief.
In addition to migration efforts, Srikanth has been instrumental in developing automated solutions for data quality checks. His reusable Python modules for test automation reduced testing efforts by 40%, significantly accelerating the delivery of projects. Moreover, he played a pivotal role in decommissioning outdated Teradata tables, purging more than 50TB of non-RIM compliant data, which helped free up expensive storage and contributed to the efficiency of the data warehouse.
Technical Mastery
Srikanth is proficient in a broad range of technical tools and languages, which gives him the versatility needed to handle complex projects. Some of his core technical skills include:
- Languages: Python, Shell Script, Pyspark
- Databases: Snowflake, Vertica, Teradata, SQL Server, Oracle, Hive
- ETL Tools: Informatica PowerCenter, SSIS, IDQ, SAS, dbt
- Reporting Tools: PowerBI, QlikView
- Schedulers: TWS, Tidal, Autosys, CRON, Informatica Scheduler
- Other Tools: ERWIN, Jupyter Notebook, VS Code, Splunk, Squirrel
Professional Experience
Currently serving as a Senior Snowflake Developer at AT&T, Srikanth has been at the forefront of transforming data operations at the company since September 2020. His role involves migrating 1300+ datasets spanning across various platforms such as Teradata, SQL Server, and Vertica into Snowflake environments.
He is deeply involved in re-architecting migration strategies and fine-tuning interface processes. By designing and developing ETL pipelines using Snowflake and other tools like AZ Copy, ADLSg2, and shell scripts, Srikanth has ensured that the migration process is both efficient and robust. He also built Python libraries for automating data quality checks, significantly reducing the time required for development, testing, and implementation.
One of his key innovations has been the development of a reusable ingestion mechanism that enables the loading of historical data from multiple platforms, including Teradata and Oracle, into Snowflake. His automation work during the migration phases has reduced both time and cost, showcasing his expertise in maximizing operational efficiency.
A Problem Solver in Every Sense
Srikanth is known for his problem-solving abilities. His work in creating complex shell wrappers for handling file processing in systems like NiFi and ADLSg2 further emphasizes his technical versatility. These solutions handle crucial tasks like file publishing, loading, and job management, contributing to smoother operational workflows.
Moreover, Srikanth’s role extends beyond development—he ensures all post-migration sanity checks are thoroughly conducted and creates comprehensive support documentation for operations teams to maintain the systems.
The Future of Data Engineering with Srikanth Gangarapu
With organizations increasingly turning to cloud-based solutions for their data needs, experts like Srikanth Gangarapu are essential for success. His extensive experience in Snowflake migrations, cost-saving initiatives, and technical prowess positions him as a key figure in the data engineering landscape.
Srikanth’s approach to data engineering combines technical skill with a strategic mindset, enabling businesses to harness the full potential of their data while optimizing costs and performance. With his ongoing commitment to excellence, he continues to set benchmarks in the industry for efficient and scalable data solutions.