Should have in-depth understanding of Big Query architecture, table partitioning, clustering, best practices, type of tables, best practices, Data fabric etc.
Strong SQL skills
Performance tuning of Big Query SQL scripts
Experience in implementing physical data model (Databases, Schema Tables, Views & Virtual Data Warehouse)
Implementing ETL jobs using Big query, Experience on any ETL tools, CDF, Cloud Composer airflow, DataProc, git, bitbucket etc.
Load data into Big Query using files or by streaming.
Good understanding of Data Warehouse / Dimension Modelling concepts
Strong Python knowlede
Additional Technical Experience
Migration Experience – SAP to Google Big Query
Hands-on experience on any scripting knowledge like Python/Java