Active

Rithika M

Data Engineer

On-site · Bengaluru

Projects

NYC Transit Data Platform

Built ELT pipeline ingesting 6.6M CitiBike trip records (1.2 GB) from PostgreSQL to BigQuery via Airbyte; deployed Cloud Run service polling live GBFS API every 2 minutes via Cloud Scheduler, writing to BigQuery. • Modelled star schema in dbt — incremental fact_trips (date-partitioned, clustered by station ID) and dim_stations SCD Type 2 snapshot across 2,511 stations.

Stack & AI tools

ETLELTLangChainGeminiClaudeRAGVector DBsMCPFastAPIPythonGCPData Build Tool(dbt)BigQuery

Contact via ResumeON