N

Nikita Yadav

Operations Associate

Pune, Maharashtra, India4 yrs 11 mos experience
Highly Stable

Key Highlights

  • 3+ years of ETL testing experience in healthcare.
  • Designed over 500 test cases for ETL workflows.
  • Automated processes, reducing manual effort by 50%.
Stackforce AI infers this person is a Healthcare ETL Testing Specialist with a focus on data integrity and automation.

Contact

Skills

Core Skills

Etl TestingSqlData ProfilingTest AutomationData Validation

Other Skills

Agile MethodologiesAppiumAutoCADAzure Data FactoryAzure Data LakeAzure SQLBMC Control-MCI/CDClient RelationsData WarehousingDatabase TestingETL ToolsExtract, Transform, Load (ETL)Functional TestingGitHub

About

I’m an ETL Tester with 3+ years of hands-on experience in validating data quality, designing test strategies, and thoroughly testing end-to-end Extract, Transform, Load (ETL) processes in complex data warehousing environments—especially in healthcare projects. Having worked at Cognizant across three major healthcare initiatives, my core mission has been to ensure data accuracy, eliminate redundancy, validate ETL logic, and develop/execute robust test cases using JIRA. 🛠 My Technical Toolbox Databases: skilled in SQL, Microsoft SQL Server, Snowflake, and SQL Developer ETL & Orchestration Tools: Skilled with BMC Control‑M, ICEDQ, and Putty/DBeaver for database interfacing Cloud / Platform: Experienced with AWS services and Snowflake cloud data warehouse Test & Defect Management: Proficient in HP ALM, JIRA, and VersionOne Testing Types: Regression, System, Release, SCD, SIT, and end-to-end validation. Data Profiling & Test Design: Expert at writing test scenarios, creating test cases, and profiling data to identify anomalies. 🚀 What I’m Looking For I thrive on improving end-to-end ETL pipelines across multi-terabyte data environments. If your team values rigorous data validation, cross-functional collaboration, and automation-first test strategies, I’d love to connect. Let's ensure your ETL processes are not just functional—but rock-solid. 📬 Let’s Connect Send me a message to talk about how I can strengthen your ETL QA workflows, validate complex healthcare data flows, or build test automation for pipeline confidence. Let’s turn data into reliable decisions—together! 🔗 Quick Snapshot Role: ETL Tester | Experience: 3+ years | Domain: Healthcare Skills: SQL • Snowflake • Microsoft SQL server • SQL Developer • Control‑M • ICEDQ • HP ALM • JIRA • AWS Testing Expertise: Data profiling • SCD • Regression • SIT • System testing • Release testing

Experience

Infosys

Quality Engineering Analyst

Sep 2025Present · 6 mos · Indore, Madhya Pradesh, India · Hybrid

Cognizant

ETL Tester

Feb 2022Aug 2025 · 3 yrs 6 mos · Hybrid

  • ETL Test Design & Validation
  • Designed and executed over 500 comprehensive test cases to validate ETL workflows—ranging from simple extracts to multi‑stage transformations and loads—across diverse systems, ensuring data integrity and pipeline accuracy end to end.
  • Validated critical transformation logic, verifying business and mapping rules, and ensuring compliance with functional requirements.
  • Data Reconciliation & Profiling
  • Engineered custom SQL-based reconciliation processes that reduced data mismatch rates by approximately 40%, boosting testing efficiency and reliability.
  • Developed a reusable profiling script library to identify nulls, duplicates, inconsistent formats, and unexpected data ranges—automating validation steps and accelerating issue detection.
  • Schema Validation & Data Modeling
  • Conducted thorough schema validation to ensure source-to-target alignment—covering column names, data types, constraints, and metadata integrity.
  • Actively flagged inconsistencies, ensuring they were resolved prior to production deployment, preventing downstream failures.
  • Test Automation & Efficiency Gains
  • Automated over 30 reconciliation processes using SQL scripts, resulting in a 50% reduction in manual testing effort and improved consistency.
  • Constructed partial data validation frameworks and Python-driven scripts to facilitate early-stage ETL debugging, significantly reducing iteration cycles.
  • Logged and managed 100+ ETL defects in JIRA, prioritizing critical data issues, streamlining sprints, and enhancing sprint-focused defect tracking.
  • Maintained over 95% test coverage via comprehensive documentation in HP ALM, ensuring traceability from requirements to test execution and results.
ETL TestingSQLData ValidationData ProfilingTest AutomationJIRA+1

Asme (the american society of mechanical engineers)

student member

Oct 2018Sep 2019 · 11 mos · United States

Education

University Institute of Technology, RGPV

Bachelor of Technology - BTech

Aug 2018Jun 2022

Stackforce found 100+ more professionals with Etl Testing & Sql

Explore similar profiles based on matching skills and experience