Ansh Pandey

QA Manager

Noida, Uttar Pradesh, India5 yrs 6 mos experience
AI EnabledHighly Stable

Key Highlights

  • Expert in architecting cloud data architectures.
  • Led critical ETL and LLM workflows at HCLTech.
  • Strong focus on data validation and quality assurance.
Stackforce AI infers this person is a Data Engineering professional specializing in ETL processes and cloud data solutions.

Contact

LinkedIn

Skills

Core Skills

Etl TestingData EngineeringData Visualization

Other Skills

Management Information Systems (MIS)Python (Programming Language)Conducted ETL testingWrote and executed complex SQL queriesCreated Tableau and Power BI dashboardsMentored junior QA engineersSQLTableauPower BIDAXAgile ModelingQA EngineeringEnd-to-end TestingScrumSQL Server Reporting Services (SSRS)

About

โ€‹๐Ÿš€ ๐“๐ฎ๐ซ๐ง๐ข๐ง๐  ๐ซ๐š๐ฐ ๐๐š๐ญ๐š ๐ข๐ง๐ญ๐จ ๐ซ๐ž๐ฅ๐ข๐š๐›๐ฅ๐ž, ๐ž๐ง๐ญ๐ž๐ซ๐ฉ๐ซ๐ข๐ฌ๐ž-๐ซ๐ž๐š๐๐ฒ ๐š๐ฌ๐ฌ๐ž๐ญ๐ฌ. โ€‹I am an ๐„๐“๐‹ ๐๐€ ๐š๐ง๐ ๐ƒ๐š๐ญ๐š ๐๐ซ๐จ๐Ÿ๐ž๐ฌ๐ฌ๐ข๐จ๐ง๐š๐ฅ with over 5+ years of experience spanning the full data lifecycleโ€”from robust extraction (ETL) to actionable visualization. โ€‹My expertise lies in architecting resilient cloud data architectures, orchestrating workflows with ๐€๐ณ๐ฎ๐ซ๐ž ๐ƒ๐š๐ญ๐š ๐…๐š๐œ๐ญ๐จ๐ซ๐ฒ, and performing advanced transformations using ๐€๐ณ๐ฎ๐ซ๐ž ๐ƒ๐š๐ญ๐š๐›๐ซ๐ข๐œ๐ค๐ฌ (๐๐ฒ๐’๐ฉ๐š๐ซ๐ค). โ€‹I bring a unique "๐๐ฎ๐š๐ฅ๐ข๐ญ๐ฒ-๐…๐ข๐ซ๐ฌ๐ญ" mindset to data engineering. I donโ€™t just build pipelines; I rigorously stress-test and validate them to ensure they handle enterprise-scale loads without failure. โ€‹๐Ÿ›  ๐Œ๐ฒ ๐“๐ž๐œ๐ก๐ง๐ข๐œ๐š๐ฅ ๐“๐จ๐จ๐ฅ๐ค๐ข๐ญ: โ€‹โ˜๏ธ ๐Ž๐ซ๐œ๐ก๐ž๐ฌ๐ญ๐ซ๐š๐ญ๐ข๐จ๐ง & ๐ˆ๐ง๐ ๐ž๐ฌ๐ญ๐ข๐จ๐ง: Building automated, scalable workflows using Azure Data Factory (ADF). โšก ๐ƒ๐š๐ญ๐š ๐๐ซ๐จ๐œ๐ž๐ฌ๐ฌ๐ข๐ง๐ : High-performance transformation and complex logic implementation using Azure Databricks and PySpark. โ„๏ธ ๐–๐š๐ซ๐ž๐ก๐จ๐ฎ๐ฌ๐ข๐ง๐ : Managing cloud-native schemas, data loading, and query optimization in Snowflake. โœ… ๐•๐š๐ฅ๐ข๐๐š๐ญ๐ข๐จ๐ง & ๐๐€: Automated ETL testing, Data Integrity Checks, and LLM Output Validation to ensure "Zero-Defect" delivery. ๐Ÿ“Š ๐€๐ง๐š๐ฅ๐ฒ๐ญ๐ข๐œ๐ฌ: Enabling business intelligence through Power BI and Tableau. โ€‹๐Ÿ† ๐‘๐ž๐œ๐ž๐ง๐ญ ๐–๐ข๐ง: Led the engineering and validation of critical ETL and LLM workflows at HCLTech, ensuring safe, reliable, and high-quality data delivery for global enterprise clients. โ€‹Ready to solve your high-impact data challenges. Let's connect! โ€‹#LLM #ETL #DataEngineering #BusinessIntelligence #PowerBI #PromptEngineering #AIValidation #ETL #SQL #Tableau

Experience

5 yrs 6 mos
Total Experience
2 yrs 8 mos
Average Tenure
2 mos
Current Experience

Palnar

2 roles

Senior Quality Assurance Engineer

Mar 2026 โ€“ Present ยท 2 mos

Senior Quality Assurance Engineer

Mar 2026 โ€“ Present ยท 2 mos

Hcltech

2 roles

Software Engineer

Oct 2024 โ€“ Mar 2026 ยท 1 yr 5 mos ยท Noida, Uttar Pradesh, India

Management Information Systems (MIS)ETL TestingData Engineering

Software Engineer

Feb 2022 โ€“ Sep 2024 ยท 2 yrs 7 mos ยท Noida, Uttar Pradesh, India

ETL TestingPython (Programming Language)Data Engineering

Cds infra projects ltd

Assistant Engineer

Oct 2020 โ€“ Feb 2022 ยท 1 yr 4 mos

  • Conducted ETL testing and data warehouse validation for critical infrastructure project datasets.โ€ข
  • Wrote and executed complex SQL queries to validate transformed and loaded data.โ€ข
  • Created Tableau and Power BI dashboards for QA metrics and data governance insights.โ€ข
  • Mentored junior QA engineers in ETL test case design, SQL scripting, and defect reporting.
Conducted ETL testingWrote and executed complex SQL queriesCreated Tableau and Power BI dashboardsMentored junior QA engineersETL TestingData Visualization

Education

Uttarakhand Technical University

Bachelor of Technology โ€” Civil Engineering

Stackforce found 100+ more professionals with Etl Testing & Data Engineering

Explore similar profiles based on matching skills and experience

Harshit Bansal

Harshit Bansal

Data Engineer

at Barclays

Pune, India3 yrs 9 mos exp
Data EngineeringETL Development
SK

Suresh Kannasani

Associate Principal Engineer

at Nagarro

Hyderabad, India11 yrs 1 mo exp
Charu Shukla

Charu Shukla

Senior Data Scientist

at PayPal

Bengaluru, India7 yrs 8 mos exp
Data ScienceMachine Learning
Manasa Gadapa

Manasa Gadapa

People Analytics

at Meta

Austin, United States12 yrs 6 mos exp
Business IntelligenceData Analytics
Ashish Sherawat

Ashish Sherawat

Professional development

at Career Break

New Delhi, India2 yrs 7 mos exp
Data ScienceMachine Learning
TP

Tathagata Pattanayak

BA-QA Intern

at Workfall

Bhubaneswar, India6 mos exp
Agile MethodologiesManual Testing
Manish Joshi

Manish Joshi

Senior Data Engineer

at 66degrees

Pune, India6 yrs 7 mos exp
Google Cloud Platform (GCP)Data Engineering
SG

Sayantan Ghanta

HR Business Partner(MFG)

at Tata Consultancy Services

Kolkata, India4 yrs 11 mos exp
Human Resources Information Systems (HRIS)Strategic Human Resource Planning