Snowflake Data Engineer

Role : 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.