DEVESH SINGH KHOLIYA
Dehradun
Summary
Results-driven Data Engineer with expertise in ETL, cloud data migration, and analytics, specializing in Google Cloud Platform (GCP) and AWS. Proven ability to design and optimize large-scale data pipelines, ensuring efficiency, accuracy, and cost-effectiveness. Strong experience in financial risk analytics and advanced data processing, leveraging SQL, Python, and Apache Airflow. Passionate about solving complex data challenges and streamlining cloud-based solutions.
Overview
1
1
year of professional experience
1
1
Certification
Work History
Data Engineer
TEKsystems Global Services
12.2023 - Current
- Worked on data migration and integration initiatives for financial and cloud-based systems.
- Developed ETL pipelines using Google Cloud Data Fusion, Apache Airflow, and BigQuery for large-scale data transformations.
- Worked on financial risk analytics, optimizing entity resolution, fraud detection, and compliance monitoring for banking clients.
- Migrated on-prem Hadoop HDFS datasets to Google Cloud (BigQuery & Cloud SQL) using GCS staging layers for optimal performance.
Education
Bachelor of Technology - Computer Science & Engineering
DIT University
01.2023
Skills
- ETL & Data Pipelines
- Cloud AWS & GCP
- DataProc
- BigQuery
- Apache Airflow
- SQL
- Python
- PySpark
- Data Warehousing
- Quantexa
- Data Transformation
- Data Quality & Governance
Projects
Financial Risk Analytics - Data Migration to Quantexa Data Fusion
Client: HSBC
Role: Data Engineer
- Migrated financial risk data from legacy banking systems to Quantexa Data Fusion, enabling entity resolution, network analytics, and fraud detection.
- Designed and implemented ETL pipelines using Google Cloud Data Fusion for data extraction, transformation, and loading (ETL).
- Migrated structured/unstructured data from on-prem databases, cloud storage, and transaction logs to Quantexa.
- Developed data mapping strategies to unify customer profiles, transactions, and corporate entities.
- Automated incremental data updates for real-time fraud detection and compliance monitoring.
Client: Inmar Inc.
Role: Data Engineer
- Migrated large-scale datasets from on-prem Hadoop HDFS to Google Cloud (BigQuery & Cloud SQL).
- Designed optimized migration frameworks using Google Cloud Storage (GCS) as a staging layer to transfer Hive tables to BigQuery.
- Developed Apache Airflow DAGs to automate ETL workflows, improving reliability and scalability.
- Optimized table partitioning and indexing in BigQuery to improve query efficiency and reduce costs.
Certification
- AWS Certified Developer Associate
- Databricks Data Engineer Associate
- SnowPro Core Certified
Awards
TGS Customer Excellence Team of the Year, TEKsystems, Recognized for delivering innovative solutions with a high impact on business operations and customer success.
Timeline
Data Engineer
TEKsystems Global Services
12.2023 - Current
Bachelor of Technology - Computer Science & Engineering
DIT University
Similar Profiles
Sreekar PalavaiSreekar Palavai
Software Engineer at TEKsystems Global ServicesSoftware Engineer at TEKsystems Global Services
KOREY BROOKSKOREY BROOKS
Full Stack Developer at TEKsystems Global ServicesFull Stack Developer at TEKsystems Global Services
Uday GhuleUday Ghule
Integration Architect and team lead at TEKSystems Global ServicesIntegration Architect and team lead at TEKSystems Global Services
Karthikeyan VijayakumarKarthikeyan Vijayakumar
Cloud Architect at TekSystems Global ServicesCloud Architect at TekSystems Global Services
ANKIT BAHUGUNAANKIT BAHUGUNA
Territory Business Executive at TALENT INDIA AHMEDABADTerritory Business Executive at TALENT INDIA AHMEDABAD