Strong expertise in complex SQL queries Hands-on experience with: Joins, Window Functions, Subqueries Data comparison and reconciliation techniques. Experience with databases like: SQL Server / Oracle / PostgreSQL / MySQLETL validation o Data staging and warehouse testing o Slowly Changing Dimensions (SCD Type 1, 2, 3) o Data warehouse concepts (Fact & Dimension tables)
Good-to-Have · Knowledge of cloud platforms: o AWS (Redshift, S3, Glue) OR o Azure (ADF, Synapse) OR o GCP (BigQuery, Dataflow) · Experience with PySpark / Python for data validation