Quality Assurance (QA Engineer)

Mattel, Inc.; Hyderabad; On-site; INR 600,000 - 1,000,000; Full time

Job summary

Mattel, Inc. in Hyderabad is hiring a QA analyst for consumer data. The role involves validating consumer data, ensuring accuracy in metrics displayed in dashboards, and testing data pipelines. Qualified candidates will have 2–5 years of experience in data QA, strong SQL skills, and familiarity with BI tools like Tableau. Join us in creating innovative products and experiences that inspire audiences and develop children through play.

Qualifications

• 2–5 years of QA experience focused on consumer data, analytics, or business intelligence.
• Strong proficiency in SQL for validating consumer-level datasets.
• Hands-on experience testing data pipelines within modern data architectures.

Responsibilities

• Validate consumer identity, profile, and transactional data across the data platform.
• Perform end-to-end dataset comparisons for accuracy.
• Reconcile consumer metrics displayed in dashboards against source tables.

Skills

SQL proficiency

Analytical skills

Attention to detail

Testing data pipelines

Consumer data models

Tools

JIRA

Tableau

ThoughtSpot

Job description

CREATIVITY IS OUR SUPERPOWER. It’s our heritage and it’s also our future. Because we don’t just make toys. We create innovative products and experiences that inspire fans, entertain audiences and develop children through play. Mattel is at its best when every member of our team feels respected, included, and heard—when everyone can show up as themselves and do their best work every day. We value and share an infinite range of ideas and voices that evolve and broaden our perspectives with a reach that extends into all our brands, partners, and suppliers.

Key Responsibilities

• Validate consumer identity, profile, behavioral, and transactional data across all layers of the data platform, from source systems through curated analytics datasets.
• Perform end-to-end dataset comparisons to ensure consumer-level records, counts, and attributes remain consistent as data moves through ingestion and transformation layers.
• Reconcile consumer metrics and KPIs displayed in Tableau and ThoughtSpot dashboards against upstream source and warehouse tables.
• Test ETL/ELT pipelines that ingest and transform consumer data, including events, purchases, interactions, and engagement signals.
• Validate business logic related to consumer attribution, segmentation, and aggregation rules used in analytics.
• Conduct row-level, aggregate-level, and trend-based testing to identify issues such as duplication, data loss, mis-joins, or incorrect consumer rollups.
• Partner with data engineers and analytics teams to investigate and resolve consumer data quality issues.
• Create reusable test plans, validation checklists, and reconciliation queries for consumer analytics datasets.
• Document test cases, validation results, and QA approvals for consumer data releases.
• Participate in Agile ceremonies, including sprint planning, backlog refinement, and retrospectives.
• Contribute to the continuous improvement of consumer data QA standards, validation frameworks, and automation coverage.

Required Qualifications

• 2–5 years of QA experience focused on consumer data, analytics, or business intelligence.
• Strong proficiency in SQL for validating consumer-level datasets (e.g., Google BigQuery or similar platforms).
• Hands‑on experience testing data pipelines within modern data lake or warehouse architectures.
• Proven experience validating consumer-focused dashboards and metrics in BI tools.
• Solid understanding of consumer data models, including identity resolution, event data, and transactional facts.
• Experience using defect tracking and test management tools such as JIRA.
• Strong analytical and troubleshooting skills with exceptional attention to detail.
• Ability to clearly communicate consumer data issues to both technical and business stakeholders.

Preferred Qualifications

• Experience testing analytics in Tableau, ThoughtSpot, Looker, or similar BI platforms.
• Familiarity with consumer identity, event tracking, and behavioral data models.
• Exposure to data quality frameworks, reconciliation processes, or automated data validation.
• Experience with CI/CD pipelines and version control (e.g., Git) in analytics environments.
• Understanding of consumer data governance, lineage, and metadata practices.
• Knowledge of privacy and compliance considerations related to consumer data (GDPR, CCPA).
• Experience with automation tools such as Postman, Pytest, or SQL-based testing frameworks.

Mattel is an Equal Opportunity Employer where we want you to bring your authentic self to work every day. We welcome all job seekers, and all applicants will receive consideration for employment.