Summary
Overview
Work History
Education
Skills
Timeline
AWARDS
Generic

Himanshu Gautam

Delhi

Summary

A Professional Data Engineer with 3+ years of experience in working on large data sets and shaping the datasets as per the business requirements which will help the businesses to convert raw data into insights. Looking for an opportunity to excel in what I do.

Overview

4
4
years of professional experience

Work History

Senior Systems Engineer

Infosys Limited
09.2022 - Current
  • Project: GF (GlobalFoundries)
  • Conducted in-depth data analysis on large datasets to identify trends, patterns, and anomalies, driving data-informed business decisions.
  • Developed and maintained end-to-end data pipelines using StreamSets, integrating data from Oracle DB, Salesforce (SFDC) and flat files.
  • Created and optimized complex SQL queries for data extraction, transformation (ETL), and analysis.
  • Designed and implemented interactive dashboards using Grafana, enabling real-time insights for stakeholders.
  • Automated ETL workflows using AWS Lambda and CloudWatch, reducing manual processing time.
  • Monitored and optimized data processing workflows using Grafana and AWS CloudWatch, proactively resolving performance bottlenecks.
  • Built scalable data lakes on AWS, supporting structured and unstructured data for advanced analytics.
  • Translated existing ETL logic into efficient PySpark code for integration with Amazon Redshift, improving performance and maintainability.
  • Implemented rigorous data quality checks and validation mechanisms to ensure high data reliability and consistency.
  • Collaborated with cross-functional teams to define KPIs and deliver actionable insights through ad-hoc and scheduled reporting.
  • Supported exploratory data analysis (EDA) and provided insights for business teams across domains.

Systems EngineerTrainee

Infosys
03.2022 - 08.2022
  • Trained in Infosys for 3 months in the data and analytics unit where I was trained in SQL, Unix and Python.
  • Good understanding and basic knowledge in Cloud computing and Microsoft Azure

Education

B.Tech - Electronics And Communications

Guru Gobind Singh Indraprastha University
Delhi, India
10-2021

Skills

  • Data Analysis Tools: SQL, Pyspark, Python
  • Cloud Platforms: AWS (S3, EMR, Lambda, DynamoDB, CloudWatch, SNS, SQS, Glue, Athena)
  • Database Management: MySQL, PostgreSQL, OracleDB
  • Datawarehousing: Redshift
  • Orchestration: StepFunctions, Airflow
  • Data Visualization: Grafana
  • ETL Tools: Talend Open Studio, StreamSets

Timeline

Senior Systems Engineer

Infosys Limited
09.2022 - Current

Systems EngineerTrainee

Infosys
03.2022 - 08.2022

B.Tech - Electronics And Communications

Guru Gobind Singh Indraprastha University

AWARDS

Infosys Insta Award 1: The Recognition of contributing and supporting to drive operational excel.

Infosys Insta Award 2: The Recognition for actively providing resolution and maintaining the data flow up and running.

Similar Profiles

CREATE PROFILE
Himanshu Gautam