Strong SQL (Complex Joins, CTEs, Window Functions, Stored Procedures, Data Validation)

Data Warehousing Concepts

ETL Testing & Data Migration Testing

Data Quality & Data Reconciliation Testing

Unix/Linux Commands

Hadoop/Hive/HDFS

Cloud Data Validation (GCP/AWS)

BI Reporting Validation (Power BI / Tableau / QlikView)

Solid expertise in SQL (Joins, Subqueries, CTEs, Window Functions, Aggregations, Stored Procedures, Data Validation).

Strong understanding of Data Warehousing concepts (Facts, Dimensions, SCD Type 1 & Type 2, Star Schema, Snowflake Schema).

Hands-on experience in ETL Testing, Data Migration Testing, Data Reconciliation, and Data Quality Testing.

Good understanding of Source-to-Target Mapping (STTM) validation.

Experience with Unix/Linux commands and shell basics.

Hands-on experience with Hadoop ecosystem (Hive, HDFS).

Exposure to Cloud Data Platforms: GCP: BigQuery, GCS, AWS: S3, Athena, Redshift

Knowledge of Teradata, Oracle, SQL Server, or similar enterprise databases.

Experience validating Power BI, Tableau, or QlikView reports and dashboards.





Experience with defect management tools such as JIRA and Agile methodologies.

Responsibility

Perform ETL Testing, Data Warehouse Testing, Data Migration Testing, and Data Validation.

Validate Source-to-Target Mapping (STTM) documents and transformation rules.

Execute data reconciliation, completeness, accuracy, consistency, and integrity checks across multiple source and target systems.

Validate data pipelines across Hadoop, Hive, HDFS, GCP (BigQuery, GCS), and AWS (S3, Athena, Redshift).

Perform backend data validation using complex SQL queries.

Validate files and datasets across Unix/Linux, HDFS, GCS, S3, and relational databases.

Perform BI dashboard and report validation using Power BI, Tableau, or QlikView.

Execute Data Quality Testing, identify data anomalies, duplicates, missing records, and transformation issues.

Analyze defects, perform Root Cause Analysis (RCA), and coordinate with Data Engineering teams for resolution.

Participate in Agile ceremonies, sprint planning, backlog grooming, and release validation.

📌 ETL Lead (Melbourne)
🏢 HCLTech
📍 Melbourne