Principal Data Engineer

Rajeev Jasti

Data Engineering DBA Backend Cloud

Hands-on Data Engineer with 8+ years of experience architecting distributed high-throughput microservices, enterprise OLAP/OLTP databases and Middleware systems. Deep domain expertise in supply chain intelligence (ERP, WMS, TMS), with a proven track record of transforming multi-source operational data into unified, scalable Datawarehouse. Deep technical expertise in database administration and optimizing execution plans, storage, logs, backup strategies, and transaction workloads across SQL Server, PostgreSQL and Redshift.

8+
Years Experience
50+
Projects Delivered
1M+
Events/Second
30%
Cost Reduction
40%
Latency Improvement
99.9%
Uptime

Technical Skills

Experience

Track record of architecting scalable data platforms, enterprise OLTP/OLAP systems, full-stack web applications, and generative AI solutions.

Feb 2018 — Present Salt Lake City, UT • Remote

Nicholas and Company

Principal Data Engineer (Nov 2022 — Present)
Data Engineer (Feb 2018 — Oct 2022)
  • Enterprise Data Engineering & Modeling (OLAP): Accelerated analytics delivery and unified fragmented operational reporting across ERP, WMS, and TMS domains into a centralized Amazon Redshift data warehouse, substantially reducing query latency and pipeline SLA delivery times, by architecting high-throughput batch/streaming pipelines, designing dimensional Star/Snowflake schemas, and establishing a governed Looker semantic modeling layer.
  • Backend, Middleware & Telemetry: Scaled enterprise event telemetry ingestion and distributed middleware integrations across heterogeneous systems, sustaining high-volume event throughput with low-latency API response times and zero data loss, by engineering non-blocking Python/FastAPI REST APIs with asyncpg connection pooling, building AWS Lambda & Boomi iPaaS integration layers, and designing relational event stores with structured telemetry schemas.
  • Database Systems (OLTP): Eliminated pricing discrepancies and accelerated transactional calculation throughput for mission-critical pricing and rebate engines, significantly cutting batch calculation runtimes while guaranteeing strict ACID compliance under heavy transactional concurrency, by designing optimized relational schemas, implementing robust stored procedures/triggers, managing pessimistic/optimistic concurrency control, and automating declarative schema migrations with Alembic.
  • Database Administration & Reliability (OLTP & OLAP): Maintained high-availability database operations and optimized query efficiency across hybrid multi-database clusters (PostgreSQL, SQL Server, Amazon Redshift, Aurora), significantly reducing P95 query execution latency and eliminating system deadlocks, by implementing multi-AZ failover and automated disaster recovery, structuring indexing/vacuum maintenance routines, and performing execution plan profiling with fine-grained lock tuning.
  • Cloud Architecture & Modernization: Modernized legacy on-premises infrastructure into an elastic, event-driven AWS cloud platform, reducing infrastructure overhead and completing migrations with zero cutover downtime across enterprise-scale data assets, by architecting cloud topologies leveraging Amazon Redshift, AWS Glue ETL, Lambda, Athena, S3 data lake tiers, DynamoDB, RDS Aurora, and containerized ECS workloads.
  • DevOps, Quality & Infrastructure: Accelerated release velocity and reinforced production reliability across distributed message-driven services, dramatically shortening deployment cycle times while achieving high test coverage and zero regression escapes, by orchestrating containerized workloads on Docker/EKS/ECS, provisioning Kafka and RabbitMQ event brokers on Linux, and establishing GitHub Actions CI/CD pipelines with automated Pytest, Node.js/JSDOM, ESLint, and Stylelint quality gates.
  • Full-Stack & Generative AI Web Applications: Delivered responsive Progressive Web Apps (PWAs) with interactive 3D visualizations and conversational AI capabilities, achieving ultra-low time-to-first-token (TTFT) streaming latency and high platform availability, by engineering asynchronous FastAPI microservices, streaming Amazon Bedrock LLM inference over Server-Sent Events/WebSockets, rendering Three.js GPU-accelerated graphics, and developing zero-dependency ES module frontends.
Amazon Redshift Amazon Bedrock Amazon S3 AWS Glue AWS Lambda Amazon Athena DynamoDB API Gateway CloudWatch Amazon EKS Amazon ECS EC2 RDS IAM SNS SQS Glacier FastAPI boto3 SQLAlchemy Pydantic Multiprocessing Multithreading Matillion PySpark Looker Pandas NumPy PostgreSQL SQL Server MySQL Dell Boomi Redis Apache Kafka RabbitMQ Elasticsearch Alembic Python T-SQL PL/pgSQL SQL Bash / Linux Git Docker Terraform Kubernetes GitHub Actions CI/CD Pytest

Projects

Selected platform work focused on reliability, observability, and reusable delivery patterns.

Real-time Analytics Platform

Kafka and Spark streaming pipeline processing 1M events per second with fault-tolerant event ingestion.

Cloud ETL Modernization

Airflow-orchestrated Snowflake pipelines that reduced nightly batch runtime by 45%.

CDC Data Mesh Enablement

Built Kafka-to-Snowflake CDC templates for domain teams to self-serve compliant datasets.

Interests & Hobbies

What I do when I'm not building data pipelines — four habits that keep the other twelve hours honest.

Soccer & Tennis

Avid soccer fan who follows matches closely on weekends, and an active tennis player who loves hitting the court for rallies and competitive sets.

  • Soccer
  • Tennis
  • Weekends

The Daily Detox

Nothing beats a 20-minute sauna session after a long day of engineering. It is my reset button for recovery and deep thinking.

  • Sauna
  • 20 minutes
  • Recovery

Strength & Conditioning

Lifting heavy and staying mobile. Consistency in the gym translates directly to discipline and focus at the keyboard.

  • Strength
  • Mobility
  • Consistency

Culinary Explorer

Always on the hunt for the best local eats, from hidden street food gems to trying my hand at cooking new cuisines at home.

  • Street food
  • Home cooking
  • Local finds

Session Activity

Everything this site has recorded about your visit, as it happens. It stays with your session — no accounts, no third-party trackers, nothing that follows you off the page.

Connecting…
Browser Kafka API Postgres ms
0 Events recorded
Time on site
0 Sections visited

Your visit, minute by minute

Select a bar to narrow the log
startnow
  • Navigation
  • Interaction
  • Preference
  • Contact

Where you went

No navigation recorded yet.

    Let's talk.

    Have a project in mind or want to connect? Pick whichever way is easiest — email, a social link, or the form on the right.

    Not sure how to start? Pick a topic and I'll open the message for you.

    Send a message

    Three fields, about a minute.

    0 / 1200

    Goes straight to my inbox. No list, no newsletter, no third party.