Nitish Tyagi
Chandigarh
Summary
Data engineer with 3+ years of experience having a strong background in SQL, Python, Snowflake and ETL. Familiar with the majorly used AWS cloud services and Proficient in designing and maintaining data infrastructures, developing ETL pipelines, and creating efficient data processing workflows. Skilled in collaborating with cross-functional teams and delivering actionable insights to stakeholders.
Overview
1
1
Certification
Work History
Data Engineer
Priority Technology Holdings
2 2022 - Current
- Designed and developed ETL pipelines using Python and SQL to load data from various sources to Redshift and Snowflake.
- Building views and setting up timeline for all the entities present in the system. Designed ETL framework to Extract Data from unstructured sources, Transform the data and load data into Enterprise Data warehouse.
- Optimized queries and data processing jobs to improve performance. Automated the data migration flow using Snowflake stored procedures.
- Experience in handling semi-structured data, like JSON.
Created data visualizations using Looker to present insights and key performance indicators to business stakeholders, resulting in better-informed decision making. - Collaborated with cross-functional teams to gather requirements and translate business needs into technical specifications for data solutions.
- Designed, constructed, and maintained scalable data pipelines for data ingestion, cleaning, and processing using Python and SQL.
- Used critical thinking and problem-solving skills to troubleshoot data engineering issues, resulting in improved data accuracy and reliability.
Education
XII Th Standard -
RBDAV Sr Sec Public School
BathindaB.E - Information Technology
JSS Academy of Technical Education
NoidaSkills
- Data pipeline control
- SQL query writing
- Python Coding Abilities
- Data warehousing and ETL
Projects
Curated and Datamart Implementation
Designed snowflake stored procedures to automatically implement SCD-2 , discarding duplicate events followed by maintaining versioning into the curated layer .
Implemented DataMart on top of DataWarehouse to fulfill the BI requirements . Integrated Self-service BI platform(looker) with DataMart to reduce stakeholders dependency on Data Analysts .
Designed stored procedures to automatically take care of all the data migration and table refactoring happening at the application end.
Certification
- Google:Data Analytics Certificate
- MySQL for Data Analytics and Business Intelligence
- AWS cloud practitioner - Udemy
- Snowflake Masterclass - Udemy
Timeline
Data Engineer
Priority Technology Holdings
2 2022 - Current
XII Th Standard -
RBDAV Sr Sec Public School
B.E - Information Technology
JSS Academy of Technical Education
Similar Profiles
Michelle HetheringtonMichelle Hetherington
SENIOR IMPLEMENTATION ACCOUNT MANAGER at Priority Technology HoldingsSENIOR IMPLEMENTATION ACCOUNT MANAGER at Priority Technology Holdings
Aditya BatraAditya Batra
Senior Software Engineer at Priority Technology HoldingsSenior Software Engineer at Priority Technology Holdings
Nitish TyagiNitish Tyagi
Application Solutions Engineer (Data Analyst) at Priority Technology HoldingsApplication Solutions Engineer (Data Analyst) at Priority Technology Holdings