Ajay Kathrotiya

About Ajay Kathrotiya

Results-driven AWS Data Engineer & SQL Developer with 4 years of combined experience in building, optimizing, and managing data solutions. Experienced in designing ETL pipelines, SQL development, cloud-based data architectures, and database performance optimization to support analytics and business intelligence initiatives.AWS Data Engineering Experience (3 years): • Designed and implemented ETL pipelines to extract, transform, and load data from multiple sources into cloud data warehouses. • Built and managed data pipelines and workflows using AWS services such as S3, RDS, Redshift, and Lambda. • Automated monitoring, alerting, and performance tuning of cloud-based databases to ensure reliability and scalability. • Migrated on-premises databases to AWS cloud environments with minimal downtime, implementing high availability (HA) and disaster recovery (DR) strategies. • Collaborated with data analytics and BI teams to deliver actionable insights from structured and unstructured data.SQL Development Experience (1 year): • Developed and optimized T-SQL queries, stored procedures, and scripts for transactional and analytical systems. • Implemented indexing strategies, query optimization, and execution plan analysis to improve performance. • Ensured data integrity and reliability through robust validation, backup, and recovery strategies. • Supported database design and schema optimization to meet evolving application and reporting requirements.Technical Skills: SQL Server, T-SQL, SQL Development, ETL, Data Modeling, AWS (S3, RDS, Redshift, Lambda), Data Warehousing, Performance Tuning, Cloud Data Pipelines, BI & Analytics Support

Experience

1. Consultant Data Engineer

   Deloitte

   Jan 2026 — Present · Pune, IN

Education

• Arpan Vidhya Sankul

  SSC

• The Maharaja Sayajirao University of Baroda

  Electrical Engineering

  2017 — 2021

• Jay Ambe Vidhyabhavan

  HSC, Engineering Science