Ability to develop ETL pipelines in and out of data warehouse using combination of Python and Snowflake’s SnowSQL, Ability to write SQL queries against Snowflake, Ability to develop scripts (Unix, Python etc.) to do Extract, Load and Transform data, Ability to provide production support for Data Warehouse issues such data load problems, transformation/translation problems etc. Ability to integrate on premise infrastructure with public cloud (AWS) infrastructure, Ability to translate requirements for BI and Reporting to Database design and reporting design. Ability to understand data transformation and translation requirements and which tools to leverage to get the job done. Ability to understand data pipelines and modern ways of automating data pipeline using cloud based and on-premise technologies. Actively test and clearly document implementations, so others can easily understand the requirements, implementation, and test conditions.
Experience needed: N/A