Trino Developer

Job Overview:

• We are seeking a Trino Developer to take charge of enhancing query engine performance, spearheading the transition of current
• pipelines and data warehouses, and assisting in the creation of a scalable, cost-effective lakehouse architecture.
• Your role will integrate query engineering, data modeling, and platform operations, converting
• legacy Snowflake and Spark logic into efficient Trino Iceberg workloads while maintaining accuracy, consistency, and
• reliability.

Main Responsibilities:

• Practical experience in production environments with Trino or PrestoSQL Presto.
• Extensive SQL knowledge, including complex analytical queries, window functions, CTEs, and query optimization.
• Hands-on experience with Apache Iceberg or similar open table formats such as Delta Lake and Hudi,
• including schema evolution and table management.
• Familiarity with Snowflake and/or Apache Spark to analyze, comprehend, and migrate
• existing workloads.
• Understanding of distributed query execution, MPP architecture, join distribution, memory spill behavior,
• partition pruning, and predicate pushdown.
• Experience with cloud object storage and columnar file formats like Parquet and ORC.
• Proficiency in at least one programming language such as Python, Java, or Scala for developing tooling, UDFs, and
• automation tasks.
• Familiarity with version control systems like Git and CI/CD practices for data pipelines.

Technical Qualifications:

• Experience leading large-scale migrations from Snowflake to Trino or from Spark to Trino.
• Administering and deploying Trino clusters on Kubernetes.
• Workflow orchestration tools such as Airflow, Dagster, or similar, and dbt.
• Proven experience in developing data validation and reconciliation frameworks for migration accuracy.
• Knowledge of Trino internals or connector development, including contributing custom connectors and UDFs.
• Experience with streaming CDC ingestion into Iceberg using technologies like Kafka, Flink, and Debezium.
• Familiarity with data governance, lineage, and cost optimization tools.

Additional Expectations:

• A strong analytical and problem-solving approach to troubleshoot accuracy and performance issues.
• Effective communication skills to document migration strategies and collaborate with analytics platforms and
• business units.
• A proactive ownership approach with a focus on data accuracy and reliability.

Preferred Expertise:

Technology->Big Data->Big Data - ALL, Technology->Big Data->Text Analytics