Snaplogic Developer

Data Ingestion & SnapLogic Development Design, develop, and maintain enterprise-grade pipelines in SnapLogic to extract data from REST/SOAP APIs and various source systems.

Build scalable ingestion pipelines to load structured and semi-structured data into Snowflake.

Implement production-standard, reusable SnapLogic jobs featuring robust error handling, monitoring, and performance optimization (e.g., caching, parallel processing). 2.

Data Modeling & dbt (Data Build Tool) Hands-on experience designing and building modular dbt transformation models on top of Snowflake data.

Write complex, optimized SQL queries and transformations to create analytics-ready datasets.

Implement data quality checks, testing, and documentation using native dbt features. 3.

Workflow Orchestration & Scheduling Utilize Apache Airflow to orchestrate and schedule end-to-end data workflows.

Manage job dependencies, monitor pipeline execution, and design Directed Acyclic Graphs (DAGs) to trigger SnapLogic and dbt jobs seamlessly.

Qualifications & Skills Experience 7+ years of total IT experience, with at least 5 years strictly dedicated to building and managing ETL/ELT data pipelines.

SnapLogic Deep, end-to-end expertise in SnapLogic iPaaS, configuring Snaps, Ultra Tasks, and building complex custom pipelines.

Snowflake Extensive understanding of Snowflake architecture, schema design, clustering, and writing performance-tuned SnowSQL. dbt Hands-on commercial experience developing models, macros, and running dbt in high-volume, production-grade environments.

Airflow Strong command of Airflow for workflow management, DAG creation, and resolving job failures.

Scripting Proficiency in Python and advanced ANSI-SQL to support custom scripts and complex transformations.

Data Ingestion & SnapLogic Development Design, develop, and maintain enterprise-grade pipelines in SnapLogic to extract data from REST/SOAP APIs and various source systems.

Build scalable ingestion pipelines to load structured and semi-structured data into Snowflake.

Implement production-standard, reusable SnapLogic jobs featuring robust error handling, monitoring, and performance optimization (e.g., caching, parallel processing). 2.

Data Modeling & dbt (Data Build Tool) Hands-on experience designing and building modular dbt transformation models on top of Snowflake data.

Write complex, optimized SQL queries and transformations to create analytics-ready datasets.

Implement data quality checks, testing, and documentation using native dbt features. 3.

Workflow Orchestration & Scheduling Utilize Apache Airflow to orchestrate and schedule end-to-end data workflows.

Manage job dependencies, monitor pipeline execution, and design Directed Acyclic Graphs (DAGs) to trigger SnapLogic and dbt jobs seamlessly.

Qualifications & Skills Experience 7+ years of total IT experience, with at least 5 years strictly dedicated to building and managing ETL/ELT data pipelines.

SnapLogic Deep, end-to-end expertise in SnapLogic iPaaS, configuring Snaps, Ultra Tasks, and building complex custom pipelines.

Snowflake Extensive understanding of Snowflake architecture, schema design, clustering, and writing performance-tuned SnowSQL. dbt Hands-on commercial experience developing models, macros, and running dbt in high-volume, production-grade environments.

Airflow Strong command of Airflow for workflow management, DAG creation, and resolving job failures.

Scripting Proficiency in Python and advanced ANSI-SQL to support custom scripts and complex transformations.