V

Venkata Ogirala

About

Detail

Pontiac, Michigan, United States

Timeline


work
Job
school
Education

Résumé


Jobs verified_user 0% verified
  • Capital One
    Data Engineer
    Capital One
    Feb 2024 - Current (2 years 9 months)
    Designed and developed scalable ETL pipelines using AWS Glue and Snowflake to streamline ingestion of complex financial datasets, significantly reducing processing time and improving data reliability across reporting teams. Collaborated with business analysts to define data contracts and SLAs.Architected a Delta Lake-based storage system in Azure Databricks that supports ACID transactions and schema enforcement. Integrated notebook workflows to manage curated data layers with rollback capabilities and partitioned version control.Implemented Kafka-based streaming ingestion from event hubs into PySpark, enabling Realtime analytics for fraud detection use cases. Designed checkpointing and offset recovery logic to ensure data durability and los
  • Sureify
    Data Engineer
    Sureify
    Mar 2021 - Jul 2023 (2 years 5 months)
    Designed dynamic ADF pipelines with parameterized datasets, supporting onboarding of new data sources with minimal development effort. Maintained a metadata-driven control framework for pipeline orchestration.Migrated reporting workloads from SQL Server to Snowflake for 20+ applications, enabling seamless scale-up during quarterly audits. Applied multi-cluster compute configuration to balance concurrent usage across business units.Implemented change data capture using Azure SQL Change Tracking, building incremental load logic and reconciliation jobs. Ensured referential integrity and state tracking with audit logs and stored procedures.Developed Informatica PowerCenter workflows to move data from on-prem ERP systems into cloud data lakes. B
  • TCS
    Data Engineer
    TCS
    Mar 2019 - Feb 2021 (2 years)
    Responsible for ingesting large volumes of user behavioral data and customer profile data to Analytics Data store.Working on Snowflake modeling using data warehousing techniques, data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment and change data capture.Done data migration from an RDBMS to a NoSQL database and gives the whole picture for data deployed in various data systems.Created T- SQL queries for data retrieval.Optimized queries tuned and monitored server performance.Monitored performance and optimized SQL queries for maximum efficiency.Created and modified Stored Procedures as per the business logic.Developed Scala based Spark applications for performing data cleansing, event enrichment, data aggregation, d
Education verified_user 0% verified
  • T
    Masters in Information Studies
    Trine University - Indiana
    Aug 2023 - May 2025 (1 year 10 months)
  • V
    Bachelors in EEE
    VNRVJIET - Hyderabad
    Aug 2016 - May 2020 (3 years 10 months)