Saiteja Ravipati
Irving,TX
Summary
Accomplished Python/Data Engineer with a proven track record at Caterpillar, specializing in AWS services and ETL pipeline optimization. Expert in leveraging Apache Airflow and Snowflake to enhance data workflows, achieving a 35% reduction in execution time. Strong problem-solving skills and a commitment to operational excellence drive impactful data solutions.
Overview
2
2
years of professional experience
Work History
Python/Data Engineer
cynosure/Caterpillar
Irving, TX
05.2024 - Current
- Designed and maintained end-to-end data pipelines using AWS services, including S3, Lambda, Glue, and Step Functions, reducing pipeline execution time by 35%.
- Orchestrated data workflows with PLM (similar to AirFlow) and implemented DLQ mechanisms, improving pipeline failure traceability and recovery.
- Developed ETL jobs with Python and custom frameworks to clean, standardize, and load customer data into Snowflake for downstream analytics and reporting.
- Integrated SQS/SNS messaging for efficient inter-service communication, enabling real-time alerts, and stage-level monitoring.
- Built modular pipeline components, including Jobs, Steps, Triggers, and Connectors, improving reusability and operational agility.
- Conducted monitoring and logging through PLM, enabling proactive issue detection and performance tracking with minimal manual intervention.
- Automated MCP server log retrieval using GitHub Copilot, enabling on-demand and scheduled diagnostics, with zero manual effort.
Data Engineer
Afton Technologies/Autodesk
San Rafael, CA
02.2023 - 03.2024
- Built and maintained scalable ETL pipelines using AWS Glue, Lambda, and Redshift for structured data ingestion and transformation.
- Automated workflows with Python and PySpark, reducing manual intervention, and improving data pipeline efficiency.
- Designed data lakes and dimensional models to support reporting and ML use cases.
- Orchestrated ETL jobs with Apache Airflow, ensuring reliable and on-time data delivery.
- Integrated CI/CD using Jenkins and GitHub for seamless code deployment and version control.
- Optimized SQL queries and database schemas for performance improvements in data retrieval operations.
Education
Master's Degree - Informational Technology
University of Memphis
Memphis, TN12-2022
Skills
- Languages: Python, Java, SQL, ABAP, and SAP SQLScript
- Data Engineering: Apache Spark, PySpark, Airflow, Glue, Step Functions, Snowflake
- Cloud Platforms: AWS (S3, Lambda, Glue, EC2, RDS, Redshift), Azure (ADF, Databricks, Blob Storage)
- ETL Tools: AWS Glue, SAP HANA SDI, Informatica, Custom Python ETL
- Databases: PostgreSQL, Oracle, Redshift, RDS, Snowflake, SAP HANA
- Big Data & Streaming: Kinesis, HDFS, Spark Streaming, SAP HANA Streaming Analytics
- DevOps and CI/CD: GitHub, Azure DevOps, Jenkins, Docker, GitHub Copilot
- Data Visualization: Power BI, SAP Analytics Cloud, Tableau
- Others: Terraform, JSON, XML, Linux, JIRA, Agile, REST APIs
Timeline
Python/Data Engineer
cynosure/Caterpillar
05.2024 - Current
Data Engineer
Afton Technologies/Autodesk
02.2023 - 03.2024
Master's Degree - Informational Technology
University of Memphis
Similar Profiles
JEREMY OKWUCHUKWUJEREMY OKWUCHUKWU
Facilitator at CYNOSURE CLEANING COMPANYFacilitator at CYNOSURE CLEANING COMPANY
Abhishek BabuAbhishek Babu
Manager of Operations at CYNOSURE RECYCLING PVT. LTDManager of Operations at CYNOSURE RECYCLING PVT. LTD
Junhui XieJunhui Xie
Site Supervisor at Cynosure HomeSite Supervisor at Cynosure Home
Krashanna EvansKrashanna Evans
Childcare Director at Brighter Day AcademyChildcare Director at Brighter Day Academy
JAKE MAGULICKJAKE MAGULICK
Recruiting Consultant at Caliber Healthcare SolutionsRecruiting Consultant at Caliber Healthcare Solutions