Snowflake Data Engineer

Role: Snowflake Data Engineer

Location: Toronto and Ottawa (Hybrid)

Duration: Long term Project

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.

What You'll Do

· Implement integrations requested by customers

· Deploy updates and fixes

· Provide Level 2 technical support

· Build tools to reduce occurrences of errors and improve customer experience

· Develop software to integrate with internal back-end systems

· Perform root cause analysis for production errors

· Investigate and resolve technical issues

· Develop scripts to automate visualization

· Design procedures for system troubleshooting and maintenance

Expertise You'll Bring

· Experienced software professional with minimum 5 years of experience in Snowflake

· Working experience to work with Indian finance industry

· Work with cross functional teams including QA, Platform Delivery and DevOps

· Not afraid of refactoring existing system and guiding the team about same.

· Able to plan and deliver project deliverable on time with quality.

· Good Communication skills

· Innovative Thinking

· Organization Commitment (hard working)

· Customer Focus/Orientation

· Able to communicate effectively with both technical and non-technical project stakeholders.