Pranjal Prerak Mishra

About Pranjal Prerak Mishra

Dedicated Data Engineer with 3.5 years of experience in designing, developing, and optimizing data pipelines on Google Cloud Platform (GCP). Skilled in Python, SQL, and GCP tools like BigQuery, Cloud Functions, Cloud Storage, and Composer. An enthusiastic team player who goes the extra mile to meet deadlines and collaborate effectively with cross-functional teams to deliver scalable and reliable data solutions.

Experience

1. Lead Software Engineer

   Persistent Systems

   Mar 2026 — Present · Kolkata, IN

   Designed and developed data pipelines utilizing Apache Airflow (Composer) to automate data ingestion, transformation, and loading (ETL) processes for BigQuery(data warehouse), ensuring scalability• Developed dynamic stored procedures to facilitate automated data ingestion across multiple tables.• Experienced in developing and optimizing SQL queries using views, common table expressions (CTEs), and stored procedures.• Analyzed data marts containing 15 gigabytes of data using SQL queries, extracting valuable insights for business stakeholders.• Possess hands-on experience in Pyspark for data processing and analysis.• Designed and developed ETL process/business logic in Informatica to load Oracle tables and used INFA features to implement mapping like SCD type 1 and type 2.• Designed and developed SSIS packages to generate reports based on the business requirement.

Education

• GOVERNMENT ENGINEERING COLLEGE, DUMKA

  Bachelor's degree, Computer Science

  2018 — 2022