Karan Chadha

Data Engineer

Ambala, Haryana, India9 yrs 8 mos experience

Highly Stable

Key Highlights

6+ years of experience in data analysis and reporting.
Expert in building end-to-end ETL pipelines.
Proficient in Azure and AWS data services.

Stackforce AI infers this person is a Data Engineering and Business Intelligence expert in the Healthcare and Retail sectors.

Contact

Skills

Core Skills

Data EngineeringBusiness IntelligenceData Analysis

Other Skills

APIsAWS GlueAWS RedshiftAWS servicesAmazon RedshiftAmazon Web Services (AWS)Analytical SkillsApache SparkAttention to DetailAzure Data FactoryAzure DatabricksAzure DevOps ServicesAzure servicesBusiness AnalysisBusiness Intelligence (BI)

About

Experienced Data Professional with 6+ years of expertise in data analysis, reporting, and cloud-based data solutions. Skilled in Excel (Pivot Tables, Power Query), Power BI, SQL, and Azure (Data Factory, Data Lake, Databricks). Proficient in building end-to-end ETL pipelines, developing interactive dashboards, and transforming complex data into actionable insights. Hands-on experience with Azure and AWS data services, medallion architecture, and data modeling. Strong collaborator with a proven ability to bridge technical and business teams for organizational growth.

Experience

9 yrs 8 mos

Total Experience

3 yrs 10 mos

Average Tenure

1 yr 11 mos

Current Experience

Lotus software solutions

BI Developer / Data Engineer

Jul 2024 – Present · 1 yr 11 mos · Remote

Roles and Responsibility :
Currently working in healthcare domain project, I am responsible for integrating and analyzing data from a variety of sources, including AWS Redshift, Snowflake, SQL Server, and APIs.
Designed and implemented a robust data pipeline in Azure Data Factory, ensuring efficient data flow and seamless integration across platforms.
Utilize Databricks for powerful data transformation, employing SparkSQL and PySpark to process and prepare large datasets for analysis.
Create dynamic and insightful reports in Power BI, translating complex data into clear visuals that support informed decision-making across the organization.

Azure Data FactoryDatabricksPower BIAWS RedshiftSnowflakeSQL Server+3

Xerox

Data Analyst

Apr 2018 – Feb 2024 · 5 yrs 10 mos · Chandigarh, India

Roles & Responsibilities :
Developed end-to-end data pipelines for two retail domain projects, integrating data from multiple cloud sources—one project leveraging AWS services (S3, Redshift, Athena) and the other using Azure services (Blob Storage, Data Lake, Data Factory).
Extracted, transformed, and loaded (ETL) data from diverse sources, including cloud platforms and on-premises systems, ensuring seamless data integration and processing across platforms.
Designed and implemented scalable data workflows using Azure Data Factory and AWS Glue to automate data ingestion and transformation, optimizing performance and reliability.
Developed complex queries in SQL to extract actionable insights from large datasets stored in Snowflake and Azure Databricks, ensuring efficient data retrieval and processing.
Collaborated with cross-functional teams to resolve data inconsistencies and maintain data accuracy and integrity throughout the pipelines.
Built interactive dashboards and reports in Power BI, visualizing key metrics and trends for business stakeholders, enhancing decision-making processes.
Optimized pipeline performance, ensuring scalability and efficient resource utilization in both cloud environments (AWS and Azure), adapting the architecture to handle growing data volumes.
Ensured data security and governance by implementing access controls and monitoring in both AWS and Azure environments, complying with organizational and industry standards.