Description

You will lead the migration of existing databases to Snowflake using dbt and internal processes. You design scalable data storage solutions and optimize SQL queries for performance. You integrate Snowflake with downstream systems and manage complex ETL workflows.

Responsibilities

• Lead the migration of existing databases to Snowflake using dbt.
• Design and implement scalable, efficient data storage solutions within Snowflake.
• Write, optimize, and troubleshoot SQL queries in the Snowflake environment.
• Analyze complex data patterns to optimize data storage and retrieval.
• Integrate Snowflake with downstream systems.

Required Skills

• 5+ years of experience in ETL development and data engineering.
• Expertise in Snowflake, including features like Time Travel and Zero-Copy Cloning.
• Proficiency in dbt.
• Strong SQL skills for query optimization and troubleshooting.
• Experience with DataStage ETL tools.
• Proficiency in Unix.
• Working knowledge of Python and Java.
• Experience managing complex ETL processes.

Preferred Skills

• Experience with large-scale database conversion projects.

Key Skills

Education

Any Gradute