Sai Charan Anumolu
Atlanta,
Summary
- Results-driven Data Engineer with 3+ years of experience in ETL development, database optimization, and real-time data integration. Proficient in AWS Glue, Redshift, Lambda, Airbyte and Airtable, designing scalable ETL pipelines for seamless data ingestion, transformation, and validation. Optimized Redshift performance through indexing, partitioning, and query tuning, enhancing data retrieval speed.
- Developed Airtable-based solutions for real-time CRM data synchronization, integrating webhooks, OAuth authentication, and historical data processing. Designed and deployed custom ETL workflows to sync and transform datasets between Airtable, Snowflake, and PostgreSQL. Strong expertise in Airtable schema design, automations, and interfaces, combined with SQL and advanced data transformations to enable analytics and reporting.
- Collaborated with cross-functional teams to enhance data quality, governance, and compliance, delivering efficient, high-performance data solutions. Experienced in AWS services such as Glue, Redshift, Lambda, Step Functions, CodePipeline, and CloudWatch, ensuring scalability, security, and automation in cloud-based data architectures.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Software Engineer
Kunai
05.2024 - Current
- Designed and deployed Airtable applications to manage CRM-related data such as contacts, calendar responses, and attachments, improving collaboration and reducing manual effort.
- Built Airtable schemas and linked tables to centralize business data, while optimizing data models for scalability and reporting.
- Developed custom Airtable interfaces and automations, including event-driven updates, notifications, and third-party API integrations, streamlining operations.
- Integrated Airtable with CRMs and databases (Twenty CRM, Snowflake, PostgreSQL) via custom connectors, ensuring consistent and reliable data synchronization.
- Implemented historical data workflows in Airtable, enabling structured access to legacy CRM records.
- Engineered scalable ETL pipelines for ingesting and transforming datasets from multiple sources, including email, Snowflake, PostgreSQL, and Airtable.
- Optimized Airbyte configurations for incremental sync, reducing latency and processing overhead in data pipelines.
- Designed and optimized SQL queries and stored procedures in Snowflake and PostgreSQL, supporting analytics and reporting.
- Developed custom API integrations and dynamic GraphQL queries to synchronize data across external services and internal platforms.
- Configured Azure DevOps release pipelines to deploy SQL Server database changes across environments with consistency and reliability.
- Integrated Python and Scala scripts into Azure Data Factory (ADF) pipelines for orchestrating complex data workflows in hybrid environments.
- Partnered with leadership, engineers, and business teams to gather requirements, deliver prototypes, and align Airtable and data solutions with strategic goals.
Data Engineer
ExponentHR
11.2023 - 02.2024
- Developed and maintained incremental ETL processes using Change Data Capture (CDC), ensuring efficient data updates and accurate integration
- Implemented ETL solutions using AWS Glue and Lambda for complex data transformations, meeting specific business requirements
- Designed ETL pipelines leveraging AWS services such as S3, Redshift, and Step Functions to handle data extraction, transformation, and loading processes
- Developed data integration workflows using Python, SQL, and AWS Lambda to enhance data flow efficiency
- Engineered ETL pipelines with AWS CodePipeline to manage data transformations, implementing CI/CD practices for seamless deployment
- Monitored and addressed failed AWS Glue jobs by analyzing logs in CloudWatch, implementing retry mechanisms to improve pipeline robustness
- Led troubleshooting and debugging efforts for ETL/ELT processes, creating comprehensive unit tests to ensure data transformation reliability
Assistant System Engineer (Data)
TATA Consultancy Services
11.2020 - 12.2021
- Conducted extensive database performance analysis on AWS Redshift, leading to optimized performance and reduced query execution time
- Managed and executed ETL processes using AWS Glue and Redshift, ensuring seamless integration, analysis, and validation of large datasets
- Implemented effective indexing strategies within Redshift to enhance query performance and data retrieval speed
- Developed ETL solutions leveraging AWS services, including Glue for data integration and Lambda for handling automated data tasks
- Addressed client queries promptly, resolving design, performance, and technical issues while ensuring clear communication of solutions
- Developed complex data transformations using Glue jobs, implementing logic for aggregations, joins, and conditional splits
- Utilized SQL to maintain data integrity and optimize database structures within Redshift, executing advanced queries for data analysis
Data Engineer
Uber India Research and Development Center
09.2019 - 03.2020
- Designed, implemented, and optimized stored procedures and SQL queries to extract insights, generate comprehensive reports, and support advanced analytics for strategic decision-making
- Collaborated with cross-functional teams to understand data requirements and developed efficient data pipelines, ensuring seamless integration with downstream reporting systems
- Enhanced data quality and reporting accuracy through rigorous validations, data audits, and adherence to privacy regulations, securing sensitive information while maintaining compliance
- Implemented ETL processes that enabled the transformation and integration of diverse data sources into centralized repositories, facilitating faster and more reliable reporting
- Designed and developed interactive dashboards and reports, providing stakeholders with clear visualizations and metrics to drive data-driven decisions
- Optimized database architecture, including table indexing, partitioning, and storage strategies, improving data retrieval speed and enabling efficient access for complex reporting needs
Education
Big Data Analytics and Information Technology -
University of Central Missouri
05.2023
Skills
Programming & Scripting Languages
- Python (Pandas, NumPy, FastAPI, Flask)
- TypeScript
- JavaScript
- SQL (Advanced, Complex Queries, Performance Tuning)
Cloud & DevOps
- Azure (DevOps, Data Factory, SQL Server, SSIS, Synapse)
- AWS (Glue, Redshift, S3, Lambda, Step Functions, IAM, RDS, EMR, Kinesis, QuickSight, CloudWatch,
- CodePipeline, CodeBuild, Data Pipeline, Aurora, DynamoDB, DMS, Athena)
- CI/CD (Azure DevOps, GitHub Actions, Jenkins)
Databases & Data Engineering
- Airtable, PostgreSQL, Snowflake, MySQL, MS SQL Server
- Stored Procedures, Functions & Triggers
- Indexing & Partitioning
- Database Performance Tuning & Query Optimization
- Data Warehousing & ModelingData Pipelines (Batch & Real-Time)
- Incremental Data Processing
- Data Validation & Quality Assurance
- CDC (Change Data Capture) Implementation
API & Integration
- RESTful APIs & GraphQL
- Webhook & API Integration
- OAuth 20, JWT Authentication
- Email Parsing & Data Structuring (IMAP, SMTP)
- Database & CRM Integration ( Twenty CRM, Airtable)
Workflow Automation & Data Processing
- n8n, Airbyte, WhaleSync, Airtable
- ETL/ELT Development (SSIS, AWS Glue, Dataflow)
Business Intelligence & Dashboards
- Power BI, Tableau
- Data Visualization & Storytelling
Big Data & Distributed Systems
- Apache Spark (PySpark, SQL)
- Hadoop Ecosystem (HDFS, Hive, Impala)
Project Management & Agile
- JIRA
- Confluence
- Agile Methodologies (Scrum, Kanban)
- Version Control & Collaboration
- Git, GitHub, GitLab, Azure DevOps
- Code Review & Branching Strategies
Accomplishments
Successfully integrated business communications into Twenty CRM and Airtable, enabling seamless ingestion and synchronization of calendar responses, contacts, and attachments. Designed a UI-driven onboarding platform for secure Google account connections and automated sync management, improving user experience and adoption. Engineered a real-time ingestion pipeline using webhooks, n8n, and Windmill, significantly reducing latency in syncing new events and updates. Additionally, implemented historical synchronization, ensuring businesses had complete and structured access to past interactions and records within Airtable. This solution enhanced data reliability, reduced manual intervention, and streamlined CRM and Airtable workflows, enabling better business insights and decision-making.
Certification
- AWS Certified Data Engineer – Associate - Amazon Web Services (AWS).
- Microsoft Certified: Azure Data Engineer Associate
Languages
English
Full Professional
Telugu
Native or Bilingual
Hindi
Professional Working
Hobbies and Interests
- Tech enthusiast, passionate about exploring the latest advancements and innovations.
- Road Trips
- Passionate about balancing physical health with mental and emotional wellness.
- Gym Workouts
Timeline
Software Engineer
Kunai
05.2024 - Current
Data Engineer
ExponentHR
11.2023 - 02.2024
Assistant System Engineer (Data)
TATA Consultancy Services
11.2020 - 12.2021
Data Engineer
Uber India Research and Development Center
09.2019 - 03.2020
Big Data Analytics and Information Technology -
University of Central Missouri