Title: Snowflake Developer
Location: Ottawa / Toronto (Hybrid)
Duration: Long Term Contract
Job description:
As a Snowflake Developer, you are expected to have below Technical skills:
- Cloud technologies (AWS data services, AWS Glue, AWS Lambda, Integration with Active directory, masking and encryption, Governance activities – Lineage, Catalog, classifications. Infrastructure setup in Snowflake)
- Experienced with multiple data-ingestion methods for loading data to Snowflake: Snowpipe, Glue, Copy Into for large volume of data as well as incremental data handling
- Sound knowledge of Snowflake Architecture, Design and Performance considerations
- Data lake and Data Warehouse Design and optimization
- ETL, Data Analysis, CDC
- Technical understanding of digital / customer experience layers:Been Leading and built at least 1-2 Projects on AWS cloud with Snowflake
- Strong experience in designing and building DWH, Data lake ETL based applications with scalability and performance
- Experience with CDC and metadata driven based processing
- Have build DWH models
- Hands on experience of architecting RDBMS and Snowflake databases – transactional as well as data-warehouse
- Strong knowledge of data structures, analytical algorithms, and designing for performance
- Good to understand the security and access controls on AWS
- Nice to understand Agile and Devops methodology for cloud deployment.
Expertise You'll Bring
- Experienced software professional with minimum 5 years of experience in Snowflake
- Working experience to work with Indian finance industry