About

Mayank Sardana is a highly skilled Data Engineer with over 6 years of experience in the field. He is currently working as a Lead Data Engineer at RedDoorz, where he is responsible for architecting scalable data pipelines using AWS/Snowflake and open source frameworks such as Airflow. Mayank is a data enthusiast who strives to work on building interesting data products that can create an impact on a larger scale. Mayank has extensive knowledge of Python, SQL and frameworks like dbt, flask-restful, pytest. He also has a good understanding of docker for containerizing applications. Mayank's past experience includes working as a Data Engineer II at Children's Hospital of Philadelphia, where he led efforts to modernize core data pipelines to migrate from Informatica to Apache Airflow. He designed and developed utilities to extract data from various source systems and created YAML driven templated DAGs and metadata-driven extract/load for batch jobs. Mayank also moved to automated metadata-driven table builds in the data warehouse instead of manual builds by admins. Mayank has a Master's degree in Information Science from the University of Pittsburgh and a Bachelor's degree in Electronics and Communication Engineering from the Indian Institute of Technology, Guwahati. He has a strong technical background and is proficient in Data Engineering, AWS, Apache Airflow, SQL, Docker, Flask, Data Warehouse, Snowflake, infra, Python, HDFS, Amazon Athena, Hadoop, DevOps, and ETL. Mayank is a proactive problem solver who is always looking for ways to improve processes and increase efficiency. He is a team player who enjoys collaborating with others to achieve common goals. Mayank's passion for data and his technical expertise make him a valuable asset to any organization.