Kunwarraj Meena

Data Engineer @Air India Limited

Gurugram, IN

Design, develop, and manage ETL/ELT pipelines using Snowflake, DBT, and Matillion.Work closely with Data Analysts, Scientists, and BI teams to understand data needs and deliver high-quality datasetsManage and optimize Snowflake warehouses, schemas, roles, and permissions.Implement Snowflake features such as Time Travel, Cloning, Streams, and Tasks.Proficient in GitHub for version control, collaborative development, and CI/CD automation of data pipelines.”Experienced in managing DBT, Snowflake, on GitHub with code reviews, branching, and deployment workflows.Migrated 3 TB of historical airline booking and flight operations data from MySQL Server into Snowflake using Matillion ETL. Implemented incremental CDC pipelines to load 200 GB of daily reservation and flight activity data into a structured data warehouse.Designed an ELT pipeline in Matillion to migrate 2 TB of airline customer & loyalty data from Oracle to Snowflake, applying SCD2 logic to maintain historical flight and loyalty transactions.Optimised airline data warehouse migration (4 TB) by partitioning fact tables (bookings, flights, crew schedules) and orchestrating data pipelines in Matillion with CDC + orchestration jobs.