Nishtha Gupta

About Nishtha Gupta

Believe on the mantra “all code is guilty until proven innocent. Obtained business and system requirements for Data Warehouse conducted document analysis, requirements workshops questionnaires, business process descriptions, business analysis, task. Resourceful and analytical having key competencies such as problem solving and ownership of tasks. 12 years of strong experience in different areas -such as Big Data Testing, ETL Testing on Cloud using Databricks, Azure Datawarehouse Validation,Data Consistency Rules Validation, Azure Synapse BI Report QA, Data Analysis. Data Quality Technical control Framework validation using Databricks and Hive• My key achievement is -Awarded for unearthing Security bugs in White-Hat Facebook security Reward Program. • Professional Big Data QA with 12 years of industry experience who has a keen observation to find valuable insights. • Experience in the Big Data technologies Hadoop, HDFS, Impala,Hive.etc.). Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch. Worked on Data Migration projects (Hive to Azure) Basics of Unix commands. • Identified, designed, and implemented internal QA process : automating manual processes using shell/python scripting. Have build a entire Python solution for the fixed file format and implementation of complex business rule transformation scenarios like joins,filters,conditionals,subqueries,substrings,concatenation.• Performed data analysis and data validation using complex SQL on various sources systems including Oracle.• Acted like a bridge between the dev team and the business SME to clarify the business needs and the provide resolution of the query thatteam.Has Performed Rigorous static testing and verification of High level Designs.mappings.Have communicated the Static defects and Discrepancies at Requirements document level to Development and Data Governance team to ensure circumvention of gaps in requirements.• ETL Tools-Informatica, BODS. Azure Microsoft - Azure Databricks, Azure Data Factory, Spark Sql, Python, ADLS,Azure Synapse Languages- SQL,PL/SQL,Basics of Unix commands,Python • Tools -HP Quality Centre,JIRA, Confluence • Big Data Ecosystem -Hive,Impala,Hbase• RDBMS -SQL DeveloperReporting Tools -Business Objects, Business Explorer

Experience

1. Senior Data Quality Engineer (Data Analytics)

   EPAM Systems

   Aug 2024 — Present · Pune, IN

   Pyspark,python, cloudera data platform,hive, impala, databricks,yarn,airflow

Education

• RMPS,Bareilly

  High School

• Vellore Institute of Technology

  Bachelor's Degree, Bioinformatics

  2007 — 2011

Skills

• Srm Testing
• Hbase
• Data Model Design Analysis
• Quality Assurance
• Software Project Management
• Datawarehouse Testing
• Data Warehousing
• Microsoft Sql Server
• UK Mortgage Applications
• R Programming
• Vendor Invoice Management Testing
• As400 Testing
• Data Analysis
• Hive
• Statistics
• Bods
• Ariba ,Vim Testing
• Hp Quality Center
• Informatica
• Data Profiling
• Oracle
• Requirements Analysis
• Etl Testing
• Hp Qtp
• Hdfs
• Business Objects
• Manual Testing