ETL Developer – Snowflake

Location: downtown Toronto business core, Working in a hybrid model

Salary: Market rate +

ETL Developer who has hands-on experience in data integration and database development using Snowflake and contributes to successfully deliver data integration or custom database development projects in the Greater Toronto Area.

RESPONSIBILITIES

  • Understand business requirements for data and information especially in the financial services industry.
  • Design data integration or ETL processing using Snowflake for client engagements based on an approach that is holistic, scalable, pragmatic, and effective design of data processing.
  • Ingest data and transform data in Snowflake using a variety of tools such as SnowSQL, Snowpark API, or Snowflake Stored Procedures.
  • Perform data profiling and data quality audit.
  • Design and integrate pipelines with Continuous Integration/Delivery framework as needed.
  • Develop automated unit-tests.
  • Develop design and operational documentations for the data pipelines.
  • Produce estimates for data analysis and mapping, design, development, and testing.
  • Ensure compliance with business, data, and technical requirements.
  • Ensure that client’s enterprise architecture standards, policies, and procedures are followed.

REQUIREMENTS

  • Minimum 5 years experience in Information Technology, participating in complex projects.
  • Minimum Bachelors degree in Computer Science.
  • Strong communication skills.
  • Strong knowledge in data analysis, database development, data warehousing life cycle and data integration methodologies (ETL, ELT).
  • Strong SQL programming knowledge in one of Oracle or Microsoft SQL databases.
  • Strong knowledge of Snowflake features and experiences in development applications using Snowflake.
  • Knowledgeable in both relational and dimensional data modeling (with both Kimball and Inmon approaches).
  • Knowledgeable in UNIX shell scripting
  • Working knowledge of one of data analytics tools (such as Microsoft Power BI).
  • Knowledge in data management and Continuous Integration and Delivery (CI/CD) principles.
  • Good overall business knowledge in financial industries (i.e. one or more in retail banking, commercial banking, capital markets, wealth management, insurance, pension fund, and fintech).
  • Preferably exposures to Hadoop-based tools (e.g. Hive, Spark) and cloud computing concepts (Azure services).
  • Ability to work independently and excel in a team environment.

Apply this job