Mohd Khalid Faizan
Data Engineer
New Delhi,DL
Summary
Accomplished Data Engineer with 7 years of expertise in designing and orchestrating multi-cloud data solutions across Azure, AWS, and GCP. Proficient in building robust ETL/ELT pipelines using tools such as Azure Data Factory, AWS Glue, and Airflow, complemented by operational ETL experience with SSIS/SSRS in the insurance sector. Skilled in data warehousing technologies like Snowflake and BigQuery, with advanced capabilities in Python/PySpark and DevOps practices. Committed to leveraging extensive data engineering knowledge and innovative Generative AI (LLM) skills in a challenging and dynamic work environment.
Overview
7
7
years of professional experience
Work History
Data Engineer
Haptiq Labs
01.2025 - Current
- Performing operational tasks within the insurance domain, ensuring reliable data flow and processing using Microsoft BI tools.
- Managing and maintaining SSIS (SQL Server Integration Services) packages for critical ETL operations and data transformations.
- ETL and Data Orchestration: Managed and maintained critical data transformation and ETL pipelines for operational and regulatory processing. Experience in migrating and designing modern workflows utilizing Python for data manipulation and Apache Airflow for scheduling and dependency management.
- Business Intelligence & Reporting: Developed and deployed essential business intelligence reports and dashboards to meet regulatory and operational requirements (mapping to SSRS). Expertise in data visualization like Tableau/Power BI/Looker.
- Database Administration & Quality: Utilized advanced SQL Server (SSMS) functions for performance monitoring, service administration, and ensuring high data quality and reliability. Proficient in writing complex T-SQL queries and developing automated data quality checks using Python (Great Expectations).
- Domain Expertise: Performed core operational tasks within the insurance domain, ensuring reliable data flow and integrity across critical systems.
- LLM Proof of Concept (POC) Project (Internal Innovation)
- Initiated and developed an internal POC for integrating Large Language Models (LLMs) to automate the extraction and summarization of key data from complex, unstructured insurance documents.
- Evaluated open-source LLMs and frameworks for potential use in operational data ingestion and reporting, focusing on enhancing efficiency of the insurance claims process.
Data Engineer
Webonise Lab Pvt Ltd.
05.2022 - 09.2025
- Architected and developed a comprehensive Snowflake Data Warehouse solution for migrating SAP and on-premise transactional data, enabling advanced analysis and reporting.
- Designed and implemented end-to-end ETL/ELT pipelines across AWS and GCP, utilizing AWS Step Functions, AWS Glue, AWS Aurora, and Google Dataflow for robust data orchestration and processing.
- Executed a customer-level data migration plan, ensuring successful data integrity checks and preventing operational overload during the transition phase.
- Engineered PySpark scripts to efficiently extract and transform data from diverse on-premise and AWS databases for consumption in downstream systems.
Data Engineer
Microland Ltd. (Client: Barracuda Networks)
05.2021 - 04.2022
- Designed and developed ETL pipelines using Azure Data Factory (ADF) to ingest data from on-premise sources to different layers within Azure Data Lake Storage (ADLS).
- Implemented a dynamic pipeline framework in ADF to extract and load multiple files into various targets, significantly improving data ingestion efficiency.
- Gained hands-on experience utilizing Docker and Kubernetes for containerization and orchestration of data processing applications.
Software Engineer
Sofzer Technologies Pvt Ltd.
04.2017 - 06.2019
- Developed and maintained ETL pipelines using Azure Data Factory, focusing on data flow transformations and activities to meet specific business requirements.
- Responsible for scheduling and monitoring data pipelines to ensure timely and accurate data delivery.
Education
Data Science, Big Data Analytics
Jawaharlal Nehru University
New Delhi08.2020
MBA - Operations Management (DLP)
ICFAI Sikkim
01.2017
B.Tech - Computer Science
Integral University
Lucknow06.2012
Skills
Cloud Platforms: Azure, AWS, GCP (Google Cloud Platform)
Timeline
Data Engineer
Haptiq Labs
01.2025 - Current
Data Engineer
Webonise Lab Pvt Ltd.
05.2022 - 09.2025
Data Engineer
Microland Ltd. (Client: Barracuda Networks)
05.2021 - 04.2022
Software Engineer
Sofzer Technologies Pvt Ltd.
04.2017 - 06.2019
MBA - Operations Management (DLP)
ICFAI Sikkim
B.Tech - Computer Science
Integral University
Data Science, Big Data Analytics
Jawaharlal Nehru University