As a DBT ETL Expert, you will be responsible for designing, implementing, and maintaining data pipelines using the Data Build Tool (DBT) framework. You will work closely with cross-functional teams to understand data requirements, extract data from various sources, transform it to meet analytical needs, and load it into our data warehouse. You will play a key role in ensuring the integrity, reliability, and efficiency of our data processes, enabling stakeholders to make data driven decisions with confidence.

Responsibilities

• Overall 5 yrs experience with various data platforms, data warehousing initiatives including at least 2 implementation experience with airflow and DBT.
• Develop and maintain data models, transformations, and SQL queries within the DBT framework to support reporting and analytics initiatives is mandatory.
• Thorough understanding and application of AWS services related to Cloud data platform is mandatory AWS S3, AWS Glue, Amazon Redshift.
• Implement best practices for data modelling, schema design, and version control within DBT, ensuring consistency and scalability across projects is mandatory.
• Optimize and troubleshoot ETL processes to improve performance, reliability, and data quality.
• Should Ability to translate the tech spec into working code
• Stay current with industry trends and advancements in ETL technologies, incorporating new tools and techniques as appropriate like Airflow and DBT specific CICD, Version Control and Automated Testing.
• Collaborate with infrastructure and DevOps teams to deploy and monitor ETL pipelines in production environments.
• Preferably a DBT certified professional

About Virtusa Teamwork, quality of life, professional and personal development: values that Virtusa is proud to embody. When you join us, you join a team of 30,000 people globally that cares about your growth \xe2\x80\x94 one that seeks to provide you with exciting projects, opportunities and work with state of the art technologies throughout your career with us. Great minds, great potential: it all comes together at Virtusa. We value collaboration and the team environment of our company, and seek to provide great minds with a dynamic place to nurture new ideas and foster excellence. Virtusa was founded on principles of equal opportunity for all, and so does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.