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.
