Looking for a job

OMKAR MOHAPATRA

@omkarmohapatra

Data Engineer who developed a Databricks travel booking warehouse with SCD Type 2 customer history and daily revenue analytics.

India

Message

I developed an end-to-end travel booking data warehouse on Databricks, processing daily customer and booking data through parameterized ETL pipelines using PySpark, SQL, and Delta Lake.

I implemented incremental ingestion and a Customer Dimension with SCD Type 2 history, then developed a daily Booking Fact table with revenue and booking metrics.

I added PyDeequ data quality checks, optimized Delta Lake tables, and orchestrated ETL workflows. I also created SQL analytics for daily revenue and Customer 360 reporting.

Experience

Work history, roles, and key accomplishments

Associate Data Engineer

PENTAGRAM INFOTECH PRIVATE LIMITED

Aug 2023 - Sep 2026 (3 years 1 month)

Data Engineer with 3 years of experience designing, automating, and optimizing scalable data pipelines and backend architectures. Proficient in Python, PySpark, SQL, dbt, Snowflake, and Apache Cassandra, with a proven track record of transforming high-volume raw data into reliable, production-ready analytics models.

Data Engineer

Enterprise FinTech

Designed and developed an end-to-end Data Warehouse on Databricks using PySpark, SQL, and Delta Lake, processing daily customer and booking data through parameterized ETL pipelines. Implemented Bronze-layer incremental ingestion, SCD Type 2 dimensions, and PyDeequ data quality checks.

Databricks PySpark Delta Lake SQL Unity Catalog PyDeequ Databricks Volumes Databricks Workflows ETL Data Warehouse SCD2 Data Quality

Education

Degrees, certifications, and relevant coursework

Dhenkanal Autonomous College

Master of Science, Computer Science

2021 - 2023

Grade: 8.33/10

Pursued a Master's degree in Computer Science from Dhenkanal Autonomous College, Dhenkanal, Odisha, from October 2021 to August 2023, achieving a CGPA of 8.33/10.