Snowflake Data Engineer

• Role : Snowflake Data Engineer
• Location : Toronto (Hybrid)
• Contract role

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.