Data Architect (Informatica/Snowflake)

***For a Very-Well-Known Global Consulting Firm with a focus on Digital & Technology Services!!***

Role: Data Architect (Informatics/Snowflake/SQL Server)

Location: Toronto, ON

Working Structure: Hybrid in office once every two weeks

Contract Length*: 3 months to start + possible extension(s) or conversion to Full-time, Perm

Pay Rate: $90-$95 per hour INC

Target Start Date: August 8th, 2023

We are looking for a Data Architect who is an experienced technology architect with strong business acumen. They need to be comfortable working with a technical team as well the client business leaders. They need to have excellent communications skills, and are able to map the business needs to technology solutions and help non-technical audiences understand the benefits of these solutions.

• Should have good SQL scripting skills(TSQL or PLSQL).
• Must have experience of Agile development methodologies
• Provide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surface
• Experience in Data Migration from RDBMS to Snowflake cloud data warehouse
• Must have expertise in AWS or Azure Platform as a Service (PAAS).
• Build processes supporting data transformation, data structures, metadata, dependency and workload management
• Certified Snowflake cloud data warehouse Architect (Desirable).
• Strong written communication skills. Is effective and persuasive in both written and oral communication.
• Experience with data security and data access controls and design
• Experience with AWS or Azure data storage and management technologies such as S3 and ADLS
• Deep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling)
• Should be able to troubleshoot problems across infrastructure, platform and application domains.
• Expertise in deploying Snowflake features such as data sharing, events and lake-house patterns
• Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshoot
• Expertise in Snowflake – data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard ETL concepts
• Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python
• Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand how to use these features