Skip to content

Lingamurthy Pokathota

Forward Deployed Engineer | Data & AI Platforms • Cary, NC • k******@outlook.com • 919****919 • linkedin/••••• • drivetube.ai/•••••

Professional Summary

Forward Deployed Engineer with 15+ years of experience designing, building, and operating data and AI platforms for utilities, financial services, and public-sector clients. Strongly focused on Snowflake-based data platforms, Snowpark Python, and end-to-end GenAI systems using LangChain, Bedrock (Claude), and Cortex AI. Experienced building production RAG pipelines, streaming LLM responses with WebSocket-based UX, and embedding agents that deliver Text-to-SQL and document summarization workflows. Hands-on ownership across architecture, backend APIs (FastAPI/Python), infrastructure as code (CDK), CI/CD (Jenkins → CodeBuild), monitoring, and on-call support. Delivered high-impact results: multi-bot platforms with 500+ daily users, real-time operational dashboards, and governance controls that caught $2M in misreported generation data. Seeking roles that combine applied GenAI, Snowflake platform engineering, and customer-facing delivery.

Technical Skills

Programming Language: Python,SQL
Frontend Technologies: React,Tailwind CSS,Vite
Backend Technologies: FastAPI
Databases: Snowflake,Stored Procedures
Cloud Platforms: Amazon Web Services,Lambda,SNS,CodeBuild,CDK,PL,Cortex
DevOps & Infrastructure: Jenkins
API & Integrations: API Gateway
Data Engineering & Processing: Snowpark
Data Analysis & Visualization: Dynamic Tables,DMS
Generative AI & LLMs: LangChain,Bedrock,LLM,RAG
Data Integration & ETL: Informatica PowerCenter,Data Validation
Infrastructure Security: Data Masking,RBAC

Work Experience

Portland General Electric
Portland, OR
Forward Deployed AI & Data Platform Engineer
Oct 2022 – Present
Built and ran GenAI and Snowflake data platforms for an electric utility, delivering RAG-based bots, streaming LLM UX, and operational analytics used by business and ops teams.
Tech Stack: LangChain, Bedrock, FastAPI, Python, WebSocket, SNS, Lambda, API Gateway, Snowflake, Snowpark Python, Cortex AI, Jenkins, CodeBuild, CDK
  • Architected a multi-bot GenAI platform using LangChain and Bedrock to deliver 10 specialized AI bots; designed modular retrieval, prompt templates, and response handlers to enable rapid bot addition.
  • Implemented a streaming LLM pipeline (WebSocket → SNS → Lambda → Bedrock → PostToConnection) to bypass API Gateway timeouts and stream tokens to users as they generate.
  • Deployed Cortex AI inside Snowflake to run LLM Functions for document summarization and classification; integrated Cortex Search and Cortex Analyst to remove a custom embedding pipeline and save ~60% of manual reporting effort (percentage).
  • Built the backend APIs and bot runtimes with FastAPI and Python, and onboarded 500+ daily users to GenAI features through WebSocket streaming (scale).
  • Constructed the Snowflake platform architecture including data vault modeling, dynamic tables, streams/tasks for CDC, and Snowpark Python UDFs to push ML scoring into Snowflake; migrated 50+ data assets to the platform (count).
  • Authored a three-way comparison engine (Snowflake vs Oracle vs PI Historian) that runs daily to validate generation data and automated stakeholder alerts; discovered and corrected $2M in misreported generation data (money).
  • Automated CI/CD with Jenkins pipelines feeding AWS CodeBuild and CDK deployments; implemented auto-backout branches to reduce deployment recovery time.
  • Monitored pipeline health with scheduled Python validation scripts and alerting; maintained on-call ownership for data freshness, ETL failures, and GenAI service reliability.
Deloitte - Virginia State
Virginia
Senior Data Engineer (Embedded with Client)
Jan 2021 – Jul 2022
Embedded with state agencies to migrate on-prem data to cloud platforms and deliver reusable migration frameworks and data quality controls.
Tech Stack: Oracle, PL, SQL
  • Led a migration of large datasets from Oracle to cloud-hosted systems, processing multi-million record extracts and full audit trails for state agency integrations (scale).
  • Reduced average migration duration by refactoring processes and templates, bringing follow-on agency migrations down from ~3 months to ~5 weeks (time/duration).
  • Built a reusable migration framework and orchestration patterns that standardized data validation, error handling, and recovery across agencies.
  • Implemented a data quality scoring engine that flagged ~15K integrity issues prior to production cutover and prevented downstream data breaks (count).
  • Designed transformation and mapping rules in Informatica and PL/SQL to enforce SCD Type 1/2 logic and ensure zero data loss during cutover.
  • Partnered with client stakeholders on acceptance criteria, audit trails, and rollback procedures to satisfy state compliance requirements.
Salesforce
Remote
Snowflake Architect / Cloud Data Engineer
Aug 2020 – Jan 2021
Replatformed on-prem data workflows to AWS + Snowflake to reduce cost and simplify orchestration for internal analytics teams.
Tech Stack: Snowflake, Snowpark Python, Informatica PowerCenter, Python, CDK, Jenkins, DMS
  • Rebuilt 30+ Informatica PowerCenter jobs as Snowflake-native ELT, replacing heavy on-prem compute and achieving a 35% infrastructure cost reduction (percentage).
  • Refactored orchestration into Python-driven Snowflake Tasks and modular session scripts to simplify maintenance and improve reliability.
  • Migrated data movement to Snowflake using a combination of staged loads and DMS for continuous replication where required (count).
  • Implemented Snowpark Python UDFs and stored procedures to centralize transformation logic and reduce downstream data movement.
  • Automated environment provisioning and schema deployments with CDK and Jenkins pipelines to speed up team onboarding.
  • Validated data quality and lineage during migration with reconciliation reports and targeted sampling to ensure parity with on-prem results.
Wells Fargo
Senior Snowflake Engineer
Jul 2019 – Jul 2020
Built Snowflake provisioning, governance, and migration features for a financial-services environment to support analytics teams and regulatory controls.
Tech Stack: Snowflake, RBAC, Dynamic data masking
  • Migrated Informatica workloads to Snowflake-native ELT patterns, reducing reliance on legacy on-prem tooling and simplifying pipelines.
  • Automated data infrastructure provisioning (schemas, warehouses, roles, grants) with scripts to remove manual ticket waits and accelerate onboarding.
  • Implemented RBAC, dynamic data masking, and column-level security to meet financial compliance and protect sensitive data.
  • Designed and enforced encryption-at-rest and key management practices as part of the governance layer.
  • Worked directly with 10+ analytics teams to enable self-service access and trained teams on Snowpark and task-based orchestration (count).
  • Authored runbooks and operational playbooks for incident response and data recovery for Snowflake-based workloads.
Fidelity Investments
Senior Data Engineer / Tech Lead
Jun 2016 – Jul 2019
Led architecture and operations for large-scale Informatica-based ETL supporting wealth-management analytics and reporting.
Tech Stack: ETL, Performance tuning
  • Led a 5-person team maintaining 100+ Informatica mappings that processed ~50M records per day for wealth-management reporting (count / scale).
  • Architected reusable templates and pushdown optimization patterns in Informatica to accelerate development and improve throughput.
  • Directed SCD Type 2 implementations and complex incremental load patterns to preserve historical accuracy in reporting marts.
  • Conducted code reviews, capacity planning, and performance tuning for ETL processes to maintain nightly SLA targets.
  • Coordinated cross-functional debugging and root-cause analysis for high-severity pipeline failures and restored services under SLA.
  • Mentored junior engineers on data modeling, ETL best practices, and production support processes.

Education

Sri Venkateswara University
MCA

Certifications

SnowPro Core
AWS Certified Solutions Architect – Associate — Amazon Web Services
Azure Data Engineer — Microsoft
GenAI Cert
Six Sigma Yellow Belt

Powered by Drivetube · Create your own profile at drivetube.ai

Explore Drivetube

  • Drivetube Profile — your free digital resume — at drivetube.ai/in/your-name: one true standard resume with a Hiring Snapshot (visa status, expected salary, notice period, work preference, relocation), an ATS-ready PDF download and a single shareable link. Free forever; interview requests come from verified employers and your contact details stay masked until you accept. Documentation.
  • Free Job Board — verified openings crawled ATS-by-ATS from 100,000+ real company career pages across 35 ATS platforms. Shows the true posting date from the source ATS — not when a listing was indexed — and deletes every general listing 3 days after it was actually posted. No ghost jobs, no ad-sponsored listings, no staffing reposts, no account needed. Documentation.
  • Job Hunt Program — managed job hunting, a one-time purchase from $199.99. JobScout matches verified roles to your real experience band, Blend AI writes a uniquely tailored resume and cover letter for every application, and the Autofill extension fills the form — or Let Us Apply submits it for you. Documentation.
  • Resume Writing Services — human-written, ATS-optimised resumes by senior career writers, from ₹499.99 / $25.99. Available in every country, written to the destination country's own standard — a US resume, UK CV, German Lebenslauf and Indian resume are genuinely different documents. A paid service, separate from the free Drivetube Profile. Documentation.
  • Community Membership — from $4.99/month (₹1,999/year in India). Unlocks the gated job-board filters — visa sponsorship, security clearance, workplace and application time — plus Job-Scout AI matching, Resume Report AI, Interview AI prep sheets, Recruiter Outreach AI sent from your own Gmail, Apply or Skip triage, a daily market feed and a $10,000+ library including 23 ATS-validated resume templates. Documentation.
  • Drivetube Hire — for employers — hiring with no job postings and no applications. Paste your real job description and AI matches it against candidates' true standard resumes, returning ranked candidates with a match %, matched and missing skills and written reasoning. Free tier included; employers pay, candidates never do. Documentation.

Full product documentation — every product explained, with feature-by-feature comparisons against the job boards, AI apply tools, resume services and hiring platforms people actually use.

The job board covers the United States, India, United Kingdom, Canada, Europe and Australia, and Resume Writing Services are available in every country.