Travelling, Cricket, Web Series, Movies, Casual Singing
Shashwat Singh
Senior Data Engineer
Noida
Summary
Senior Data Engineer / Senior ETL Developer having 5 yrs. of experience operating in Data Engineering and Data Analytics domain with different Insurance, Life Sciences and HealthCare clients in demanding internal and external development, migration, support roles. Applied exceptional technical knowledge and extensive operational experience. Experienced and dedicated ETL developer with several years of experience identifying efficiencies and problem areas within data streams, while communicating needs for projects.
Overview
5
5
years of professional experience
6
6
Certificates
2
2
Languages
Work History
Senior Data Engineer
LTIMindtree
06.2022 - Current
- Working as Senior ETL Developer for detailed Revenue and Premium data responsible for UAT/ PROD/DEV data loads, validation, analysis and development of new integration along with ad hoc fixes of data from 60 major fiduciary applications across globe and load into DWH.
- Worked as Expert ETL resource with insurance brokerage client to analyses and load UAT/PROD data in data warehouse received from multiple source vendors.
- Prepared POC for new integrations.
- Worked as IICS administrator to maintain and install secure agent and services and grant access to user as per policy and license, Collaborate with cross-functional teams, including data analysts, database administrators, source vendor, and business stakeholders.
- Ensured compliance with data governance policies and industry regulations.
- Implemented security measures to safeguard sensitive data during ETL process.
- Worked on Azure/JIRA board and confluence page for story creation and sprint planning.
- Worked on development of SCD1 and SCD2 mapping and task flows to process JSON files and load them into SQL Server.
- Prepared query of DDL structures for various tables in SQL Server along with analysis and backtracking of data.
- Created DDL, JSON and hierarchical schema for objects SCD1 and SCD2.
- Worked on Cloud Data Migration project from Informatica PC to IICS.
- Involved in preparation of UT document, analysis and validation of workflow, mapping, tasks in both PC and IICS.
- Guided team in solving mapping/workflows/session issues related to expressions query and connections, maintain delivery tracker for timely delivery of sprints.
- Presented summary of defects encountered during testing.
- Developed File Listener, Mass Ingestion, Task flows, Mappings using multiple transformation and integrating them with Salesforce, Snowflakes and AWS S3.
- Delivered more than 280+ assets on individual basis.
- Worked on Cloud Data Migration project in Informatica PC and IICS.
- Collaborated with cross-functional teams to define requirements and develop end-to-end solutions for complex data engineering projects.
- Worked as ETL tester in life insurance project to validate and prepare all tables, test cases.
Senior Associate
Genpact
09.2021 - 07.2022
- Worked as primary resource for IICS data integration development role, responsible for end-to-end Production Veeva CRM data.
- Worked and monitored complete cadence execution, analyzed and resolved issues encountered, implemented ad hoc files delivery to vendors.
- Created different connection in IICS to link with AWS S3 and Redshift, Salesforce, Snowflake, SQL / Oracle Database schemas and Flat files connection to server.
- RFC creation for team members.
- Developed SFTP-S3 pass through jobs for data migration to S3 for more than 20+ vendors using IICS.
- Developed File Listener, Mass Ingestion, Tasks, Task flows, Mappings using multiple transformation, lookups.
- POC for upcoming projects on IICS.
Technical Associate
Genpact Limited
07.2019 - 08.2021
- Mentored 6-7 resources members within KTLO project.
- Performed and worked extensively on ETL process to transform, cleanse, load data into various target system.
- Performed extensive application validations, data validations to ensure data consistency.
- Sanity checks of applications -Informatica MDM, IICS, IDD, TWS, IBM Datastage.
- Involved in multiple knowledge transition cross tower and internal.
- Hands on experience in DataStage, Informatica MDM, IBM TWS and WinSCP (SSH, SFTP, Amazon S3 file transfer) tool.
Internship
Genpact
02.2019 - 07.2019
- Worked as Monitoring resource in LifeSciences and Health care support project on UAT / PROD environment.
- Gained hands-on experience in various software programs, increasing proficiency and expanding technical skill set.
- Supported staff members in their daily tasks, reducing workload burden and allowing for increased focus on higher-priority assignments.
Education
B. Tech - Computer Science And Engineering
05.2015 - 05.2019
GPA: 6.5
12th: Intermediate -
04.2014 - 05.2015
- Percentage: 65.20
- PCM
10th: High School -
04.2012 - 05.2013
- Final Grade: [75.00]%
Skills
IICS
Informatica PowerCenterSQL
Data Warehousing
Data MigrationUnixData IntegrationETL (Extract Transform Load)PostmanProject ManagementData GovernanceWinSCPIICS Integration with Salesforce / Snowflake /On prem/CloudAWS CloudJIRAAzure DashboardOracle Database
IDMC
Certification
IICS: Cloud Data Integration Services R38 (OnDemand)
Timeline
AWS Technical Accredited Badge
03-2024
@Informatica Cloud Data Governance & CatLog Foundation Series
02-2024
@Informatica IDMC Foundation Certified!
02-2024
Generative AI: Beginners
11-2023
IICS: Cloud API Services for Developer
08-2022
IICS: Cloud Data Integration Services R38 (OnDemand)
07-2022
Senior Data Engineer - LTIMindtree
06.2022 - Current
Senior Associate - Genpact
09.2021 - 07.2022
Technical Associate - Genpact Limited
07.2019 - 08.2021
Internship - Genpact
02.2019 - 07.2019
Jaypee University of Engineering And Technology - B. Tech, Computer Science And Engineering
05.2015 - 05.2019
St. Joseph's Convent School - 12th: Intermediate,
04.2014 - 05.2015
St. Joseph's Convent School - 10th: High School,
04.2012 - 05.2013