SHAGUN YADAV

Data Engineer | SQL Optimization | Scalable Data Pipelines | BFSI Data Systems

Noida, Uttar Pradesh, India

About

Experience

  • LUMIQ (On-site)
    • Senior Data Engineer
      Jun 2024 - Present · 2 yrs 2 mos

    • Data Quality Analyst
      Aug 2023 - Present · 3 yrs

    • data engineer
      Jun 2022 - Present · 4 yrs 2 mos

      Data Engineering Intern Jan 17, 2022 – Jun 15, 2022 (6 months) Built and maintained scalable data pipelines using Apache Airflow and Apache NiFi for ETL orchestration. Developed data processing solutions using Python, PySpark, and SQL to handle large datasets efficiently. Designed and implemented configuration-driven pipelines using external config files (YAML/JSON) for flexible and reusable workflows. Generated and monitored metric/log files to track pipeline performance, failures, and data quality. Wrote and optimized complex SQL queries for data extraction, transformation, and validation. Used Bitbucket for version control and collaborative development. Worked on PyCharm for coding, debugging, and performance tuning. Managed pipelines in an on-premises environment, ensuring secure data processing. Performed data validation, troubleshooting, and root cause analysis to maintain data integrity.