Pranjal Prajapati

Data Engineer · Python, SQL, PySpark, Delta Lake

Azamgarh, Uttar Pradesh, India

@pranjal_prajapati

LinkedIn GitHub

0 followers

🎓 Bachelor of Computer Applications (BCA) at Maharaja Suhel Dev State University (MSDU) · Graduating 2027

About

Data Engineer with hands-on experience building Medallion-architecture and lakehouse pipelines using Python, SQL, PySpark, Delta Lake, and AWS S3. Strong project focus on data quality, incremental ingestion, MERGE upserts, orchestration, and dimensional modeling.

Education

2027

Bachelor of Computer Applications (BCA)

Maharaja Suhel Dev State University (MSDU)

Computer Applications · Jul 2024 – Jun 2027

Computer Applications · Jul 2024 – Jun 2027

Skills

<3 months

C SQL ETL NumPy Python Pandas PySpark Delta Lake Monitoring Star Schema Aggregation Data Lineage Deduplication Data validation Window functions Dimensional Modeling Transaction Management Medallion Architecture

Tools / apps / platforms

<3 months

Git MySQL AWS S3 DuckDB GitHub VS Code Databricks GitHub Actions Jupyter Notebook

Projects

Pizza Sales SQL Analysis

SQL, MySQL, Relational Modeling, Analytical SQL

Modeled 21,350 orders in MySQL and used analytical SQL to calculate revenue, category contributions, top-selling pizzas, and hourly order distributions.
FMCG Databricks Lakehouse Pipeline

Databricks, PySpark, AWS S3, Delta Lake, SQL

Built full-load and incremental notebooks to consolidate subsidiary customer, product, pricing, and order data into a parent-company dimensional model through Bronze, Silver, and Gold layers. Used Delta Lake MERGE, Change Data Feed, and parameterized notebooks to align daily subsidiary orders with monthly parent-company facts.
Chicago Crimes Data Pipeline

Python, SQL, MotherDuck, GitHub Actions

Built a Bronze-Silver-Gold pipeline for 1.57M+ unique crime records, using paginated Socrata API extraction, a 24-hour watermark overlap, exponential-backoff retries, staging deduplication, and ID-based MERGE operations. Rebuilt Silver and Gold layers inside a transaction with rollback on failure, and scheduled daily execution with GitHub Actions.

Courses & certifications

SQL for Data Science · Simplilearn
SQL (Advanced) · HackerRank

Explore the Broxer community

💬 Q&A Ask about roles, salaries and interviews — and help others. 👥 Circles Join discussions on skills, companies and industries. 📰 Feed Follow updates and insights from the community.