Ability to create DBT projects and DBT common projects
Ability to create DBT standards and best practices
Ability to create macros for common functions
DBT test automation
Ability to leverage DBT out of the box utils and create new packages as needed
Requirements
Bachelor's Degree or master’s degree in Computer Science.
10+ years of hands-on software engineering experience.
2 years of strong ELT experience using Data Build Tool (DBT) loading to Cloud DW Snowflake / Redshift.
3+ years of strong ETL experience on either DataStage, Informatica, Ab-Initio, Talend etc.is plus
Experience in designing solutions for multiple large data warehouses with a good understanding of cluster and parallel architecture as well as high-scale or distributed RDBMS
Strong database fundamentals including SQL, performance, and schema design.
Proficiency in SQL coding
Ability to interpret/write Python scripting is a plus.
Experience with AWS platform big plus
Experience with Git.
Experience building CI/CD pipeline is plus
To be able to work in a fast-paced agile development environment.