Summary
Overview
Work History
Education
Skills
Certification
Websites
Timeline
AdministrativeAssistant

Girish Iyer

Bengaluru,India

Summary

A proven track record of working in a fast-paced environment. Ability to adopt and learn new technologies

Overview

8
8
years of professional experience
1
1
Certification

Work History

Data and Automation Engineer

Apple
Hyderabad, India
03.2023 - Current
  • Prompt Engineering: Developed a module to convert a natural language user query to SQL query using LLMs
  • Data Pipeline to ingest data from one data center to another using Python,Pyspark and DB Specific tools (Cassandra: sstableloader, Oracle: Datapump and Mongo: mongodump)
  • PII Data anonymization in Cassandra using PySpark
  • Automation for Migrating various Databases from on-prem to AWS.
  • Self Service Portal for deploying SQLs across multiple DB technologies
  • Designed and Developed Self Service Portal and tools for various day to day operational activities like Inventory Management, Monitoring DB Connections, Managing DB User Credentials

Data Engineer

Affine Analytics
Bengaluru, India
10.2018 - 02.2020
  • K.O.C.H: Ingesting data to datalake from various public sources like NASDAQ, NOAA, Weather data etc using PySpark and Python
  • Car Rentals: Feature Engineering and model building using AWS Sagemaker for estimating optimal revenues per click
  • P&G: Extracting data from various sources and transforming them to Identify potential customers who are bound to buy certain products in near future
  • GroupOn: Extracting data from various sources and transforming them to identify Affinity and Cannibaliztion among the products

Data Engineer

Tech Mahindra
Bengaluru, India
08.2016 - 10.2018
  • 3 U.K: Ingesting data to Datalake(Azure) from various sources like CSV files, JSON files, On-prem databases and Kafka using PySpark.
  • Loading data to Data Warehouse from Datalake using PySpark and PLSQL

Education

Master of Science - Data Engineering (Pursuing)

IIITB & Liver Pool John Moores University
UpGrad
11.2022

Bachelor of Engineering - Electronics And Communication

AMC Engineering College (VTU)
Bengaluru
05.2016

Pre University - PCME

St.Josephs Indian Composite
Bengaluru
05.2012

Class X -

Navadeep School
Benaluru
04.2010

Skills

Languages: Python, PL/SQL, Shell Script and Scala

Tools, Technologies and Frameworks: Hadoop, Hive, Spark, Docker and Kubernetes(Basics)

Databases: Oracle, Cassandra, Postgres and Mongo

AWS Services: EC2, EMR, Lambda, RDS, S3, IAM, Cloudformation, Cloudwatch, VPC, KMS etc

Certification

  • AWS Solution Architect - Associate

Timeline

Data and Automation Engineer

Apple
03.2023 - Current

Data Engineer

Affine Analytics
10.2018 - 02.2020

Data Engineer

Tech Mahindra
08.2016 - 10.2018

Master of Science - Data Engineering (Pursuing)

IIITB & Liver Pool John Moores University

Bachelor of Engineering - Electronics And Communication

AMC Engineering College (VTU)

Pre University - PCME

St.Josephs Indian Composite

Class X -

Navadeep School
Girish Iyer