Sr. Snowflake Developer

Role : Sr. Snowflake Developer

Location : Ottawa / Toronto (Hybrid)

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.