Mohit Patil

Data Engineer Intern

Symphony•  June 2022 - August 2022

● Extracted data for 250+ fields involving up to 30 ETL components to transform and store the data in OLAP databases. ● Developed and modified ETL pipelines for healthcare vendors like Walmart, CVS, and Walgreens using mapping documents. ● Tools: Informatica PowerCenter, Informatica Big Data Edition, Hadoop, Oracle, SQL, Hive.

Graduate Services Assistant

Arizona State University•  October 2021 - May 2022

● Restructured 250+ test cases in Angr (python library for analyzing binaries) using Python 3, Git, Docker, and WSL to reduce the runtime by 60% thus improving efficiency, compatibility, maintainability & readability of legacy code.

Data Engineer

accenture•  September 2019 - July 2021

● Designed Extract Transform Load (ETL) jobs, warehouse schema, and data models consisting of databases like Oracle, AWS Redshift, Apache Cassandra, and PostgreSQL including end-to-end implementation, unit & integration testing. ● Worked on data transformation in data warehouse and data marts using ETL tools for more than 5 million users. ● Built recommendation engine using Machine Learning with customer-centric experience increasing sales by 5%. ● Maintained the AWS S3 and global data lake buckets to store customer data for different regions globally. ● Scrutinized the data in ETL data pipelines via SQL/NoSQL for defect tracking, rendering data insights & data analytics.