Who is Prasanth Kumar? Overview
A concise factual answer block for searchers comparing this professional profile.
Quick answer
Prasanth Kumar is listed as Data Engineer at HCLTech, based in Bangalore Urban, Karnataka, India. AeroLeads shows a matched LinkedIn profile for Prasanth Kumar.
Prasanth Kumar previously worked as Data Engineer at Ford Motor Company and Data engineer II at Micron Technology. Prasanth Kumar holds Btech - Bachelor Of Technology, Electrical, Electronics And Communications Engineering from Usha Rama College Of Engineering & Technology,Nh-5, Telaprolu, Near Gannavaram, Unguturu Mandal, Pin- 521109.(Cc-Ng).
Company email context
Email format at HCLTech
This section adds company-level context without repeating Prasanth Kumar's masked contact details.
HCLTech
Review company-level records connected to Prasanth Kumar before choosing the right outreach path.
Profile bio
About Prasanth Kumar
I am a Data Engineer with 5 years of Experience in migrating on-premise databases to GCP. I am a Google Certified Associate Cloud Engineer.I have worked on the following migrations.1. Oracle to Bigquery:In this project, I have replicated the oracle on-premise database to Bigquery to get insights from the data. I have used GCP VM to extract the data from the oracle database as CSV files and load them into Cloud Storage which I used as the staging location. As I am extracting the data from the source, I extracted them in chunks of size, 1 Million. Each extract is given a unique job id which will be used in the next step. As the next step, I took the job id generated and used that job id to load the data that is stored in cloud storage to Bigquery using the Bigquery python API. All the actions that we have performed till now will be logged and also there are control tables that will store the last updated timestamp so that I can help us in loading incremental data. I have automated the whole batch and incremental load pipelines without requiring no manual intervention at all.Python libraries used: cx_oracle, pandas, google-cloud-storage, google-cloud-bigquery, datetime, os.GCP services used: Bigquery, Cloud Storage, Cloud Scheduler, Cloud Functionsother technologies used : shell scripting2. Postgres to CloudSQL:As discussed in the previous project, The first part is also the same here i.e., loading the data from the source to the GCS bucket. Now from the second part i.e., loading the data from the GCS bucket to CloudSQL, I have used cloud functions which will automatically trigger on ingestion of the CSV file into the specified GCS bucket. And the python script will automatically load the data into CloudSQL. I have kept control tables which will help in the incremental load. This pipeline has been automated completely and doesn't require any manual intervention.Python libraries used: psycopg2, gcsfs. google-cloud-storage,GCP services used : Cloud SQL, Cloud FunctionsAlso I have worked on the below migrations3. MySQL to CloudSQL4. SQLServer to Bigquery#etl #googlecloud #spark #migration #machinelearning #dataengineering
Current workplace
Prasanth Kumar's current company
Company context helps verify the profile and gives searchers a useful next step.
Hcltech
AeroLeads page
4 roles
Prasanth Kumar work experience
A career timeline built from the work history available for this profile.
Data Engineer
Skills used : Python , Airflow, GCP, Bigquery , Alteryx Designer, hive, Astronomer, Google Cloud Composer, SQL, git, Data Preparation, ETL, Data Warehouses, Data marts, Data lakes• Converted the complex Alteryx workflows into Bigquery SQL of 2000+ lines each.• Built Datamarts from the existing datawarehouses and participated in the completion of final analytic products.• Used Airflow to migrate 20+ sources from Datawarehouse to Datamarts.• Loaded semi structured data from CSV to Bigquery .• Created alert mechanism and data validation tool using python to check if the pipeline is working as expected.
Data Engineer Ii
Sep 2022 - Feb 2023
Data Engineer
I am a Data Engineer with 3 years of Experience in migrating on-premise databases to GCP. I am a Google Certified Associate Cloud Engineer.I have worked on the following migrations.1. Oracle to Bigquery:In this project, I have replicated the oracle on-premise database to Bigquery to get insights from the data. I have used GCP VM to extract the data from the oracle database as CSV files and load them into Cloud Storage which I used as the staging location. As I am extracting the data from the source, I extracted them in chunks of size, 1 Million. Each extract is given a unique job id which will be used in the next step. In the next step data is loaded into Bigquery using bq API. All the actions that we have performed till now will be logged and also there are control tables that will store the last updated timestamp so that I can help us in loading incremental data. I have automated the whole batch and incremental load pipelines without requiring no manual intervention at all.Python libraries used: cx_oracle, pandas, google-cloud-storage, google-cloud-bigquery, datetime, os.GCP services used: Bigquery, Cloud Storage, Cloud Schedulerother technologies used : shell scripting2. Postgres to CloudSQL:As discussed in the previous project, The first part is also the same here i.e., loading the data from the source to the GCS bucket. Now from the second part i.e., loading the data from the GCS bucket to CloudSQL, I have used cloud functions which will automatically trigger on ingestion of the CSV file into the specified GCS bucket. And the python script will automatically load the data into CloudSQL. I have kept control tables which will help in the incremental load. This pipeline has been automated completely and doesn't require any manual intervention.Python libraries used: psycopg2, gcsfs. google-cloud-storage,GCP services used : Cloud SQL, Cloud FunctionsAlso I have worked on the below migrations3. MySQL to CloudSQL4. SQLServer to Bigquery
Jul 2019 - Sep 2022
2 education records
Prasanth Kumar education
Btech - Bachelor Of Technology, Electrical, Electronics And Communications Engineering
Usha Rama College Of Engineering & Technology,Nh-5, Telaprolu, Near Gannavaram, Unguturu Mandal, Pin- 521109.(Cc-Ng)
Mpc, Junior High/Intermediate/Middle School Education And Teaching
Sri Chaitanya Junior College
FAQ
Frequently asked questions about Prasanth Kumar
Quick answers generated from the profile data available on this page.
What company does Prasanth Kumar work for?
Prasanth Kumar works for HCLTech.
What is Prasanth Kumar's role at HCLTech?
Prasanth Kumar is listed as Data Engineer at HCLTech.
Where is Prasanth Kumar based?
Prasanth Kumar is based in Bangalore Urban, Karnataka, India while working with HCLTech.
What companies has Prasanth Kumar worked for?
Prasanth Kumar has worked for Hcltech, Ford Motor Company, Micron Technology, and Tata Consultancy Services.
How can I contact Prasanth Kumar?
You can use AeroLeads to view verified contact signals for Prasanth Kumar at HCLTech, including work email, phone, and LinkedIn data when available.
What schools did Prasanth Kumar attend?
Prasanth Kumar holds Btech - Bachelor Of Technology, Electrical, Electronics And Communications Engineering from Usha Rama College Of Engineering & Technology,Nh-5, Telaprolu, Near Gannavaram, Unguturu Mandal, Pin- 521109.(Cc-Ng).
Find 750M verified contacts
Search by job title, company, industry, location, and seniority. Export verified B2B contact data when you need it.
Start free trial