Source description
About the role
DBT Technical Specialist
Pune, Maharashtra, India
Trending
Job Description
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.
Responsibilities
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
Qualifications
- 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
-
Good experience in developing UNIX and Python scripts for data auditing and automating various database platform manual activities.
-
Excellent Experience in other ELT/ETL & Streaming tools & technologies i.e. Informatica Power Center, SNOWSQL, SnowPipe, Spark and Kafka
-
Well versed with Waterfall, Agile, Scrum and similar project delivery methodologies.
-
Experienced in internal as well as external stakeholder management
-
dbt Analytics Engineering Certification as well as SnowPro-Core / SnowPro-Advanced certification will be added advantage.
-
Nice to have skills: Working experience in Reporting technologies like Tableau or Power BI and Exposure to Cloud Analytics native services of AWS/AZURE/GCP etc.
-
Good to have Hi-Tech Manufacturing domain experience.
About Us
At Zensar, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus.
Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.
We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.
Apply Now
Job Info
-
Job Identification147373
-
Posting Date07/16/2026, 03:08 AM
-
Job ShiftEvening Job
-
LocationsPlot No. 4, MIDC, Kharadi, Pune, Maharashtra, 411014, IN
-
Work from AnywhereNo
-
Minimum Experience (In Years)9
-
Maximum Experience (In Years)12
-
Life at Zensar - YouTube
Tap to unmute
Life at Zensar Zensar Technologies
Zensar Technologies2.87K subscribers
Similar Jobs
See More Jobs
Cookie Consent – We respect your privacy
By continuing to browse or by clicking “accept,” you agree to the storing of cookies on your device to enhance your site experience and for analytical purposes. To learn more about how we use cookies, please see our cookie policy page. We use cookies to improve your experience on our website. They help us to improve site performance, present you relevant advertising and enable you to share content in social media. You may accept all cookies, or choose to manage them individually.
Accept AllReject all cookies
Manage Cookies
Are You Still With Us?
It seems you've been gone for a while. For security reasons we will end your session automatically in 03:00 unless you would like to continue working.
End SessionContinue Working
Work Summary
This summary is generated by AI Assist. Click inside the summary text box to make changes as necessary.
DiscardAdd Summary
Page DBT TECHNICAL SPECIALIST - Zensar Careers loaded
More at Zensar