Keval Padsala

Keval Padsala

Data Engineer
Canada

About Me

Experienced Data Engineer skilled in Python, SQL, Spark, Kafka, AWS. Proven track record in designing and implementing robust data architecture, models, and integration services. Well-versed in managing batch data proces…

Experience

Data Engineer

MIT Consulting
Jan 2022 - Present · 4 years 5 months

Developed and maintained robust data pipelines using Apache Airflow, ensuring high availability and efficient data transfer between MySQL and S3 (Data Lake).
Orchestrated Apache Airflow’s DAG for optimized task execution, resulting in 30% faster task processing.
Conducted data quality analysis on AWS S3 data lake, ensuring high standards in completeness, cleansing, validity, enrichment, and accuracy.
Collaborated with data architects to transform and store data in Redshift, facilitating seamless visualization in Power BI.
Designed and implemented a real-time data ingestion pipeline using Apache Kafka, processing over 50,000 events per second.
Utilized pySpark on Databricks to develop scalable and performant solutions for stream data integration and analysis.

Data Engineer

MIT Consulting, Toronto, ON
Jan 2022 - Present · 4 years 6 months

Developed and maintained robust data pipelines using Apache Airflow to integrate and stitch data from diverse sources, achieving high availability.
Ensured efficient data transfer across MySQL and S3 (Data Lake).
Orchestrated an efficient workflow within Apache Airflow’s Directed Acyclic Graph (DAG), optimizing task execution and scheduling to process tasks 30% faster.
Conducted data quality analysis on AWS S3 data lake, ensuring high data quality standards, including completeness, cleansing, validity, enrichment, and accuracy.
Collaborated with data architects and business partners to transform and store data in Redshift, enabling seamless visualization in a Power BI dashboard.
Designed and implemented a real-time data ingestion pipeline using Apache Kafka, successfully processing over 50,000 events per second, ensuring efficient capture and transmission of webometrics and historical e-commerce data.
Employed pySpark on Databricks to develop highly scalable, extensible, and performant solutions for stream data integration, processing and analyzing.

Data Engineer

GoForClose, Austin, TX
Nov 2020 - Dec 2021 · 1 year 1 month

Developed serverless actors - Web crawlers using Apify and Node.js to extract U.S. residents’ tax histories from over 35 county websites, leveraging advanced proxy and session techniques with tools like Cheerio, Puppeteer, and Playwright for efficient data scraping.
Implemented data wrangling and Scheduler for automated annual data scraping, transferring the data to MySQL via REST API.
Designed and scheduled workflow using python Selenium, Scarpy script that extracts data from predefined websites, cleans, transforms, and dumps into a MySQL database for production use, reducing the amount of manual effort by 70%.
Demonstrated proficiency in bypassing anti-scraping techniques, ensuring the consistent quality and availability of scraped data.

Data Engineer - Web Crawling

UpWork, Surat, GJ
Dec 2019 - Dec 2020 · 1 year

Implemented and managed a Scrapy crawler to systematically extract and parse offers from 40+ diverse Lebanese data sources, ensuring regular updates.
Enhanced metrics and reporting capabilities for web crawling by integrating Linux daemons, ensuring detailed insights into the scraping process and contributing to continuous improvement.
Successfully scraped details from more than 4k restaurants in the USA and Canada from Doordash, showcasing adeptness in anti-scraping techniques to ensure consistent data quality and availability.

Skills

Big Data Python Data Repository Hadoop Spark Apache Hive Apache Pig Amazon Web Services (AWS) Kafka NoSQL Redshift S3 SQL JavaScript Node.js Java OOP Data Structures & Algorithms ZooKeeper spaCy Pandas MySQL PostgreSQL AWS S3 AWS RDS AWS Redshift Snowflake Amazon EC2 AWS Lambda Amazon Athena AWS Glue Azure Databricks Apache Airflow dbt GitHub Selenium Scrapy BeautifulSoup Apify Puppeteer Cheerio Playwright Requests Docker GitHub Actions Jenkins Power BI Tableau Agile Scrum Kanban SDLC REST API Postman Confluence Analytical Self-driven Team-oriented
Report this Profile?