Job Details:
- 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.
#J-18808-Ljbffr