Snowflake Architect

Full Time City and County of the City of London IT Job Pro UK

URGENT contract Snowflake Architect x2 roles

inside IR35

Duration: 6 months

. Snowflake SQL Writing SQL queries against Snowflake Developing scripts Unix, Python, Scala etc. to do Extract, Load, and Transform data

-Job orchestration (event based and time based)

. Hands-on experience with Snowflake utilities such as SnowSQL, SnowPipe, Python, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored procedures.

. In-depth understanding of Data Warehouse/ODS, ETL concept and modelling structure principles

. Experience in Data warehousing – OLTP, OLAP, Dimensions, Facts, and Data modelling.

. Experience gathering and analyzing system requirements

Experience on EMR,AWS (lambda), Airflow,snowflake

. Snowflake SQL Writing SQL queries against Snowflake Developing scripts Unix, Python, Scala etc. to do Extract, Load, and Transform data

-Job orchestration (event based and time based)

. Hands-on experience with Snowflake utilities such as SnowSQL, SnowPipe, Python, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored procedures.

. In-depth understanding of Data Warehouse/ODS, ETL concept and modelling structure principles

. Experience in Data warehousing – OLTP, OLAP, Dimensions, Facts, and Data modelling.

. Experience gathering and analyzing system requirements

Experience on EMR,AWS (lambda), Airflow,snowflake

Good to Have –

. Good working knowledge of any ETL tool (Informatica and streamsets)

. Good to have familiarity with data visualization tools (Tableau/Power BI)

. Ability to effectively function in a cross team's environment

. Good to have exposure to AWS

T&M Project

Reference ID: Snowflake Architect

Contract length: 6 months

To apply for this job please visit itjobpro.co.uk.