QA Lead - Data Pipeline & Reconciliation

About the role

Project Enterprise Data Lake Modernization - Oracle CTM/ADW to Kraken SaaS Migration Experience 10+ years in data/ETL/DWH testing and migration validation The QA Lead owns end-to-end quality strategy, data validation, parallel-run reconciliation, defect governance, and downstream data certification for the Oracle CTM/ADW to Kraken migration on Snowflake and dbt.

What you'll do

• Define and own the master test strategy, test plan, entry/exit criteria, traceability, test data approach, reconciliation scenarios, regression scope
• Review source-to-target mappings, Data Contracts, business rules, identifier cross-reference logic, and record-key strategy; translate them into functional, data
• Lead Oracle-versus-Kraken parallel-run validation across Snowflake Bronze, Silver, Gold, coexistence tables, control tables, and consumer-facing semantic views
• Define tests for Kraken inserts, updates, and deletes; confirm append-only Bronze history and latest-active-record/overwrite behavior in Silver and Gold
• Validate cohort/customer routing through central control and mapping tables; ensure consumer views return the correct C2M or Kraken records without duplication

What you need

• 10–18 yrs of experience
• ETL
• Reconciliation
• Test cases
• Bug tracking
• SQL
• Python
• B.Sc or B.Tech or B.E. or BCA

Good to have

• Tableau
• Databricks
• Snowflake
• dbt
• Data warehousing