Match score not available

Matillion Data Engineer

Remote:

Full Remote

Contract:

Freelance

Experience:

Mid-level (2-5 years)

Work from:

Brazil

Offer summary

Qualifications:

4+ years in Data Warehouse and ETL development, 2+ years in Matillion orchestrations and transformations, 2+ years experience with Snowflake development, Strong SQL coding and performance tuning skills, Hands-on experience with Snowpipe and API writing.

Key responsabilities:

Understand various data sources including databases and flat files
Handle data modeling, architecture, and pipeline management
Implement database structure, data marts, and data lakes
Ensure data security and quality, maintaining systems regularly
Administer ETL tools and conduct performance tuning

Thera Consulting

201 - 500 Employees

See more Thera Consulting offers

Job description

Requirements

4+ years in Data Warehouse and ETL development;
2+ years in Matillion orchestrations and transformation jobs, ETL/ELT development on Azure (connecting to various

on-premise and cloud data sources, processing structured data, denormalizing data, normalizing data using Matillion Data Loader, etc.);

2+ years experience with Snowflake development creating tables, views, excellent understanding how to connect to

multiple databases to navigate the data; write SQL and Python. Good hands-on experience developing with Snowpipe and ability to write APIs;

Strong SQL coding and performance tuning skills;

Responsibilities

Understand different data sources (databases, flat files);
Handle data modeling, data warehouse architecture, data pipeline management, and ETL testing;
Implement database structure, data marts, data stores, and data lakes;
Ensure high-end security and good quality of data;
Offer regular maintenance support;
Administering ETL tools, app integration, performance tuning;
Working on technical/functional documentation;

Required Languages