Data Warehouse Integrations

1 week ago


Mississauga, Canada AppTad Technologies Pvt Ltd Full time

**Job Title**:Sr Data warehouse Integrations
**Job Location**:Mississauga, ON / Montreal, QC
**Job Duration**: Long-Term
**Primary Responsibilities**
- Strong understanding or Snowflake on Azure Architecture, design, implementation and operationalization of large-scale data and analytics solutions on Snowflake Cloud Data Warehouse.
- Hands-on 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 large-scale 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**: $75.00-$80.00 per hour

**Benefits**:

- Dental care
- Paid time off
- Vision care

Schedule:

- 8 hour shift
- Day shift
- Evening shift
- Monday to Friday
- Night shift

**Experience**:

- Snowflake: 3 years (required)
- Azure: 4 years (required)
- Python: 4 years (required)



  • Mississauga, Canada The Chefs' Warehouse Full time

    At The Chefs’ Warehouse we are an industry leader in food distribution! We have a distinct competitive advantage in serving our customers because of our extensive selection of top quality and hard-to-find specialty and center-of-the-plate food products. What’s on our menu? **Enticing Appetizers**: A culture that is full of flavor and inviting! Creating...


  • Mississauga, Canada The Chefs' Warehouse Full time

    At The Chefs’ Warehouse we are an industry leader in food distribution! We have a distinct competitive advantage in serving our customers because of our extensive selection of top quality and hard-to-find specialty and center-of-the-plate food products. What’s on our menu? **Enticing Appetizers**: A culture that is full of flavor and inviting! Creating...


  • Mississauga, Canada The Chefs' Warehouse Full time

    At The Chefs’ Warehouse we are an industry leader in food distribution! We have a distinct competitive advantage in serving our customers because of our extensive selection of top quality and hard-to-find specialty and center-of-the-plate food products. What’s on our menu? **Enticing Appetizers**: A culture that is full of flavor and inviting! Creating...


  • Mississauga, Canada The Chefs' Warehouse Full time

    **Mission**: The mission of The Chefs’ Warehouse is to provide the world’s greatest ingredients to the world’s best chefs. **Our C.H.E.F.S. Values**: Curious & Creative Hungry For Food & Results Entrepreneurial Forward Thinking & Flexible Supportive (Of Peers & Chefs) Lead and positively coach warehouse team members to safely, accurately and...


  • Mississauga, Canada The Chefs' Warehouse Full time

    **Mission**: The mission of The Chefs’ Warehouse is to provide the world’s greatest ingredients to the world’s best chefs. **Our C.H.E.F.S. Values**: Curious & Creative Hungry For Food & Results Entrepreneurial Forward Thinking & Flexible Supportive (Of Peers & Chefs) As a Warehouse Worker, you will be responsible for providing warehouse support...


  • Mississauga, Canada The Chefs' Warehouse Full time

    At The Chefs’ Warehouse we are an industry leader in food distribution! We have a distinct competitive advantage in serving our customers because of our extensive selection of top quality and hard-to-find specialty and center-of-the-plate food products. What’s on our menu? **Enticing Appetizers**: A culture that is full of flavor and inviting! Creating...


  • Mississauga, Canada The Chefs' Warehouse Full time

    At The Chefs’ Warehouse we are an industry leader in food distribution! We have a distinct competitive advantage in serving our customers because of our extensive selection of top quality and hard-to-find specialty and center-of-the-plate food products. What’s on our menu? **Enticing Appetizers**: A culture that is full of flavor and inviting! Creating...


  • Mississauga, Canada The Chefs' Warehouse Full time

    At The Chefs’ Warehouse we are an industry leader in food distribution! We have a distinct competitive advantage in serving our customers because of our extensive selection of top quality and hard-to-find specialty and center-of-the-plate food products. What’s on our menu? **Enticing Appetizers**: A culture that is full of flavor and inviting! Creating...

  • Data Integrator

    7 days ago


    Mississauga, Ontario, Canada Itech Enterprises Full time

    Role DescriptionThis is a full-time, on-site role for a Data Integrator within the Banking domain, based in Mississauga, ON. The Data Integrator will be responsible for managing and analyzing banking data, performing data modeling, and overseeing data operations to ensure accuracy and integrity. Tasks will include leveraging analytical skills and...


  • Mississauga, Canada Co-operators Full time

    Company: CGIC Department: Business Intelligence Employment Type: Regular Full-Time Work Model: Hybrid Language: Only English is required Additional Information: This/these role(s) is/are currently vacant for the Client Analytics Modernization Team. The Opportunity We are a leading Canadian financial services co-operative committed to being a catalyst for a...