TC
Data Engineer (Matillion)
TechDigital Corporation
- 🇺🇸 United States
- Remote
- 8 months ago
- ELT
- ETL
- SQL
- Git
- Snowflake
- Redshift
- AWS
- Azure
- GCP
- Azure Synapse
- Agile
8 months ago
• 8+ Years of Experience in Data Engineering and in Matillion ELT/ELT tools.
• Mastery of Matillion ETL components, including connectors (database, API, SaaS), transformations (Join, Filter, Aggregate, Calculator, Window Functions), and orchestration components.
• Understanding how Matillion generated SQL executes on cloud data warehouses for efficient transformations.
• Proficiency in advanced job design, modular, reusable, and parameterized workflows, version control integration with Git and environment management.
• Awareness of performance tuning within Matillion pipelines to optimize underlying SQL queries and reduce cloud consumption costs.
• Expertise in platforms such as Snowflake, Amazon Redshift, Google BigQuery.
• Solid knowledge of dimensional and relational modeling (star and snowflake schemas).
• Understanding of ETL versus ELT patterns and their impact on pipeline design.
• Experience with cloud-based ETL/ELT tools (Matillion, Glue, Data Factory) and data modelling.
• Expert level experience with SQL.
• Experience with the cloud (AWS, Azure and/or Google Cloud Platform).
• Experience in cloud-based data warehouses (Snowflake, Google BigQuery, Amazon Redshift, Azure Synapse Analytics).
• Understanding of and willingness to embrace Agile Principles.
Data Engineer (Matillion) · TechDigital Corporation