Available to hire
Hi, I’m Poonam Kanwar, a passionate Data Engineer with 5 years of experience building scalable data pipelines. Based in Bangalore, India, I specialize in leveraging AWS and big data technologies to optimize data processing and analytics. I have a strong background in ETL processes, cloud architectures, and real-time data workflows.
As an Indian citizen, I am open to global work opportunities and can provide my own visa/work permit for Germany within 5-8 weeks. I am continuously learning new technologies and advancing my skills in data engineering and cloud computing to deliver impactful data solutions.
Skills
Experience Level
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
Intermediate
Intermediate
Intermediate
Beginner
Language
English
Fluent
Hindi
Fluent
German
Beginner
Work Experience
Senior Data Engineer at Empower
April 1, 2024 - PresentWorked on NFinancial Retirement Plan Platform, a US-based financial platform serving 83,000 organizations and over 19 million individuals. Designed and built scalable big data pipelines in AWS, reducing data processing time by 40%. Implemented AWS Glue for ETL transformations, decreasing manual workload by 35%. Automated workflows using AWS EventBridge and Step Functions, cutting operational costs by 25%. Integrated DynamoDB for metadata storage and AWS Lambda for real-time processing, improving system efficiency. Used AWS Athena to cut query execution times by 35%. Leveraged AWS EMR Serverless to enhance system performance by 20%.
Data Engineer at Accenture
April 30, 2024 - July 14, 2025Contributed to RocheHealth ETL project, a global medical data platform analyzing product and material availability for the German market. Designed and implemented PySpark-based ETL pipelines on AWS, reducing manual processing time by 29%. Optimized data transformations using AWS Glue and Athena, improving query performance by 30%. Integrated DynamoDB and AWS Lambda for real-time metadata storage and on-demand transformations. Improved Spark job performance by 40% using efficient partitioning and caching strategies. Also worked on a Data Comparison Engine to ensure data consistency, increasing data accuracy by 98% and minimizing downtime with AWS Lambda-based recovery jobs.
Data Engineer at Consulting Engineers Group
August 31, 2021 - July 14, 2025Worked on data processing and analytics for an India-based engineering consulting firm. Developed SQL-based ETL workflows, improving data transformation efficiency by 30%. Automated pipeline processing with Python and SQL, reducing manual workload by 20%. Designed custom data validation scripts to reduce inconsistencies by 20%.
SQL Developer Intern at Smart India Hackathon (SIH)
June 30, 2020 - July 14, 2025Optimized SQL queries and database management for enterprise applications. Improved query performance by 35% through optimization and indexing. Assisted in data migration reducing downtime by 40%. Developed stored procedures and triggers to automate data processing, increasing operational efficiency.
Senior Data Engineer at Empower, Bangalore, India
April 1, 2024 - PresentLed the design and development of scalable big data pipelines in AWS, significantly reducing data processing time by 40%. Automated ETL transformations using AWS Glue, cutting manual workloads by 35%. Developed event-driven workflows with AWS EventBridge and Step Functions to decrease operational costs by 25%. Integrated DynamoDB for metadata storage and AWS Lambda for real-time processing, improving system efficiency. Used AWS Athena for data analytics, reducing query execution times by 35%. Leveraged AWS EMR Serverless for high-volume data processing, enhancing system performance by 20%. Technologies used included AWS S3, Redshift, Glue, Lambda, DynamoDB, EventBridge, Step Functions, Athena, EMR Serverless, PySpark, Spark SQL, Databricks, and SQL.
Data Engineer at Accenture, Bangalore, India
April 1, 2024 - August 27, 2025Designed and implemented PySpark-based ETL pipelines on AWS, reducing manual processing time by 29%. Optimized data transformations using AWS Glue and Athena, improving query performance by 30%. Integrated DynamoDB for metadata storage and used AWS Lambda for on-demand data transformations ensuring real-time updates. Enhanced Spark job performance by 40% through efficient partitioning and caching strategies. Also developed an automated data validation framework in Python, increasing data accuracy by 98%, and implemented AWS Lambda-based data recovery jobs to minimize downtime. Technologies included PySpark, AWS Glue, Lambda, DynamoDB, Athena, Spark SQL, and SQL.
Data Engineer at Consulting Engineers Group, Bangalore, India
August 1, 2021 - August 27, 2025Developed SQL-based ETL workflows improving data transformation efficiency by 30%. Automated data pipeline processing using Python and SQL, reducing manual workload by 20%. Designed custom data validation scripts to ensure data integrity, reducing inconsistencies by 20%. Technologies used included Python, SQL, and ETL tools.
SQL Developer Intern at Smart India Hackathon (SIH), Bangalore, India
June 1, 2020 - August 27, 2025Optimized SQL queries and database management for enterprise applications, enhancing query performance by 35%. Assisted in data migration projects, reducing downtime by 40%. Developed stored procedures and triggers to automate data processing, increasing operational efficiency. Technologies used included SQL, Python, and ETL.
Education
Bachelor of Technology at Jaipur National University, Jaipur, India
June 1, 2017 - June 30, 2021Bachelor of Technology / Computer Science at Jaipur National University, Jaipur, India
June 1, 2017 - June 1, 2021Qualifications
AWS Certified Solutions Architect - Associate
January 1, 2024 - December 31, 2024AWS Certified Solutions Architect - Associate
January 1, 2024 - August 27, 2025Industry Experience
Financial Services, Healthcare, Professional Services, Software & Internet
Skills
Experience Level
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
Intermediate
Intermediate
Intermediate
Beginner
Hire a Data Scientist
We have the best data scientist experts on Twine. Hire a data scientist in Bengaluru today.