About

Ojas Bhatia is a highly skilled Data Engineer with over 11 years of relevant experience in the industry. Currently working at Amazon as a Data Engineer II, he has a proven track record of utilizing his expertise in Python and AWS S3 to develop ETL pipelines that source large amounts of structured and semi-structured data from APIs, databases, and CSV files into Snowflake, reducing cost by 45%. He has also used AWS Lambda to perform event-based data transformations and migrate from existing tool-based batch processing to kinesis-based real-time applications, reducing cost by 23%. Ojas has built a Migration Utility that enables the migration of ETL code from SQL server to Snowflake without manual intervention, reducing project timelines by 6 months. Additionally, he has designed a Star Schema using SCD Type-1, Type-2, and Type-4, and built an in-house reporting framework by combining HTML with Unix Shell Scripting, reducing cost by 25%. Ojas has a strong technical background and is proficient in programming languages such as Python, Unix Shell Scripting, PL/SQL, C++, C, HTML, CSS, and SnowSQL. He is also well-versed in Big Data and Machine Learning technologies like Spark, Python (Pandas, NumPy), and Cloud Technologies like AWS Lambda and AWS S3 Buckets. His experience with databases includes Snowflake, Oracle, Netezza, SQL Server, and DB2, and he has worked with Datawarehouse/ETL Tools like Informatica, SSIS, and Automation tools like Apache Airflow, Control-M, and Autosys. He is also proficient in Git, JIRA, Visual Studio, Confluence, and Jenkins. Ojas has previously worked at Mphasis and Infosys, holding the positions of Data Engineer and Informatica Technology Analyst, respectively. He holds a Bachelor's degree in Electronics and Communications Engineering from Guru Gobind Singh Indraprastha University, and completed his Senior Secondary Education from Modern Vidya Niketan, and Higher Secondary Education from St. Joseph's Convent School. Overall, Ojas Bhatia is a highly skilled and experienced Data Engineer with a strong technical background and a proven track record of delivering successful projects.