Quality Assurance Engineer

A leading entertainment organization is seeking a QA Engineer to ensure the quality of data in their relational databases and data lake.

Responsibilities:

• Build and maintain a QA process framework.
• Design a data governance ETL framework.
• Profile and understand various data sources, including structured and unstructured data.
• Write complex SQL queries to test ETL functionalities.
• Test dashboards, scorecards, and reports.
• Analyze existing code in ETL tools, stored procedures, and database views.
• Collaborate with stakeholders to document source metadata and enhance existing documentation.
• Create and execute test cases to ensure data quality, including master data.
• Document and validate functional requirements and mapping documents.
• Lead automation testing efforts with business and technology teams.
• Write SQL/Python/Bash scripts to analyze data.
• Conduct source-to-target testing and validation.

Requirements:

• 3+ years of QA/engineering experience in a data warehouse environment, including ETL components.
• 3+ years of hands-on experience testing ETL processes.
• 3+ years of experience writing complex SQL queries and performing backend database validations.
• Experience testing business intelligence reports (Tableau, Quick Sight, etc.).
• Advanced SQL skills (nested queries, complex joins, analytic functions) required.
• Proficiency in programming languages for test scripting (Python preferred).
• Experience with data warehouses (Teradata, Snowflake, Redshift, Oracle).
• Familiarity with ETL tools (Talend, Informatica, DataStage).
• Experience with data quality tools (ETL Validator, Collibra).
• Prior experience in data/platform migration projects.

U.S. Citizens or Green Card Holders only