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