Implementing ETL pipelines within and outside of a data warehouse using Python and Snowflakes Snow SQL.
Work with the end user to get data requirements, performing complex data mapping and developing/maintaining ETL programs to support enterprise data warehouse.
Develop SQL scripts to load data from source systems and verify the data in target tables load correctly by ELT process.
Development of scripts using Unix, Python, etc. for loading, extracting, and transforming data.
Assist with production issues in Data Warehouses like reloading data, transformations, and translations.
Develop a Database Design and Reporting Design based on Business Intelligence and Reporting requirements.
Good To Have
In depth Knowledge on Data stage and Snowflake.
Knowledge of ETL process to facilitate smooth transfers and storage of data.
Scripting skills using Python.
Exposure to job scheduling/monitoring environments (E.g. Control-M)