Total Yrs of Exp - 7+ Yrs

Relv Yrs of Exp - 7+ Yrs

Mandatory Skills - End to End functional knowledge of the data pipeline/transformation implementation that the candidate has done, should understand the purpose/KPIs for which data transformation was done.

Expert in SQL – can do data analysis and investigation using Sql queries Implementation Knowledge Advance Sql functions like – Regular Expressions, Aggregation, Pivoting, Ranking, Deduplication etc. BigQuery and BigQuery Transformation(using Stored Procedures) Data modelling concepts – Star & Snowflake schemas, Fact & Dimension table, Joins, Cardinality etc GCP Services related to data pipelines like – Workflow, Cloud Composer, Cloud Schedular, Cloud Storage etc.

Nice to have: • Understanding of CI/CD & related tools – Git & Terraform • Other GCP Services like – Dataflow, Cloud Build, Pub/Sub, Cloud Functions, Cloud Run, Cloud Workstation etc • BigQuery Performance tuning • Python based API development exp • Spark development exp.

Detailed JD -

• End to End functional knowledge of the data pipeline/transformation implementation that the candidate has done, should understand the purpose/KPIs for which data transformation was done.

• Expert in SQL – can do data analysis and investigation using Sql queries

• Implementation Knowledge Advance Sql functions like – Regular Expressions, Aggregation, Pivoting, Ranking, Deduplication etc.

• BigQuery and BigQuery Transformation (using Stored Procedures)

• Data modelling concepts – Star & Snowflake schemas, Fact & Dimension table, Joins, Cardinality etc

• GCP Services related to data pipelines like – Workflow, Cloud Composer, Cloud Schedular, Cloud Storage etc.