Description

Validate large-scale data migrations and ensure data integrity across complex warehouse environments.

Responsibilities

• Validate historical and incremental load data to maintain strict data integrity.
• Perform data profiling, quality analysis, and reconciliation across various data permutations.
• Execute, read, and debug batch processes to monitor data flows.
• Write and tune SQL queries to extract data for test case comparisons.
• Collaborate with Scrum teams to deliver effective testing efforts within project timelines.

Required Skills

• 4+ years of experience in ETL, Data Warehousing, and SQL.
• Strong expertise in database-driven testing and validating millions of records using Oracle or DB2.
• Advanced SQL skills for data extraction, analysis, and query tuning.
• Experience with Unix and basic command-line operations.
• Knowledge of Snowflake architecture, including its different layers and behaviors.
• Background in reporting and analytics testing.
• Ability to analyze overall system architecture to identify testing requirements.

Preferred Skills

• Experience with .NET environments.

Key Skills

Education

Bachelor's degree