Summary
Overview
Work History
Education
Skills
Timeline
Generic

Sachit Khanna

Mesa,AZ

Summary

Seasoned Software Engineer bringing experience, ideas and lessons learnt from progressive contributions to projects spanning backend microservice implementation, data warehouse modeling and data pipeline orchestration.

Overview

10
10
years of professional experience

Work History

Staff Software Engineer

SailPoint Technologies
07.2022 - Current
  • Lead a team of 5 engineers, in executing the quarterly roadmap for our in-house data platform that serves domain teams across many functions.
  • Architected a Python framework for templating Airflow DAGs and Tasks, empowering 30+ teams to self-serve production-ready data pipelines.
  • Implemented containerized data-connectors to extract & load records from diverse sources into the unified datalake (S3) and data warehouse (Snowflake), as well as to reverse ELT records back into the sources.
  • Developed a DBT package to encapsulate and enforce reuse of standardized filter and transform operations for incremental data model transitions on Snowflake.

Senior Software Engineer

SailPoint Technologies
10.2018 - 07.2022
  • Redesigned and migrated data pipelines from a costly per-tenant ETL paradigm to an efficient multi-tenant ELT approach, significantly reducing operational overhead and enhancing scalability.
  • Leveraging the Apache Flink framework, implemented several Flink Jobs for streaming records from Kafka, while emitting aggregates and joins to destinations spanning Kafka, S3, PostgreSQL and Snowflake.
  • Self-identified problems and tech-debt to drive solutions and new features towards an enterprise grade data-mesh.
  • Refactored an existing Spring-based data-extraction microservice to usher in significant improvements in data consistency, completeness and throughput.

Technical Lead

HCL America
12.2016 - 09.2018
  • Worked closely with solution architect in leading migration of over 200 existing data aggregation backend services from ODSI (Oracle SOA) based implementation to open-source micro-services implementation developed using Sprint Boot.
  • Instrumented logging and caching aspects for the application leveraging Spring Aspect-Oriented programming.
  • Reduced operational expense by single-handedly developing the integration test module allowing easy and exhaustive validation of 200 microservices migrated.
  • Implemented software stubs, such as Spring JDBC clients, SOAP clients and XML over HTTP clients, for fetching data from downstream components.

Programmer Analyst

Strategic Resources International Inc
11.2014 - 11.2016
  • Leveraged Java, Gradle and Sprint Boot in implementing RESTful modules and data access service layers, that exposed search, pagination, filtration and analytic operations on a proprietary datamart application servicing the legal industry.
  • Developed stored procedures and scheduled jobs in PL/SQL to enhance the ETL pipeline from warehouse to datamart.

Education

MBA -

Boston College
Chestnut Hill, MA
05.2014

Bachelor of Engineering - Computer Engineering

Thapar University
Patiala, India
08.2008

Skills

    Programming Languages: Java Python SQL

    Distributed Data Processing Frameworks: Apache Kafka Apache Flink

    Workflow Orchestration: Apache Airflow

    Cloud Computing: Amazon Web Services

    Data Storage & Warehousing: Snowflake S3 MySQL MS SQL Server PostgreSQL DynamoDB Redis

    Microservices Implementation: Spring Boot Gradle Docker Kubernetes

Timeline

Staff Software Engineer

SailPoint Technologies
07.2022 - Current

Senior Software Engineer

SailPoint Technologies
10.2018 - 07.2022

Technical Lead

HCL America
12.2016 - 09.2018

Programmer Analyst

Strategic Resources International Inc
11.2014 - 11.2016

MBA -

Boston College

Bachelor of Engineering - Computer Engineering

Thapar University
Sachit Khanna