QA Tester - Data Pipeline

About the role

Project Enterprise Data Lake Modernization - Oracle CTM/ADW to Kraken SaaS Migration Experience 5+ years in data/ETL/DWH testing or migration validation The QA Tester supports the QA Lead by executing detailed data-validation, reconciliation, regression, defect-management, UAT, production-readiness, and downstream data-certification activities for Phase 1 and Phase 2 of the Snowflake and dbt-based Oracle CTM/ADW to Kraken migration.

What you'll do

• Execute approved functional, data, schema, integration, regression, negative, and reconciliation test cases across Bronze ingestion, Silver/Gold dbt models
• Perform source-to-target validation using approved mapping documents and Data Contracts, including field-level transformations, data types, nulls, duplicates, keys
• Compare Oracle CTM and Kraken-sourced data using SQL-based row counts, column checks, aggregate totals, usage totals, billing balances, and exception reports
• Validate Kraken insert, update, and delete events; confirm append-only Bronze capture and latest-active-record/overwrite behavior in Silver and Gold
• Execute coexistence tests for migrated and non-migrated cohorts, including customer/account routing, identifier cross-reference tables, legacy/new data availability

What you need

• 5–9 yrs of experience
• ETL
• Test cases
• SQL
• Python
• Regression testing
• Bug tracking
• B.Sc or B.Tech or B.E. or BCA

Good to have

• Reconciliation
• dbt
• Data warehousing
• Snowflake
• Tableau