Srikanth Purohit
Atlanta,GA
Summary
Senior Data Engineer and technical lead focused on end-to-end data pipeline design, cloud integration, and Snowflake warehousing. Partner with infrastructure, engineering, and business teams to improve data quality, stabilize production workflows, and deliver automated solutions that support faster onboarding and smoother data delivery.
Overview
1
1
Certification
17
17
years of professional experience
Work History
Senior Data Engineer
Morgan Stanley
11.2022 - Current
- Developed custom AWS Glue framework to process data in Amazon S3 and load into Snowflake, enhancing data accessibility for analytics.
- Designed and built scalable Snowflake data models, database structures, and ingestion workflows to support enterprise data warehousing and analytics needs.
- Created and tuned data loading processes from AWS S3 into Snowflake, maintaining data integrity, efficient processing, and reliable data availability for downstream consumers.
- Supported design and development of scalable end-to-end data pipelines to move data from heterogeneous sources, including Hadoop,SQL Server, Impala, DB2, Oracle, and MySQL, into Amazon S3.
- Built and maintained ETL processes for data extraction, transformation, and loading to support enterprise integration, downstream analytics, and reporting needs while preserving data accuracy, consistency, and availability.
- Created reusable ETL components to automate ingestion, transformation, and loading workflows, improving operational efficiency and reducing manual work.
- Enhanced Python-based data lake ingestion framework to simplify data onboarding, automate recurring ingestion tasks, and improve pipeline reliability.
- Developed reusable Python modules and automation utilities to standardize processing workflows, improve maintainability, and support integration from multiple source systems.
- Added processing logic for scalable integration, error handling, and dependable execution of recurring data pipelines.
- Worked with infrastructure, application, and engineering teams to reduce disruptions, resolve technical issues, and maintain continuity for critical data processing workflows.
- Applied data modeling and performance tuning practices to improve query efficiency, support growing data volumes, and align data architecture with business and reporting needs.
- Monitored pipeline performance, investigated processing failures, and resolved data integration issues across source systems, AWS services, and Snowflake.
- Implemented validation, error handling, and operational monitoring practices to improve data quality, pipeline reliability, and processing efficiency.
- Collaborated with business stakeholders, data architects, infrastructure teams, and application developers to translate business requirements into scalable technical solutions.
- Contributed to architecture discussions, technical design reviews, and framework enhancements, supporting standardized data engineering practices and delivering reliable, maintainable data solutions.
Lead Software Developer
Cambia Health Solutions
08.2012 - 10.2022
- Designed, developed, and maintained efficient, scalable, and maintainable code and system solutions to address a wide range of business requirements, from routine enhancements to complex technical challenges, while adhering to established coding standards and engineering best practices.
- Led cross-functional teams across multiple concurrent projects, coordinating with engineering, business, and technology stakeholders to define priorities, resolve dependencies, manage competing deadlines, and ensure seamless collaboration and timely delivery of high-quality solutions.
- Identified technical risks, addressed production issues, and initiated continuous improvement efforts that streamlined development processes and strengthened application stability, delivering reliable solutions aligned with business objectives.
- Provided technical consulting and hands-on support to engineering teams and business partners by analyzing requirements, investigating complex programming issues, and implementing resolutions that enhanced system reliability and operational efficiency.
- Collaborated with stakeholders to translate business needs into technical designs, evaluate solutions, and recommend approaches that balance performance, scalability, maintainability, and delivery timelines.
Software Developer
Bureau Of Labor Services
01.2012 - 07.2012
- Designed, developed, and optimized applications for storing, processing, and managing time-series data, enhancing data retrieval efficiency and system performance. Implemented scalable solutions to address complex data-processing requirements for business-critical applications.
- Reduced production issues by over 50% through proactive system design, performance optimization, root-cause analysis, and preventive measures; Strengthened application stability and operational reliability by addressing technical bottlenecks and enhancing system resilience.
- Developed workforce service applications for labor agency operations
- Maintained case management software used by employment staff
- Tested code changes for public service web systems
Android Developer
CITI
03.2011 - 01.2012
- Led the end-to-end design, development, and implementation of a strategic initiative to consolidate multiple Citi vendor applications into a unified gateway, streamlining application access, improving system integration, and delivering a consistent user experience. Collaborated with cross-functional stakeholders to define technical requirements, establish architectural approaches, and ensure seamless integration across applications and backend services.
- Partnered with engineering teams, business stakeholders, and external vendors to manage dependencies and address integration challenges, ensuring successful delivery of scalable and reliable application gateway aligned with business objectives.
- Provided technical leadership and guidance to iOS developers across software development lifecycle, including requirements analysis, solution design, development, integration, testing, and deployment. Coordinated development activities, resolved technical challenges, and ensured adherence to coding standards and delivery timelines.
Software Developer
Fedex
03.2010 - 03.2011
- Designed, developed, and optimized complex SQL stored procedures, triggers, and database processing logic to support high-volume data processing and business validations. Improved query and database performance while ensuring data consistency, integrity, and adherence to defined business rules.
- Designed, developed, and implemented applications to translate, transform, mask, validate, and load check data into enterprise databases, ensuring secure, accurate, and reliable processing of sensitive financial information. Developed robust data-processing workflows to handle complex business rules while maintaining data integrity and operational efficiency.
- Collaborated with business stakeholders and subject-matter experts to gather and analyze requirements, understand business processes, and translate functional needs into scalable technical solutions. Contributed to solution design discussions and provided technical recommendations that aligned solutions with business objectives and system architecture.
- Troubleshot data-processing and database issues, performed root-cause analysis, and implemented corrective and preventive solutions to enhance application reliability and minimize operational issues. Coordinated with development, QA, and business teams throughout development lifecycle to ensure successful testing and production deployment.
Education
Master of Science - Computer Science
Indiana State University
Terre Haute, IN08-2009
Bachelor of Science - Information Technology
MVSR Engineering College
Hyderabad, India05-2006
Skills
- Data Quality & Governance: Data validation, cleansing, and transformation
- Snowflake architecture
- Data integration techniques
- ETL pipeline design
- AWS Glue
Certification
- AWS Dev Associate.
- Salesforce Admin.
EDUCATION
Master's in CS, Indiana State University , Terre Haute , IN
Bachelors in IT, Osmania University, Hyderabad, TG - India
Timeline
Senior Data Engineer
Morgan Stanley
11.2022 - Current
Lead Software Developer
Cambia Health Solutions
08.2012 - 10.2022
Software Developer
Bureau Of Labor Services
01.2012 - 07.2012
Android Developer
CITI
03.2011 - 01.2012
Software Developer
Fedex
03.2010 - 03.2011
Master of Science - Computer Science
Indiana State University
Bachelor of Science - Information Technology
MVSR Engineering College