Description

Develop and manage analytical data warehouse solutions using Snowflake and AWS.

On-site.

Responsibilities

• Develop ETL pipelines in and out of the data warehouse using Python and Snowflake SQL.
• Create and analyze SQL and PL/SQL procedures for data integration.
• Write Unix shell scripts to handle data extraction and loading processes.
• Build SQL-based processes for slowly changing dimensions and various fact tables.
• Perform SQL performance tuning, root cause analysis for failures, and unit testing.

Required Skills

• 8+ years of experience in Data Management specializing in analytical data warehousing.
• 3+ years of hands-on experience with Snowflake cloud warehouse and its features.
• Proficiency in SQL and PL/SQL for data integration and procedure development.
• Experience developing ETL pipelines using Python and Snowflake SQL.
• Knowledge of AWS architecture and its services.
• Experience with Unix shell scripting for Extract and Load tasks.
• Strong understanding of logical and physical data models for BI and analytics.
• Experience with UAT, system integration testing, and metadata management.
• Ability to work within Agile methodologies using Jira.

Key Skills

Education

Any Graduate