About Me
Senior ETL Tester with 10 years of IT experience, including 7+ years in ETL testing, Data Warehouse testing, Snowflake testing and data migration testing. Experienced in SQL-based source-to-target validation, data reconc…
Senior ETL Tester with 10 years of IT experience, including 7+ years in ETL testing, Data Warehouse testing, Snowflake testing and data migration testing. Experienced in SQL-based source-to-target validation, data reconciliation, data quality checks, transformation and business-rule validation, record-count verification and reporting validation. Skilled in functional, integration, regression, system integration testing (SIT), user acceptance testing (UAT) and end-to-end testing across Capital Markets, Banking/Investment Management and Telecom domains. Experienced in test planning, test execution, defect management and Agile/Scrum.
Experience
Senior ETL Tester
<p>Validated data across Snowflake Pre-Stage, Stage, reporting tables and Tableau reporting layers to verify data completeness and accuracy.</p><p> Performed SQL-based source-to-target validation and reconciliation for TCA datasets.</p><p> Verified data transformations, business rules and reporting calculations across Snowflake layers.</p><p> Executed record-count verification, data-quality checks and SQL-based defect analysis.</p><p> Reconciled Tableau reports against source data and collaborated with FlexTrade, Axway and data engineering teams to investigate and resolve defects.</p>
Senior Software Test Engineer / DWH-BI Test Engineer / Test Architect
<p>Led end-to-end testing activities for large-scale ETL and Data Warehouse solutions.</p><p> Designed and executed ETL, regression, reconciliation, sanity and end-to-end test scenarios.</p><p> Performed SQL-based data validation across Oracle and Snowflake, including reconciliation of large data volumes.</p><p> Managed test planning, test strategy, test execution tracking and defect management.</p><p> Collaborated with Business Analysts, Architects, Developers and Product Owners to investigate and resolve defects.</p><p> Managed Severity 1 and Severity 2 production defects and coordinated timely resolution.</p><p> Developed and validated Power BI dashboards for sprint tracking and delivery monitoring.</p><p> Used GenAI tools to support test-case generation, test strategy preparation and QA documentation; participated in Agile Scrum ceremonies.</p>
Technical & Business Operations Analyst
<p>Managed telecom billing and revenue-related batch executions and monitored production processes against SLAs.</p><p> Performed CRUD operations and investigated payment and backlog-processing issues.</p><p> Executed end-of-month activities and supported release deployments and post-deployment validation.</p><p> Monitored application health, CPU and memory utilization, and file systems using monitoring tools.</p><p> Led bridge calls for P1/P2 incidents and coordinated issue resolution with support, infrastructure and application teams.</p>
PROJECTS
Temasek – OEMS Migration (FlexTrade TCA to Snowflake) | Capital Market
<p>Migration of Transaction Cost Analysis (TCA) reporting from TradingScreen (TSI) to FlexTrade (FlexTCA), using Axway, AWS S3, Snowpipe, Snowflake and Tableau. • Validated data across Snowflake Pre-Stage, Stage, reporting tables and Tableau reporting layers to verify data completeness and accuracy. • Performed SQL-based source-to-target validation and reconciliation for TCA datasets. • Verified data transformations, business rules and reporting calculations across Snowflake layers. • Executed record-count verification, data-quality checks and SQL-based defect analysis. • Reconciled Tableau reports against source data and collaborated with FlexTrade, Axway and data engineering teams to investigate and resolve defects. Environment: Snowflake, Snowpipe, SQL, AWS S3, Axway, Tableau, Jira, Confluence</p>