DBT TECHNICAL SPECIALIST

As a DBT Technical Specialist, you will be responsible for providing technical solution across DBT project lifecycle including integration with existing data and analytics platforms and tools (both on-premise as well as cloud databases). You would be working with a team of developers fostering a culture of support and collaboration.

You will contribute to the role by:

- Creating Impact faster: Delivering more Impact In less time by quickly deploying solutions or augmenting existing ones to enable teams to accelerate business results and Increase time to value

- Breaking through barriers: Helping create better customer experience by taking the data first approach and deliver Insights

- Adapting to anything: Agility to reacting and responding to new business priorities and market conditions and customer opportunities with rapidly deployable solutions

- Innovating anywhere: Solving problems with powerful solutions enabling Inter operable solutions across multiple lines of business

9-12 Years of Data and Analytics experience with minimum 8+ years ETL tools & technologies like DBT (Data Build Tool) and DBT Cloud, Informatica, Snowflake, Spark, Kafka, Python etc.

- Excellent communication and presentation skills.

- Extensive experience in DBT – DBT CLI, DBT Cloud, GitHub version control and repository knowledge, DBT scripting to design & develop PLSQL processes to perform complex ELT processes and data pipeline build

- In-Depth experience on DBT concepts such as Models, Materialization, Sources, Seeds, Snapshots, Packages, Hooks, Exposures, Analyses.

- Proven experience on End to End DBT project implementation technical solutions, including architecting, designing and development and guiding team as needed. Experience in identifying architecture gaps that can improve availability, performance and security for productions systems and working towards resolving those issues along with development team.

- Working experience in Snowflake; use of SnowSQL CLI, SnowPipe creation of custom functions and Snowflake stored producers, schema modelling, performance tuning etc.

- Good Understanding and knowledge on CI/CD process and GitHub->DBT-> Snowflake integrations

- Advance SQL knowledge and hands on experience on complex queries writing using with Analytical functions, Troubleshooting, problem solving and performance tuning of SQL queries accessing data warehouse as well as Strong knowledge on stored procedures