Data Warehouse Specialist - Montréal, Canada - AppTad Technologies Pvt Ltd
1 week ago
Description
Job Title:
Data Warehouse Specialist
Job Location:
Montreal, Mississauga, Ontario Canada &Montreal, Québec, Canada (Need Onsite day 1, Hybrid 3 days from office).
Job Duration:
Long-Term
Technical skills -
- Top skills: snowflake architecture, snowSQL (Strong background), data factory (ADF) need capital market experience (equity/fixed income space) python outbound, inbound analysis and sql part of it financial industry experience
- Nice to haves understanding of CI/CD pipeline, python, concepts of warehousing
Primary Responsibilities
- Strong understanding or Snowflake on Azure.
- Handson development experience with Snowflake features such as Snow SQL; Snow Pipe; Python; Tasks; Streams; Time travel; Zero Copy Cloning; Optimizer; Metadata Manager; data sharing; and stored procedures.
- Experience in Data warehousing
- OLTP, OLAP, Dimensions, Facts, and Data modeling.
- Need to have working knowledge of MS Azure configuration items with respect to Snowflake.
- Developing EL pipelines in and out of data warehouse using combination of Data bricks, Python and Snow SQL.
- Developing scripts UNIX, Python etc. to Extract, Load and Transform data, as well as other utility functions.
- Provide production support for Data Warehouse issues such data load problems, transformation translation problems
- Translate mapping specifications to data transformation design and development strategies and code, incorporating standards and best practices for optimal execution.
- Understanding data pipelines and modern ways of automating data pipeline using cloud based testing and clearly document implementations, so others can easily understand the requirements, implementation, and test conditions.
- Perform code reviews to ensure fit to requirements, optimal execution patterns and adherence to established standards.
Basic Qualifications
- Minimum 4 years of designing and implementing an operational production grade largescale data solution on Microsoft Azure Snowflake Data Warehouse.
- Including hands on experience with productionized data ingestion and processing pipelines using Python, Data bricks, Snow SQL
- Excellent understanding of Snowflake Internals and integration of Snowflake with other data processing and reporting technologies
- Excellent presentation and communication skills, both written and verbal, ability to problem solve and design in an environment with unclear requirements.
Salary:
$60.00-$62.00 per hour
Benefits:
- Dental care
- Life insurance
- Paid time off
Schedule:
- Monday to Friday
- Morning shift
Ability to commute/relocate:
- Montréal, QC: reliably commute or plan to relocate before starting work (required)
Education:
- Secondary School (preferred)
Experience:
- warehouse: 4 years (required)
Capital Market: 2 years (required)
- SQL: 3 years (required)
- ADF: 2 years (required)
Licence/Certification:
- CCDA (preferred)
More jobs from AppTad Technologies Pvt Ltd
-
System Administrator
Quebec City, Canada - 5 days ago
-
Storage Administrator
Montréal, Canada - 1 week ago
-
Ibm Mq Aps Consultant
Quebec City, Canada - 5 days ago
-
Sybase Oracle Database Administrator
Quebec City, Canada - 1 week ago
-
Business Analyst/insights Analyst
Toronto, Canada - 2 days ago
-
Windows Administrator
Quebec City, Canada - 1 week ago