Tharun Kumar Kouda
About
Detail
sesonal Data engineer with 4+ years of experiecne
Austin, Texas, United States
Contact Tharun regarding:
work
Full-time jobs
Starting at
USD50/hour
Timeline
work
Job
school
Education
Résumé
Jobs
verified_user
0% verified
- TData EngineerTecArtists IncFeb 2023 - Current (2 years 3 months)
Data EngineerDeloitteJul 2020 - Aug 2022 (2 years 2 months)• Leveraged PySpark and Airflow frameworks to design and deploy ETL data pipelines, seamlessly integrating and processing 2+ TB of clinical trials data from 5 distinct sources (csv files, APIs, MySQL tables) enabling advanced research and analysis. • Initiated API calls through postman to fetch all the responses in Json and load the Json’s to staging layer in S3. • Built scripts that perform end to end data cleansing process using SQL for 2 million records per migration. • Analyzed ETL process failures, data anomalies, and data warehousing issues identified by 300+ end-users. • Corrected the mapping of therapeutic area to disease for 5 data sources, resulting in 100% accuracy of mapping using PySpark SQL.- Data EngineerDeloitteJul 2020 - Aug 2022 (2 years 2 months)• Leveraged PySpark and Airflow frameworks to design and deploy ETL data pipelines, seamlessly integrating and processing 2+ TB of clinical trials data from 5 distinct sources (csv files, APIs, MySQL tables) enabling advanced research and analysis. • Initiated API calls through postman to fetch all the responses in Json and load the Json’s to staging layer in S3. • Built scripts that perform end to end data cleansing process using SQL for 2 million records per migration. • Analyzed ETL process failures, data anomalies, and data warehousing issues identified by 300+ end-users. • Corrected the mapping of therapeutic area to disease for 5 data sources, resulting in 100% accuracy of mapping using PySpark SQL.
- jr. Data EngineerAditya Birla groupAug 2018 - Jul 2020 (2 years)• Managed 50+ data analysis related requests from clients, traced issues, and proposed efficient resolution within 24 hours. • Created 25+ data testing scenarios in the application to ensure claims data accuracy. • Gathered detailed requirements from clients and compiled comprehensive documentation of functional and technical requirements, fostering project clarity. • Implemented Spark SQL Scripts to effectively store monthly incremental claims data in S3, resulting in a 30% reduction in data storage errors and improved data integrity. • Reduced average search time to 30 MS by working on query optimization techniques using advanced SQL aggregation functions. • Formulated recommendations and support to senior team members for the project
Education
verified_user
0% verified
- Master's degree, Data analyticsClark UniversityAug 2022 - Nov 2023 (1 year 4 months)Course work: 1. Linear regression. 2. Data engineering using Microsoft SQL server and Tableau Prep 3. Data visualization using tableau.
- NBachelor's degree, Mechanical EngineeringNational Institute of Technology WarangalAug 2016 - Aug 2020 (4 years 1 month)Relevant courses: 1. Computer programming(C,C++) 2. Numerical and statistical methods 3. Management science and productivity 4. Production Planning and Control 5. Marketing Management 6. Mechatronics