Kankana Dey

Data Engineer

Kolkata, India 2+ yrs exp 85 · Excellent

About

Data Engineer with 2.5+ years of experience in SQL, Python, Power BI, PostgreSQL, MongoDB, AWS, data analysis, data visualization, ETL processes, data validation, reporting, dashboard development, and business intelligence. Experienced in transforming raw data into actionable insights through data extraction, cleansing, transformation, and analysis using AWS S3, AWS Lambda, AWS Glue, and Redshift. Proven track record of delivering scalable cloud-based data solutions, ensuring data quality, and optimizing performance across high-impact domains, specifically for a US-based Insurance Business Unit and the Indian Government's Health Application. Committed to leveraging analytics to support strategic business decisions and operational efficiency.

Skills & Expertise (23)

Python Intermediate

7.5/10

2.5

Years Exp

SQL Intermediate

7.0/10

2.5

Years Exp

ETL Development Intermediate

7.0/10

2.5

Years Exp

Postgresql Intermediate

7.0/10

2.5

Years Exp

GitHub Intermediate

7.0/10

2.5

Years Exp

Git Intermediate

7.0/10

2.5

Years Exp

AWS S3 Intermediate

7.0/10

2.5

Years Exp

AWS Glue Intermediate

7.0/10

2.5

Years Exp

AWS Lambda Intermediate

7.0/10

2.5

Years Exp

AWS Redshift Intermediate

7.0/10

2.5

Years Exp

PySpark Intermediate

6.5/10

2.5

Years Exp

Power BI Intermediate

6.5/10

2.5

Years Exp

Query Optimization Intermediate

6.5/10

2.5

Years Exp

Data Modeling Intermediate

6.5/10

2.5

Years Exp

SDLC Intermediate

6.0/10

2.5

Years Exp

Scrum Intermediate

6.0/10

2.5

Years Exp

Agile Intermediate

6.0/10

2.5

Years Exp

MongoDB Atlas Intermediate

6.0/10

2.5

Years Exp

Apache Spark Intermediate

6.0/10

2.5

Years Exp

Apache Airflow Intermediate

6.0/10

2.5

Years Exp

Databricks Intermediate

6.0/10

2.5

Years Exp

SQL Server Intermediate

5.5/10

2.5

Years Exp

Oracle 19c Intermediate

5.5/10

2.5

Years Exp

Work Experience

Data Engineer

LTM

May 2024 - Present

Worked on multiple data migration projects from Oracle and SQL Server to PostgreSQL, and on-prem MongoDB to MongoDB Atlas/AWS, ensuring data integrity, performance optimization, and seamless cloud transitions. Leveraged these modernized cloud platforms to build scalable semantic models and self-service Power BI dashboards, delivering trusted datasets and robust data observability for cross-functional business analytics.