Open to opportunities

Subashini Jothilingam

@subashinijothilingam

I’m a Senior Data Engineer specializing in Snowflake ETL/ELT, Airflow pipelines, and performance-optimized analytics platforms.

United States

Message

What I'm looking for

I’m looking for a team where I can own Snowflake-based ELT pipelines end to end—using Airflow, dbt, and automation—while partnering with analytics to deliver fast, secure, high-quality data with measurable performance improvements.

I’m a Data Engineer with 10+ years of IT experience, including 5 years in Snowflake and Teradata. I build scalable ETL pipelines, data integration solutions, and performance-tuned warehouses that help teams move faster with reliable data.

In Snowflake, I’ve designed and managed cloud data warehouses and dimensional models (fact/dimension tables) with SCD Type 1/2/3 handling. I also implement Time Travel, Zero-Copy Cloning, Snowpipe + external stages on AWS S3 for event-driven ingestion, and strong security with Snowflake RBAC, row-level security, and data masking policies.

On the automation and orchestration side, I create end-to-end ELT workflows using Apache Airflow, transforming semi-structured data with Python (Pandas, PySpark) and JSON parsing to reduce manual intervention. I maintain dbt models on Snowflake (incremental and full-refresh strategies), and I add data quality checks and reconciliation frameworks using SQL validations and audit tables.

I bring hands-on full-stack depth too—building scalable single-page applications with React/Next.js and RESTful APIs using Node.js/Express.js and PHP, integrating MySQL, PostgreSQL, and MongoDB. Whether it’s migrating from Teradata to Snowflake (reducing infrastructure cost by 35%) or optimizing SQL workloads (up to 40% improvements), I focus on measurable outcomes, collaboration with analytics/business teams, and engineering productivity.

Experience

Work history, roles, and key accomplishments

Current

Data Engineer

Current

50CYCLES

Jul 2021 - Present (4 years 10 months)

Built and deployed end-to-end ELT pipelines with Apache Airflow, improving pipeline efficiency and reducing manual intervention. Migrated from Teradata to Snowflake, cutting infrastructure cost by 35% and improving query runtime by 30%, and optimized SQL workloads to reduce execution time by up to 30–40%.

Snowflake Teradata SQL Python Apache Airflow DBT Pyspark Snowpipe AWS S3

Full Stack Engineer

Nottinghamshire County Cricket Club

May 2019 - Jun 2021 (2 years 1 month)

Developed internal web applications for reporting, admin tools, sales backlog, and booking workflows using React/Redux and Node.js/Express with MongoDB. Implemented drill-down reports and REST APIs to deliver structured data endpoints, integrating with Teradata for analytics.

React Redux MongoDB REST APIs Swagger Python Teradata Agile

Full Stack Developer

Barclays Bank

May 2016 - May 2019 (3 years)

Developed and maintained web applications using PHP, MySQL, jQuery, and Linux, and implemented RESTful APIs for third-party integrations. Built scalable e-commerce and CMS solutions with Yii2/CodeIgniter and reduced content update time by 50%, integrating PayPal and Stripe for payments.

PHP MySQL jQuery Linux Apache REST APIs CodeIgniter Drupal Stripe

Lead Developer

Robin Sharma

Aug 2013 - Apr 2016 (2 years 8 months)

Led a team of 5 developers building dynamic LAMP-stack web applications, including an e-commerce platform with authentication, catalog, cart, and payment integration. Developed a custom CMS and multi-user blog with third-party API integrations such as Google Maps for geolocation and interactive maps.