About
ETL/Data Warehouse Tester with 4+ years of experience validating end to end ETL processes, Source to Target mappings and business rules across SQL Server and Oracle environments. Skilled in writing complex SQL queries for data validation, reconciliation and Fact and Dimension table testing with strong knowledge of Star and Snowflake schemas. Proficient in HP ALM, Agile, SDLC/STLC, test case design and count validations. Known for analytical thinking, accuracy and delivering high quality data validation with working knowledge of UNIX commands.
Skills & Expertise (15)
Work Experience
Analyst (ETL Testing)
SourceHOV
Oct 2021 - May 2024
Tested ETL workflows that processed HCFA, UB and Dental claims extracted from Oracle transactional systems. Validated Source to Target Mapping to ensure data is transformed and loaded correctly into staging and warehouse layers. Wrote SQL queries to check claim records, member or provider information and transformation rules. Performed data quality checks, count checks, duplicate checks and verified Fact and Dimension tables. Executed ETL test cases in HP ALM and documented results. Logged and tracked defects in HP ALM and JIRA, supported developers during fix validation. Attended Agile stand ups and provided test progress updates.
Test Engineer
Ilink System and Digital Solutions
Jun 2024 - Feb 2026
Performed end-to-end ETL testing for patient billing and revenue data. Validated source-to-target mappings between hospital billing system and enterprise data warehouse. Wrote complex SQL queries to validate revenue calculations, payment postings and outstanding balances. Conducted reconciliation testing between source billing reports and warehouse revenue reports. Validated incremental and full data loads in staging and fact tables. Executed regression and integration testing during monthly release cycles. Logged defects in Jira and worked closely with ETL developers for issue resolution. Participated in UAT support and performed post-production data validation. Supported production data monitoring and handled data discrepancy analysis.
Education
B.E in Electronics and Communication Engineering - Rajalakshmi Institute of Technology
2016 - 2020 · Afghanistan
