Vivek Pratap Singh
About Vivek Pratap Singh
Vivek Pratap Singh is a Data Engineer with expertise in developing and automating data transfer processes using Python and Informatica PowerCenter. He has a strong foundation in cloud technologies and extensive experience in data warehousing and business intelligence.
Work at Advance Auto Parts
Currently, Vivek Pratap Singh serves as a Data Engineer at Advance Auto Parts, a position he has held since 2020. In this role, he focuses on developing and automating data transfer processes, leveraging his expertise in Python scripting. His responsibilities include utilizing UNIX shell scripting for data warehousing tasks and automation, contributing to the efficiency and effectiveness of data management within the organization.
Previous Experience at GGK Tech
Before joining Advance Auto Parts, Vivek worked at GGK Tech as a Software Engineer from 2017 to 2020. During his three years in this role, he gained valuable experience in data engineering and software development. His work involved utilizing various technologies to enhance data integration and processing capabilities.
Education and Expertise
Vivek Pratap Singh has a solid educational background in computer science and engineering. He earned his Bachelor of Technology (BTech) degree from the National Institute of Technology Delhi, where he studied from 2012 to 2016. Prior to that, he completed his high school education at Jawahar Navodaya Vidyalaya from 2004 to 2009 and studied Mathematics and Computer Science at Nalanda Academy from 2009 to 2011. His academic foundation supports his expertise in data engineering, cloud technologies, and data integration.
Technical Skills and Proficiencies
Vivek possesses a range of technical skills that enhance his capabilities as a Data Engineer. He is proficient in developing complex SQL queries and PL/SQL procedures for relational databases, including Oracle, Exadata, and SQL Server. He has experience with Informatica PowerCenter for data integration and ETL processes. Additionally, he has a strong foundation in cloud technologies, specifically Snowflake and AWS services such as S3, data pipeline, and Lambda.
Dimensional Modeling and Business Intelligence
Vivek has a strong skill set in dimensional modeling, including the use of star and snowflake schemas. He is knowledgeable about slowly changing dimensions, which are crucial for maintaining historical data in data warehousing. His expertise extends to business intelligence and analytics, focusing on delivering transformational outcomes through data storytelling and analysis.