Description

You will design, develop, and maintain data warehouse environments and ETL pipelines.

Responsibilities

• Develop EL pipelines using Databricks, Python, and SnowSQL to move data in and out of the warehouse.
• Translate mapping specifications into data transformation designs and production-ready code.
• Build and maintain UNIX and Python scripts for Extract, Load, and Transform processes.
• Provide production support for data load, transformation, and translation issues.
• Perform code reviews to ensure adherence to standards and optimal execution patterns.
• Monitor Operational Level Agreements regarding warehouse health, query performance, and cost.

Required Skills

• 5+ years of experience in data warehousing, including OLTP, OLAP, Dimensions, Facts, and Data modeling.
• Hands-on experience with Snowflake utilities: SnowSQL, SnowPipe, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored procedures.
• Proficiency in Python and SQL.
• Experience with MS Azure configuration in relation to Snowflake.
• Working knowledge of UNIX scripting.
• Ability to automate data pipelines using cloud-based testing.
• Experience documenting implementations, requirements, and test conditions.

Key Skills

Education

Any Graduate