Data Warehouse (ETL) Developer

VSG Business Solutions LLC

Madison, WI

Expired: 13 days ago Applications are no longer accepted.

Full-Time

Job Description

Required Skills: Prior candidates were lacking Alteryx experience related to ETL, as many had experience based more on data prep. The manager is also looking for candidates with strong and recent SQL skills. This repost is open to nationwide candidates and does not require relocation to WI.

a. Gathering requirements and developing technical specifications for ETL 6 years

b. Using ETL tools to design ETL jobs (ETL 6 years, preferably 2 years of with Alteryx)

c. Developing various types of data loads (e.g. incremental, history/full, survivorship rules) 6 years

d. Implementing change data capture (CDC) 4 years

e. Testing and debugging ETL 6 years

f. Developing complex SQL - 6 years (should be recent experience)

g. ETL job scheduling 2 years

h. Loading data warehouses using ETL tools 2 years

Nice to Have:

a. Management of multiple ETL tools

b. Experience with data quality tools and frameworks - preferred

c. Using source code version control software preferred