Karan Wadhwa

Data Engineer with expertise in developing scalable ETL pipelines and optimizing data workflows. Proficient in Python, JavaScript, and SQL, with a solid understanding of data warehousing and modern architectures. Experienced in collaborating across teams to provide actionable insights that enhance business performance. Strong analytical skills focused on resolving complex data challenges and supporting data-driven decisions.

Senior Data Engineer at Axtria India Pvt Ltd (2022-08 – Present)

• Developed ETL pipelines using AWS services that optimized data ingestion, transformation, and loading for timely delivery of high-quality data.
• Built automated scripts utilizing trusted source APIs to eliminate manual queue records in Data Stewardship, leveraging AWS Lambda and related cloud functions.
• Created backend for Tableau dashboards by implementing business rules for effective data visualization and analysis, integrating data from Snowflake.
• Designed a Python-based framework for executing data quality checks across ingestion and transformation processes, with validations applied on Snowflake tables.
• Optimized data models and warehouse structures using Snowflake and advanced storage/retrieval techniques to meet organizational needs.

Senior Analyst at Capgemini India Pvt Ltd (2020-09 – 2022-07)

• Executed data cleaning and transformation processes to ensure data accuracy and integrity.
• Enhanced charts and datasets for improved clarity, aligning with business requirements.
• Developed Key Performance Indicators (KPIs) to monitor project progress and performance metrics.
• Advised senior management on strategic and tactical data-driven decisions.
• Presented reports to stakeholders to proactively mitigate risks.
• Refactored legacy code and maintained existing code for report generation application.

Bachelor of Technology in Computer Science – Guru Nanak Dev University (2016-07 – 2020-06)

Intermediate – B.S.F Sr Sec School (2016-05)

High School – B.S.F Sr Sec School (2014-05)