Post Job Free
Sign in

Sr Data Engineer

Company:
Cat America
Location:
Edendale, KwaZulu-Natal, 3217, South Africa
Posted:
April 29, 2024
Apply

Description:

• 10+ years of industry experience with hands on managing projects in Data Warehousing with a minimum 4 years of experience working on Snowflake

• Bachelor’s degree in computer science, Engineering, or related fields or equivalent practical experience.

• Should have hands on experience with ETL tools (Matillion Preferred)

• Deep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling).

• Experience in designing and building manual or auto ingestion data pipeline using Snowpipe.

• SnowSQL Experience in developing stored Procedures writing Queries to analyse and transform data.

• Expertise in Snowflake data modeling, ELT using snowpipe, implementing stored procedures and standard DWH and ETL concepts.

• Should have implement cloud-based Enterprise data warehouse solutions with multiple data platforms along with Snowflake environment to build data movement strategy

• Should be able to make necessary on-going updates to modeling principles, processes, solutions, and best practices to ensure that the Snowflake is aligned with business needs of the environment.

• Should be able to lead in developing project requirements for end-to-end Data integration process using ETL for Structured, semi-structured and Unstructured Data.

• Expertise in Snowflake concepts like setting up resource monitors, RBAC controls, virtual warehouse, query performance tuning, Zero copy clone, time travel and understand how to use these features

Apply