Hi, I’m
Mohit Tyagi
Data Engineer
Ghaziabad
Summary
Meticulous and flexible Data Engineer dedicated to tracking and monitoring all pertinent metrics to support exceptional workflows and ready to improve all aspects of project planning and execution. Brings technical knowledge to prototyping and production tasks. Drives realistic management of available technical and human resources. Positively impacts both employee morale and business goals through technical guidance and statistical analysis.
Overview
4
years of professional experience
7
years of post-secondary education
7
Certificates
Work History
Infosys Ltd.Chandigarh
Senior Systems Engineer
01.2021 - Current
Job overview
- Working as ETL Developer for UK-based merchant bank.
- Good exposure to Data warehousing and ETL concepts.
- Extensively worked on Snowflake, Informatica PowerCenter (10 x) with Flat file, Informatica Intelligent Management Cloud (IDMC), Oracle DB, MS SQL Server, AWS etc.
- Created complex queries, views, and stored procedures on Snowflake.
- Worked on Control-M for creating, scheduling, and deploying jobs.
- Designed/Developed various Data integration and Data migration solutions using Informatica PowerCenter.
- Created ETL mappings and workflows for data extraction, staging, transformation, cleansing, exception handling, and load.
- Extensively worked with transformations such as Expression, Lookups, Routers, Sequence generators, Joiners, Aggregator, Union, etc.
- Applied error handling, parameterization, SQL override command task, creating pre/post-SQL queries, etc. in Informatica mappings/workflows.
- Experience on JIRA tickets for tracking work.
- Excellent organizational skills and ability to multi-task and prioritize
- Created On-Boarding, KT, and other Project Documents like HLD,DLD.
- Performed root cause analysis to provide resolutions for production issues.
- Punctual, Competent, and open to challenging work.
PlanetCast Media Service LimitedNoida
Broadcast & OTT Operations Engineer
12.2020 - 12.2021
Job overview
- To publish LIVE Events or Streams on various OTT platforms and to troubleshoot them and on-air services (300+ channels) on Linux .
- Learnt to publish UDP, RTMP and HLS streams.
- Worked on AWS Elemental, Transcoders, Encoders, Decoders & IRDs.
- Eliminated downtime through ZABBIX monitoring software tool by providing top project quality control.
Education
Inderprastha Engineering CollegeUttar Pradesh, India
Bachelor of Technology(B.Tech) from Electronics and Communication
07.2016 - 09.2020
Vanasthali Public SchoolUttar Pradesh, India
Secondary (XII) from Science
03.2015 - 05.2016
St. Thomas SchoolUttar Pradesh, India
High School
03.2013 - 05.2014
Skills
Snowflake
Informatica Power Centre (10x)
Informatica Intelligent data management cloud (IDMC)
AWS
Oracle DB
Microsoft SQL Server
Python
Power BI
Data Warehousing
PL/SQL
Control-m
JIRA
Git
TeamCity
Octopus
Linux operating system
Certification
Engineer trainee, BHEL
Additional Information
- Gender :- Male
- Nationality :- Indian
- Residence :- F - Block, House no. - 953, Sector - 3, Vaishali, Ghaziabad, U.P-201010
- Father's Name :- Mintoo singh Tyagi
- Mother's Name :- Anita Tyagi
- Siblings :- Kohina Tyagi (sister)
Timeline
Senior Systems Engineer
Infosys Ltd.
01.2021 - Current
Broadcast & OTT Operations Engineer
PlanetCast Media Service Limited
12.2020 - 12.2021
Inderprastha Engineering College
Bachelor of Technology(B.Tech) from Electronics and Communication
07.2016 - 09.2020
Vanasthali Public School
Secondary (XII) from Science
03.2015 - 05.2016
St. Thomas School
High School
03.2013 - 05.2014
hobbies
- Cooking or baking
- Exercising and healthcare
- Outdoor activities
- Team or individual sports