Shivam Kumar Jaiswal

About Shivam Kumar Jaiswal

I am Data Engineer with strong experience in designing and optimizing scalable data pipelines and ETL workflows. Proficient in PL/SQL, SQL Server, Python, and tools like Informatica, SSIS, Glue with a focus on high-performance data processing. Experienced in data modeling, indexing, and performance tuning for large-scale systems. Skilled in building reliable, efficient, and maintainable data solutions for enterprise applications. Passionate about transforming complex data into actionable insights and driving data-driven decision-making.

Experience

1. Data Engineer

   Tech Mahindra

   Nov 2024 — Present · Noida, IN

   Implemented SCD Type 2 pipelines for master data across ERP systems, maintaining full historical traceability and meeting audit & compliance requirements for finance and reporting teams.• Validated ODS Data Mart transformations using complex SQL joins, window functions, aggregations, ensuring 100% reconciliation accuracy between source and analytical layers.• Resolved 15–20 minute late-arriving data issues by implementing watermark-based incremental loads and controlled reprocessing windows, improving downstream report freshness by 30%.• Performed query optimization and performance tuning using Explain Plan, indexing strategies, SQL profiling, and parallel execution, improving transaction throughput and reducing query response times by up to 75%.• Implemented data quality checks at silver layer (row counts, null checks, referential integrity), preventing bad data propagation to Gold-layer dashboards and reducing production defects by 40%.

Education

• International Institute of Information Technology Bangalore

  PG, Data Science

• Loyola High School, Patna

  Matric, Science

• Noida Institute of Engineering & Technology

  Bachelor of Technology (B.Tech.), Electronics and Communications Engineering

  2015 — 2019