Prashant Goel

About Prashant Goel

I am an ETL developer with 4 years of experience in data warehousing, data integration, and data engineering. I have worked with various tools and technologies such as Informatica PowerCenter, IICS, AWS, Qlik Data Catalyst, SQL databases, Unix and Python. I have successfully delivered solutions to problems in different domains such as telecom and insurance. I am passionate about learning new skills and exploring cutting-edge technologies in the field of data. I have self-studied Hadoop and Spark frameworks and would like to work more on these and design and develop batch and real-time data pipelines. I am also interested in working on cloud-based ETL and data engineering services. I am a team player who can work effectively in agile and DevOps environments. I have received several appreciations and performance excellence rewards from my management and team for my work. I have also helped my team in resolving technical issues and automating day-to-day processes. I am looking for opportunities to work in a creative and challenging environment where I can constantly learn and successfully deliver solutions to problems using cutting-edge technologies.

Experience

1. Analyst - Development

   Sun Life

   Mar 2022 — Present · Gurugram, IN

   Contributing to multiple projects in an Agile and DevOps environment, some notable projects I have been involved in include: Data Movement Pod: Performed data ingestion from various sources to the Data Lake, ensuring proper cleansing and formatting using Informatica PowerCenter and IICS. Smart Assignment Project: Developed flows to ensure correct assignment of leads to agents using IICS. PDF Cluster Migration Project: Transferred PDF file names from GRS to FileNet using Informatica PowerCenter. Trident Project: Generated CSV files in non-masked and masked form for different users using Informatica PowerCenter. Project Script: Transitioned clients from TELUS to ESC (Express Scripts Canada) using Informatica PowerCenter. DLM (Data Life-Cycle Management) POC: Conducted testing and integration of a third-party application (Privitar) with IICS to meet specific use cases. Currently working on the US-IT Ingestion Project, performing data ingestion from various sources to the Data Lake using Qlik Data Catalyst, which is based on the Hadoop and Sqoop Framework.

Education

• Lovely Professional University

  Bachelor of Computer Applications, Cyber Security/Computer Forensics and Counterterrorism

  2016 — 2019

• Campus School,Pantnagar

  12, Science

  2014 — 2016