Senior 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.