Description

You will develop and maintain data integration processes within a Snowflake cloud warehouse environment.

Responsibilities

• Build ETL pipelines using Python and Snowflake SQL to move data in and out of the warehouse.
• Develop Unix shell scripts to handle data extraction and loading tasks.
• Design and implement SQL-based processes for slowly changing dimensions and various fact tables.
• Perform data lineage analysis, profiling, mapping integration, cleansing, masking, and subsetting.
• Execute SQL performance tuning and root cause analysis to resolve technical failures.

Required Skills

• 8+ years of experience in Data Management with a focus on analytical data warehousing.
• 3+ years of hands-on experience with Snowflake cloud warehouse features.
• Proficiency in Python and Snowflake SQL.
• Experience writing and analyzing SQL and PL/SQL procedures.
• Ability to develop scripts using Unix shell.
• Strong understanding of logical and physical data models for BI and analytics.
• Knowledge of AWS architecture and cloud services.
• Experience with Data Lineage Analysis, Data Profiling, and Metadata Management.
• Experience working in Agile environments using Jira.

Key Skills

Education

Any Graduate