Snowflake Data Engineer

Required Knowledge, Skills and Abilities:Minimum 1 year of designing and implementing a fully operational production grade large scale data solution on Snowflake Data Warehouse.3 years of hands-on experience with building productionized data ingestion and processing pipelines using Java, Spark, Scala, Python.2 years of hands-on experience designing and implementing production grade data warehousing solutions on large scale data technologies such as Teradata, Oracle or DB2.Expertise and excellent understanding of Snowflake Internals and integration of Snowflake with other data processing and reporting technologies.Experience in building data ingestion pipelines using Talend, Informatica.Experience in working with AWS, Azure and Google data services.Tasks:Developing ETL pipelines in and out of data warehouse using a combination of Python and Snowflake's Snow SQL.Writing SQL queries against Snowflake.Developing scripts in Unix, Python, etc. to do Extract, Load and Transform data.Working knowledge of AWS Redshift.Provide production support for Data Warehouse issues such as data load problems and transformation translation problems.Translate requirements for BI and Reporting to Database design and reporting design.Understanding data transformation and translation requirements and which tools to leverage to get the job done.Understanding data pipelines and modern ways of automating data pipelines using cloud-based solutions.Testing and clearly documenting implementations, so others can easily understand the requirements, implementation, and test conditions.#J-18808-Ljbffr