Rajappa gari kalpana

Rajappa gari kalpana

ETL Tester
India
Kannada, Telugu, English
Full-time Hybrid

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 …

Experience

ETL Tester, Big Data Tester & Automation

INFOSYS · Ajnala , Karnataka , India
Sep 2021 - Present · 5 years 1 month

<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

Infosys Limitied
Duration : 03-Jan-2022 - 09-Sep-2026

<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>

Certifications

DATA ASSURANCE PROFESSIONAL

Indian Institute of Technology Hyderabad, India · Bengaluru Urban , Karnataka , India · 2026

Skills

ETL Testing Data Pipeline Validation Web Automation System Integration Testing Big Data Testing DWH Testing BI Report Testing SQL PySpark Python Tableau Power BI SSIS Azure Data Factory Azure Data Lake Oracle Redshift SQL Server Pytest TFS ADO Squids JIRA MAC OS Windows UNIX Informatica Workflow Manager Workflow Monitor Data Warehousing Star Schema Snowflake Schema Fact Table Dimension Table Agile Scrum SDLC ChatGPT Microsoft Copilot
Report this Profile?