Data Warehouse Developer

Desired Experience

• Gathering requirements and developing technical specifications for ETL – 6 years

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

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

• Implementing change data capture (CDC) – 4 years

• Testing and debugging ETL – 6 years

• Developing complex SQL - 6 years

• ETL job scheduling – 2 years

• Loading data warehouses using ETL tools – 2 years

• Management of multiple ETL tools

• Experience with data quality tools and frameworks

• Using source code version control software

• Mentoring to others on ETL development

• Managing multiple, concurrent projects and tasks

• Having strong interpersonal skills including communication, mentoring, collaborating, and team building

ETF Technologies

• Alteryx

• SSIS

• SSRS

• SQL Server

• Tableau

• Semarchy

• Git & github

Top Skills & Years of Experience:

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

b.​Using ETL tools to design ETL jobs (ETL 6 years, MINIMUM 2 years of ETL 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