Summary
Overview
Work History
Education
Skills
Timeline
Generic

Saiteja Shiramdasu

Data Engineer
Atlanta,GA

Summary

Experienced in designing and optimizing data pipelines for seamless data flow, leveraging advanced SQL and Python skills to create and maintain robust data architectures. Proven track record of implementing scalable solutions that enhance data integrity and support informed decision-making. Proficient in ETL tools such as Apache NiFi and DataStage, with hands-on experience across Azure, Snowflake, and GCP platforms. Skilled in data warehousing, pipeline orchestration (Airflow), and automation, significantly reducing manual processes by over 90%. Strong focus on data quality, governance, and operational excellence drives my approach to data management.

Overview

6
6
years of professional experience

Work History

Data Engineer

Elevance Health
07.2024 - Current


  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • Architected HIPAA-compliant data lake architecture on AWS to consolidate multi-source health data, enabling 360-degree patient analytics, and reducing data silos by 60%.
  • Implemented Kafka-Snowflake streaming workflows, triggering clinical alerts within 30 seconds of detecting anomalies.
  • Automated ingestion and transformation of HL7 and FHIR datasets, reducing manual efforts by 80%, and enhancing system interoperability.
  • Optimized SQL queries for performance, resulting in a 25% speed boost.
  • Unified diverse data sources (APIs, RDBMS, flat files) into integrated pipelines, accelerating data synchronization by 50%.
  • Automated Amazon S3 to Snowflake data ingestion using external stages and DevOps, cutting manual effort by 70%.
  • Performed data profiling to ensure data quality, detected anomalies, and implemented management controls for consistency.
  • Orchestrated parameterized Glue pipelines across environments, decreasing code duplication by 40%.
  • Migrated legacy ETL pipelines to modern, cloud-native solutions on Snowflake, reducing operational costs by 30%, while enhancing data governance.
  • Executed end-to-end performance testing on ETL pipelines, pinpointing and eliminating inefficiencies, which boosted system throughput by 25%.
  • Engineered real-time ingestion pipelines using Kafka Connect, and orchestrated workflows with Apache Airflow, improving scheduling efficiency by 70%, and supporting end-to-end data product delivery.
  • Established and managed automated CI/CD pipelines, diminishing deployment duration by 25%.
  • Fine-tuned Apache NiFi workflows and Snowflake SQL performance significantly enhance throughput and reduce overall processing delays.
  • Created anonymization and tokenization workflows to ensure PHI compliance, facilitating secure data sharing across research teams, without violating privacy standards.
  • Optimized data processing by implementing efficient ETL pipelines and streamlining database design.
  • Worked closely with the product and analytics teams to design KPIs and data marts, accelerating business reporting turnaround by 2x.

Data Engineer

Teknaux LLC
01.2020 - 03.2023
  • Deployed Debezium and Kafka-based CDC for real-time data replication across microservices.
  • Created and reusable PySpark jobs for large-scale data transformations, resulting in a 50% improvement in code maintainability.
  • Automated ETL workflows that reduced manual processing time by 50% and improved data freshness for daily reporting.
  • Collaborated with cross-functional teams to design data models and build scalable warehouse solutions on Snowflake, supporting business intelligence initiatives.
  • Enabled seamless data flow between on-premises and cloud systems by integrating AWS S3, EC2, and NiFi processors, supporting hybrid cloud architecture.
  • Optimized pipeline design to enhance data processing speed by 20%, integrating solution design, and agile practices.
  • Designed custom data quality frameworks in Python to catch schema drift and null anomalies, reducing downstream reporting issues by 40%.
  • Automated routine tasks using Python scripts, increasing team productivity and reducing manual errors.
  • Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
  • Utilized dbt for scalable SQL transformations and version control, increasing team productivity, and reducing regression errors in production.
  • Built and deployed over 30 dynamic dashboards and reports using tools like Power BI and Tableau, significantly enhancing the clarity and accessibility of data insights.
  • Built reusable NiFi templates for ingestion, transformation, and enrichment, reducing development time for new data sources by 60%.
  • Performed an in-depth analysis of customer and transaction data to support client reporting needs, uncovering insights that led to better retention strategies.
  • Integrated business rules and data enrichment logic into NiFi flows, allowing dynamic routing and prioritization of incoming data streams.
  • Created high-performance materialized views and partitioned tables in BigQuery to enhance data query efficiency for BI tools.
  • Designed and implemented a Snowflake data warehouse that reduced query times by 40% and boosted data accessibility, supporting analytical and operational data systems.
  • Performed root cause analyses to resolve data issues efficiently, decreasing resolution time by 35%, and reinforcing data management standards.

Education

Master of Science - Computer Technology

Eastern Illinois University
Charleston Illinois USA

Bachelor of Technology -

Sri Indu College of Engineering & Technology
Hyderabad India.
05.2001 -

Skills

Programming Languages: Python,SQL, R, Bash Scripting

Databases: PostgreSQL, MySQL, Oracle, MongoDB

Data Warehousing & Lakes: Snowflake, Delta Lake, Amazon Redshift, Azure Synapse

ETL & Data Pipeline, Apache Nifi, Data pipeline design, Apache Airflow, ETL development, Databricks Workflowes: IBM DataStag

Data Processing: Apache Spark, Kafka, DBT

undefined

Timeline

Data Engineer

Elevance Health
07.2024 - Current

Data Engineer

Teknaux LLC
01.2020 - 03.2023

Bachelor of Technology -

Sri Indu College of Engineering & Technology
05.2001 -

Master of Science - Computer Technology

Eastern Illinois University
Saiteja ShiramdasuData Engineer
Profile built at Zety.com