Ajay Singh
@Ajay_Singh
Data Engineer at Quantiphi Analytics
Bengaluru, Karnataka, India
Data Engineer with strong software engineering fundamentals and hands-on experience building scalable, fault-tolerant data pipelines on GCP using Python, SQL, Airflow, BigQuery, and DBT. Experienced in refactoring legacy systems into optimized cloud-native architectures with strong focus on performance tuning, cost optimization, and data correctness.
Experience
Data Engineer
Quantiphi Analytics
Led end-to-end data migration initiatives from legacy Mainframe and Exasol systems to GCP BigQuery, designing scalable, cloud-native ETL pipelines to support critical business domains. Built and orchestrated 15+ data workflows using GCP Composer (Apache Airflow), managing complex job dependencies, automated scheduling, monitoring, and failure handling across ingestion and transformation layers. Analyzed and refactored 50+ legacy SQL scripts into BigQuery-compatible SQL, ensuring data accuracy, functional parity, and successful validation through collaboration with business and QA teams. Designed analytics-ready data models using DBT, implementing star schema–based dimensions and fact tables and developing 10+ reusable macros and standardized transformation layers. Optimized BigQuery and DBT performance, reducing query execution time by 30–40%, lowering processing costs by 20%, and improving downstream reporting reliability and data availability.
Education
Lakshmi Narain College of Technology
Bachelor of Engineering
Computer Science
Licenses & Certifications
Google Cloud Associate Cloud Engineer
Google Cloud
Google Cloud Professional Data Engineer
Google Cloud