Manual Data Tester - Senior Engineer

Job Description

Data & Platform Testing
. Analyze user stories, data models, DBT transformation logic, and mapping documents to build comprehensive data test cases.
. Execute end-to-end ETL/Data pipeline testing across multiple layers-raw, staging, curated, and analytics layers.
. Validate data transformations implemented in DBT models, ensuring correctness of joins, aggregations, schemas, and business rules.
. Perform detailed data validation using SQL , SQL Server, and Databricks environments.
. Test data ingestion workflows built on AWS services such as S3, Glue, Lambda, Step Functions, etc.
. Conduct API testing for data ingestion, extraction, and system integrations.
. Validate BI dashboards and metrics on Sigma, ensuring accuracy, filters, and data freshness.
Functional & Web Testing
. Test web-based components (if any) that interact with the data platform such as admin portals, configuration panels, or data access layers.
Defect Management & Collaboration
. Identify, reproduce, and document defects using Jira, ensuring proper data-level evidence.
. Collaborate closely with Data Engineers, DBT developers, and Cloud teams to understand transformations, data flows, and architecture impacts.
. Participate actively in Agile ceremonies-stand-ups, grooming, sprint planning, retrospectives.
Quality Process & Contribution
. Contribute to data quality processes-validation rules, sampling methodologies, reconciliation checks, regression strategies.
. Continuously improve test artifacts, test data, and quality coverage.
. Stay current with modern data engineering and cloud testing practices.

Skills:
. Strong SQL skills with ability to write complex joins, aggregations, window functions, and data comparisons.
. Experience testing data warehouses or data lakes using or Databricks.
. Understanding of DBT (models, seeds, snapshots, lineage).
. Exposure to AWS services relevant to data workflows.
. Experience in API testing (Postman, Swagger, REST/JSON validation).
. Familiarity with Gherkin and BDD-style test documentation.
. Test management experience using Zephyr, Jira.
. Strong experience in creating test plans, test scenarios, regression packs.
. Excellent communication and coordination skills.

Mandatory Competencies