ABHITEJU Y
Fremont,CA
Summary
- Senior ETL Tester with 7+ years of experience in Data Warehouse, ETL, Database, and Business Intelligence testing across Banking, Healthcare, and Retail domains.
- Extensive experience in validating ETL processes, source-to-target mapping, data migration, data reconciliation, and data quality testing.
- Strong expertise in writing complex SQL queries for backend database validation and performing end-to-end ETL testing.
- Experienced in Functional, System Integration, Regression, End-to-End, Smoke, Sanity, and User Acceptance Testing (UAT).
- Good understanding of Data Warehouse concepts including Star Schema, Snowflake Schema, Fact and Dimension tables, OLTP and OLAP.
- Hands-on experience validating ETL workflows involving staging, ODS, Data Warehouse, and Data Mart layers.
- Expertise in identifying data inconsistencies, validating business rules, and ensuring data integrity across multiple databases.
- Experience in Agile Scrum methodology with active participation in Sprint Planning, Daily Stand-ups, Sprint Reviews, and Retrospectives.
- Strong experience using JIRA, HP ALM, and Azure DevOps for defect management and test tracking.
- Worked closely with Business Analysts, ETL Developers, Data Architects, and Product Owners throughout the SDLC and STLC.
- Excellent analytical, problem-solving, communication, and documentation skills.
- Ability to work independently as well as collaboratively in cross-functional teams while meeting project deadlines.
Overview
9
9
years of professional experience
Work History
Senior ETL Tester
Persistent Systems
Santa Clara, CA
06.2022 - Current
- Reviewed BRD, FSD, and ETL Mapping documents to understand business requirements.
- Prepared Test Strategy, Test Plan, Test Scenarios, Test Cases, and RTM.
- Performed end-to-end ETL testing across multiple environments.
- Validated source-to-target mappings using SQL queries.
- Verified transformation rules, joins, lookup, aggregation, router, and expression logic.
- Validated data loading into staging, ODS, Data Warehouse, and reporting tables.
- Performed reconciliation testing between source and target systems.
- Executed Full Load and Incremental Load testing.
- Tested Slowly Changing Dimensions (SCD Type 1 & Type 2).
- Verified surrogate key generation and referential integrity.
- Performed backend database validation using Oracle SQL.
- Validated batch execution and workflow dependencies.
- Participated in defect triage meetings.
- Logged and tracked defects using JIRA.
- Coordinated with ETL developers to resolve defects.
- Supported production deployment and post-production validation.
- Mentored junior testers and reviewed SQL queries.
- Participated in Agile ceremonies and sprint planning.
ETL Tester
Optoma Technology
Fremont, CA
10.2019 - 05.2022
- Analyzed ETL mapping documents and business requirements.
- Designed detailed ETL test cases and executed test scenarios.
- Validated source-to-target data transformation using SQL.
- Tested ETL jobs involving healthcare claims and member data.
- Performed data migration and reconciliation testing.
- Verified duplicate records, NULL values, and business rule validations.
- Executed regression, integration, and system testing.
- Created SQL scripts for backend validation.
- Reviewed ETL workflow execution logs.
- Validated data accuracy across multiple databases.
- Supported User Acceptance Testing (UAT).
- Prepared defect reports and test execution summaries.
- Worked with developers to resolve production issues.
- Participated in release validation activities.
ETL Tester
Walmart
Sunnyvale, CA
05.2017 - 08.2019
- Reviewed business requirements and ETL specifications.
- Created test scenarios, test cases, and SQL validation scripts.
- Validated source, staging, warehouse, and reporting data.
- Verified transformation logic and business rules.
- Executed ETL workflows and monitored batch processing.
- Performed backend database testing using SQL.
- Conducted Smoke, Functional, Regression, and Integration testing.
- Validated sales, inventory, and customer data.
- Performed data quality and reconciliation testing.
- Logged defects using HP ALM and verified fixes.
- Supported deployment validation and production testing.
- Prepared daily status reports and test summary reports.
- Collaborated with Business Analysts and ETL Developers throughout the project lifecycle.
Education
Master of Science - Information Technology Management
Campbellsville University
Campbellsville, KY01-2017
Skills
- Informatica PowerCenter
- IBM DataStage
- Talend
- SSIS
- Oracle
- SQL Server
- Teradata
- PostgreSQL
- MySQL
- SQL
- PL/SQL
- ETL Testing
- Data Warehouse Testing
- Data Migration Testing
- Source-to-Target Validation
- Data Reconciliation
- Data Quality Testing
- Metadata Validation
- OLTP & OLAP
- Star Schema
- Snowflake Schema
- Functional Testing
- Regression Testing
- System Testing
- Integration Testing
- Smoke Testing
- Sanity Testing
- End-to-End Testing
- User Acceptance Testing (UAT)
- JIRA
- HP ALM / Quality Center
- Azure DevOps
- Tableau
- Power BI
- Agile Scrum
- Waterfall
- SDLC
- STLC
- Git
Timeline
Senior ETL Tester
Persistent Systems
06.2022 - Current
ETL Tester
Optoma Technology
10.2019 - 05.2022
ETL Tester
Walmart
05.2017 - 08.2019
Master of Science - Information Technology Management
Campbellsville University