Looking for a job

Arka karmakar

@arkakarmakar

Message

AWS Data Engineer at TCS building a serverless Sofinco refund reconciliation solution with Python, Lambda, and SQS.

India

Message

At TCS, I built a serverless refund reconciliation solution for Sofinco payments using Python, AWS Lambda, and SQS. I implemented asynchronous API processing with retries and validation for duplicate transactions and multiple refunds or credit memos per order.

At Freyr Solutions, I designed Python, SQL, and AWS Glue pipelines for multi-tenant analytics, processing millions of records. Async processing improved data processing performance by about 30%, while dynamic provisioning for Amazon QuickSight dashboards reduced reporting turnaround time by 40%.

At Amazon Development Centre India Pvt. Ltd., I automated data extraction and analysis for logistics and operational analytics. My analysis contributed to a 32% reduction in delivery failures, and supported initiatives that contributed to a 28% reduction in logistics costs.

Experience

Work history, roles, and key accomplishments

Current

AWS Data Engineer

Current

TCS

Jul 2026 - Present (3 months)

Built a serverless refund reconciliation solution for Sofinco payments using Python, AWS Lambda, SQS, CloudWatch, IAM, and Secrets Manager. Implemented asynchronous, concurrent API processing with SQS-based retries and exception handling, and provisioned AWS infrastructure with Terraform.

Python AWS Lambda Amazon SQS Cloudwatch IAM Secrets Manager Terraform Asynchronous Processing Exception Handling Data Reconciliation

Data Engineer

Freyr Solutions

Jul 2025 - Jul 2026 (1 year)

Designed Python, SQL, and AWS Glue data pipelines processing millions of records for multi-tenant analytics. Improved data processing performance by about 30% using asyncio and multithreading, and reduced reporting turnaround time by 40% with dynamic data provisioning for Amazon QuickSight.

Python SQL AWS Glue AsyncIO Multithreading Amazon Quicksight Flask PostgreSQL REST APIs Pytest Unit Testing CI CD

Business Analyst Support

Amazon Development Centre India Pvt. Ltd.

Aug 2020 - Jun 2025 (4 years 10 months)

Automated end-to-end data extraction and analysis with Python, SQL, and scheduled workflows for high-volume logistics and operational analytics. Identified root causes of delivery failures through data analysis, contributing to a 32% reduction in delivery failures.

Python SQL Data Analysis Automation Scheduling Workflows Root Cause Analysis Stakeholder Presentation