Akash Gupta

About Akash Gupta

Key Highlights:• Working as Engineering Lead with 6.5+ years of extensive experience in crafting and maintaining high-performance data processing systems within the Amazon Web Services (AWS) environment.• My expertise lies in leveraging AWS services such as S3, Glue, Athena, RDS, DMS, Lambda CloudFormation and Redshift to design robust data pipelines that efficiently handle the ingestion, transformation, and storage of large datasets. I am dedicated to ensuring data accuracy, security, and compliance, implementing best practices for data warehousing, and fine-tuning query performance.• Experience in designing databases and creating database objects including tables, relationships, stored procedures, user-defined functions, views, clustered and non-clustered indexes, triggers, derived tables and CTEs. T-SQL programming for writing numerous ordinary to complex queries involving multi- table joins, union, correlated subqueries, CTE\'s and views for diverse business requirements.• Possessing proficient skills in Python and Pyspark for large-scale data processing, transformation, and integration to execute ETL operations.• Developed ETL Procedures using SSIS packages used in various sales incentive scheme and OLAP and Involved in troubleshooting, resolving data integrity, and monitoring performance issues.• Good knowledge of data warehousing concept like fact and dimension tables, data marts and data modelling, Data Lake formation• Good Knowledge of Power BI. Created DAX query to generate computed columns and tables, done modelling, created multiple user-friendly visualization, used M query transformation to transform the data as per need, published power BI reports, configure Gateway for dashboard update, Create and set up workspaces.

Experience

1. Engineering Team Lead

   Precision AQ

   Mar 2026 — Present

Education

• Shree L. R. Tiwari College of Engineering.

  Bachelor of Engineering - BE