Default profile banner
ST

Somya Tuteja

@somyatuteja

Data Engineer at Intuit

Bangalore, India

IntuitIIIT-Delhi

Somya Tuteja is an experienced Data Engineer with 5 years of expertise in building and optimizing ETL pipelines. Proficient in technologies such as Python, AWS Redshift, Spark, and SQL, she has a proven track record of automating data processes and integrating data from multiple external sources.

Experience

Software Engineer 2

Intuit

Full-time•Invalid Date - Present•Bangalore, India

Designed, built, scaled and maintained 10+ data (ETL) pipelines. Created a tool to support automatic table schema changes saving 2-3 hours for the developer per deployment. Created a Third Party Adapter tool to ingest data from 5+ external sources and integrate it into Intuit's data lake.

Senior Associate (Data Engineer)

Axtria

•Invalid Date - Invalid Date

Automated the data refresh for data analysis dashboards using SQL and HANA, bringing the time down from 3-4 days to 1 hour and allowed daily refresh. Developed multiple APIs using Python to streamline the Data Quality checks processes across multiple projects.

Associate (Data Engineer)

Axtria

•Invalid Date - Invalid Date

Developed the ETL pipeline for a project from legacy SQL Server to AWS Redshift using Matillion. Leveraged Python’s APIs, fuzzy and NPI techniques to successfully identify 80% of client's customers from raw data.

Analyst (Data Engineer)

Axtria

•Invalid Date - Invalid Date

BRAVO Award Winner for Q1 2019 for developing an API to perform all connections. Automated the process of data loading from multiple vendors to data warehouse using Python and Redshift, bringing down the run time from 2 weeks to 1 week.

Technology Intern

Morgan Stanley

•Invalid Date - Invalid Date

Created an app for Internal employees to view presentations.

Education

IIIT-Delhi

M.Tech

Computer Science

Invalid Date - Invalid Date•Grade: 7.95

Indira Gandhi Institue of Technology (now IGDTUW)

B.Tech

Electronics and Communication

Invalid Date - Invalid Date•Grade: 70.08%

Jankidas Kapur Public School

AISSCE (Class 12 - CBSE)

Invalid Date - Invalid Date•Grade: 88.4%

Skills

Python
AWS Redshift
Spark
SQL
MySQL
Matillion
ETL
PySpark
Hadoop
AWS
Hive
MapReduce
Scala