Job Summary
Role/Responsibilities
Qualifications & Experience
- 6-10 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
Key Responsibilities
Role/Responsibilities
Qualifications & Experience
- 6-10 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
Skill Requirements
Role/Responsibilities
Qualifications & Experience
- 6-10 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