GCP Test Engineer
Experience: 8+ Years
Location: Remote
Employment Type: Contract
Shift: 2:00 PM – 11:00 PM IST
Laptop: Candidate must be able to collect the company laptop from Mumbai / Bangalore / Chennai office locations.
Job Overview
We are looking for an experienced GCP Test Engineer with 8+ years of experience in data testing, ETL validation, cloud data warehouse testing, and data quality assurance. The ideal candidate should have strong hands-on experience validating GCP-based data pipelines using BigQuery, Dataflow, Cloud Composer (Airflow), and Google Cloud Storage (GCS).
Key Responsibilities
Perform end-to-end validation of GCP-based data pipelines involving BigQuery, Dataflow, Cloud Composer, and GCS.
Analyze complex BigQuery SQL queries for source-to-target reconciliation, data validation, and transformation testing.
Validate historical, incremental, batch, and streaming data loads across cloud data warehouse environments.
Perform comprehensive Data Quality Assurance (DQA) checks covering:
Completeness
Accuracy
Consistency
Uniqueness
Freshness




Referential Integrity
Validate Apache Airflow DAGs in Cloud Composer, including dependencies, scheduling, workflow monitoring, and failure analysis.
Perform data validation for Dataflow pipelines and investigate processing anomalies and data discrepancies.
Validate fact and dimensional table loads in BigQuery.
Test surrogate key generation and Slowly Changing Dimensions (SCD) Type 1 and Type 2 implementations.
Develop and execute SQL-based data validation and audit reconciliation frameworks.
Identify, analyze, and troubleshoot data quality issues and perform root cause analysis (RCA).
Collaborate with Data Engineering and QA teams to ensure production data integrity.
Participate in Agile ceremonies, defect triage, release validation, and production deployment verification.
Prepare and maintain test cases, validation scripts, defect reports, and test documentation.
Mandatory Skills
Candidates must have robust hands-

📌 GCP Test Engineer (Chennai)
🏢 MindBrain
📍 Chennai