About Me
Having 4.7 years of experience in specializing in ETL/data pipeline validation, web automation, and system integration testing. Experience in analyzing BRS and translate them to test cases. Currently working on Big data …
Having 4.7 years of experience in specializing in ETL/data pipeline validation, web automation, and system integration testing. Experience in analyzing BRS and translate them to test cases. Currently working on Big data testing, ETL/DWH Testing and BI Reporting Testing. Good knowledge on Data warehouse concepts like Star schema, Snow-flake schema, Fact table, Dimension table etc. Hands on experience in writing Pyspark Queries & SQL Queries. Having experience on Tableau and Power BI Reports development. Having experience in BI Report testing. Developed the DWH using SSIS. Having experience on Azure Data Factories & Lake, Oracle database database. Having experience on automating the scripts using python or pyspark. Extensively used Workflow manager, Workflow monitor in Informatica ETL tool Good exposure to UNIX. Experience using ChatGPT and Microsoft Copilot to improve test case creation, SQL query generation, PySpark scripting, and test data preparation. Proficient in leveraging AI-assisted tools for debugging, query optimization, automation scripting, and productivity enhancement. Hands-on experience in creating SQL, Python, and PySpark scripts with AI assistance to accelerate ETL and Big Data testing activities. Familiar with using AI tools for documentation, defect analysis, and test scenario generation. Experience in analyzing business specifications and developing Test cases, Test scripts reviewing and executing the same. A self-motivated individual with good analytical and problem-solving skills.
Experience
ETL Tester, Big Data Tester & Automation
<p>Analyzed Business Requirement Documents (BRD), Functional Requirement Specifications (FRS), and Source-to-Target Mapping (STM) documents.</p><p> Prepared comprehensive Test Plans, Test Scenarios, Test Cases, and Test Data for ETL and Data Pipeline testing.</p><p> Validated data extraction from multiple source systems into staging and target databases.</p><p> Performed Source-to-Target Data Validation to ensure accurate data movement across the ETL pipeline.</p><p> Verified business transformation rules implemented during the ETL process.</p><p> Executed SQL queries to validate data accuracy, completeness, consistency, and integrity.</p><p> Conducted Data Quality Testing by validating null values, duplicates, missing records, invalid formats, and data mismatches.</p><p> Performed ETL Functional Testing, Regression Testing, System Testing, Integration Testing, and User Acceptance Testing (UAT) support.</p><p> Validated incremental loads, full loads, and Change Data Capture (CDC) processes.</p><p> Tested data pipeline scheduling, workflow execution, dependencies, and job monitoring.</p><p> Verified ETL job execution logs and analyzed failures to identify root causes.</p><p> Performed reconciliation testing between source and target systems.</p><p> Logged, tracked, and verified defects using JIRA/Azure DevOps and worked closely with developers for timely resolution.</p><p> Participated in Agile Scrum ceremonies including Sprint Planning, Daily Stand-ups, Sprint Reviews, and Retrospectives.</p><p> Collaborated with Business Analysts, ETL Developers, Data Engineers, and Product Owners throughout the Software Development Life Cycle (SDLC).</p><p> Validated BI reports and dashboards by comparing report data with backend database results.</p><p> Supported production deployments and performed post-deployment validation to ensure data accuracy.</p><p> Prepared Test Execution Reports, Defect Reports, and Test Summary Reports.</p><p> Ensured compliance with data governance, quality standards, and project documentation.</p>
PROJECTS
BIIPCLOUD
<p> Analyzed Business Requirement Documents (BRD), Functional Requirement Specifications </p><p>(FRS), and Source-to-Target Mapping (STM) documents. </p><p> Prepared comprehensive Test Plans, Test Scenarios, Test Cases, and Test Data for ETL and </p><p>Data Pipeline testing.</p><p> Validated data extraction from multiple source systems into staging and target databases.</p><p> Used Azure Databricks notebooks to query and validate target data using SQL and PySpark, </p><p>ensuring data accuracy and successful ETL pipeline execution.</p><p> Performed Source-to-Target Data Validation to ensure accurate data movement across the ETL </p><p>pipeline. </p><p> Verified business transformation rules implemented during the ETL process. </p><p> Executed SQL queries to validate data accuracy, completeness, consistency, and integrity. </p><p> Conducted Data Quality Testing by validating null values, duplicates, missing records, invalid </p><p>formats, and data mismatches. </p><p> Performed ETL Functional Testing, Regression Testing, System Testing, Integration Testing, </p><p>and User Acceptance Testing (UAT) support. </p>