Shivansh Khatri is a DWH/BI Test Engineer with experience in data engineering and testing. He is proficient in technologies like Python, Spark, Snowflake, and Teradata. His expertise includes developing product recommendation systems, automating workflows, and establishing CI/CD pipelines using Jenkins.
Experience
DWH/BI Test Engineer
Amdocs
Developed a product recommendation system that suggests personalized products to users based on their preferences. Integrated the system with external APIs to enable communication with other systems and applications. Developed a tool to compare large volumes of data between on-premises servers (Teradata) and cloud platforms (Snowflake), and utilized the Matplotlib Python library to visualize the data in a clear and organized manner. Proficient in handling semi-structured data formats such as JSON and XML, utilizing Snowflake's VARIANT attribute to effectively manage and manipulate the data. Designed and executed comprehensive test plans, cases, and scripts to validate and ensure data accuracy and quality. Automated workflows using Python programming and Shell scripting to streamline the delivery of data solutions. Proficient in working with Massively Parallel Processing Analytical Datastores, including Teradata and Snowflake, to extract, transform, and load data using SQL and other data manipulation tools. Leveraged Jenkins to establish Continuous Integration and Continuous Development pipelines to improve the efficiency and reliability of the data delivery process.
Education
Shiv Nadar University
Bachelor of Technology
Electronics and Communication Engineering
Minor: Computer Science Engineering.