Roy

Data Engineer with 3+ years of experience architecting scalable data warehousing solutions, robust ELT/ETL pipelines, and medallion architectures using Snowflake, Google Cloud Platform (BigQuery), and PostgreSQL. Track record of processing millions of daily records, designing dimensional star-schema models across 300+ tables, and optimizing SQL transformations to reduce query latency by up to 35%.

Data Engineer at Nihilent Limited (2023-08 – Present)

• Architected end-to-end ELT/ETL pipelines ingesting millions of daily records from Workday, Lever, Glint, and C-Cure into a centralized warehouse, cutting ingestion lag by 40%.
• Engineered a Medallion architecture in Snowflake via 250+ Stored Procedures, Functions, Tasks, and Stages across 300+ tables.
• Implemented incremental and MERGE-based processing with SCD Type 1/2 and star-schema dimensional modeling.
• Developed 50+ procedures, views, and functions across BigQuery and PostgreSQL for UI filtering logic and backend consumption.
• Optimized 40+ complex SQL queries and procedures, reducing pipeline execution latency by 35% and saving cloud compute costs.
• Led monthly data quality audits and automated schema validation; mentored a junior engineer in SQL optimization.

Bachelor of Technology in Computer Science & Engineering – Techno India College of Technology (2019 – 2023)