Develop and maintain ETL pipelines in and out of data warehouse using combination of Python, Snaplogic, SQL Server, SSIS and Snowflake SnowSQL with a focus on performance, reliability, durability, data quality, security and SLA expectations.
Analyzes, designs, build, test, and implement integration technology solutions that meet the specifications of a project or service request
Perform data mappings and design of system ETL workflow solutions
Writing SQL queries against Snowflake database
Develop and support Oracle and SQL Server procedures
Provide production support for Data Warehouse issues such data load problems, transformation translation problems
Ensure accurate and timely data availability to meet business SLA, especially around critical time periods
Support and maintain legacy SQL Server/SSIS data warehouse
Support and maintain existing ETL processes for SQL Server and Snowflake