Avnish Rajput

About Avnish Rajput

Currently working as Consultant II at Capco, focusing on cloud-based data engineering. Specializes in building scalable data pipelines, transforming raw data into high-quality datasets, and ensuring accuracy and consistency using DBT, PySpark, and SQL. Holds a Bachelor of Technology in Computer Science & Engineering from Dr. Ram Manohar Lohia Avadh University. Experienced in leveraging AWS services, including S3, Athena, Glue, and Lambda, to design and deploy efficient data solutions that drive business insights.

Experience

1. Consultant Ii

   Capco

   Dec 2024 — Present · Gurugram, IN

   I work as a Senior AWS Data Engineer, specializing in building and optimizing cloud-based data solutions. My role focuses on transforming raw data into reliable, high-quality datasets that drive business insights and decision-making.1. Designing, developing, and deploying scalable data pipelines across base to dev layers.2. Transforming and testing data to ensure accuracy, consistency, and quality.3. Validating and reconciling datasets across multiple layers to maintain integrity.4. Leveraging DBT for data transformation and modeling, ensuring modular and maintainable workflows.5. Using PySpark and SQL for large-scale data processing and transformation.6. Working with AWS services (S3, Athena, Glue, Lambda, etc.) to build cloud-native data platforms.7. Driving end-to-end data validation, testing, and deployment for reliable analytics delivery.

Education

• Dr. Ram Manohar Lohia Avadh University

  Bachelor of Technology - BTech, Computer Science & Engineering

  2014 — 2018