CoreHRx Jobs

Apply in one click, save jobs and take free mock tests.

Register free Log in
Hiring? Post jobs with CoreHRx
My account
user

View & update profile

Dbt Technical Specialist

Zensar Technologies

Full time
Experience
9–12 years
Location
Pune
Work mode
Not stated
Salary
₹15L – ₹28L a year estimatetypical for IT Jobs in Pune, 64 posts
Posted 17 hr ago

Free · takes a minute · your resume fills your profile

CoreHRx never asks candidates for money. If anyone does, .

Role at a glance

You will
  • 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…
  • Breaking through barriers: Helping create better customer experience by taking the data first approach and deliver Insights
Experience
9–12 years
Must-have skills
AgileAirflowCI/CDELTETLKafka

How well do your skills match this job?

Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.

Job description

Description

As a DBT Technical Specialist, you will provide technical solutioning across the full ETL/ELT modernization lifecycle – leading the migration of legacy Informatica IICS pipelines to a modern DBT-based transformation layer on Snowflake, orchestrated with Fivetran for data ingestion and Apache Airflow for pipeline orchestration – 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 of hands-on experience across the modern ELT stack – DBT (Data Build Tool)/DBT Cloud, Fivetran, Apache Airflow and Snowflake – along with working knowledge of legacy ETL platforms such as Informatica IICS/PowerCenter, Spark, Kafka, Python etc.

  1. Excellent communication and presentation skills.

  2. 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

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

  4. Proven experience on End to End DBT project implementation technical solutions, including architecting, designing and development and guiding team as needed. Proven experience leading ETL/ELT modernization and migration engagements – translating legacy Informatica IICS/PowerCenter mappings and workflows into DBT models, defining the migration strategy, conversion standards and cutover/reconciliation approach, and mentoring developers through the transition. 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.

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

  6. Strong hands-on experience with Fivetran (or an equivalent EL/data ingestion tool) for automated data ingestion – architecting and governing connector strategy for SaaS applications, databases and files, handling schema drift, incremental sync/CDC, and defining standards for connector monitoring and troubleshooting.

  7. Strong working experience with Apache Airflow (or an equivalent orchestration tool) for pipeline orchestration – designing DAG architecture and dependency frameworks that sequence Fivetran ingestion and DBT transformation jobs, and defining standards for retries, SLA monitoring and failure alerting across the end-to-end pipeline.

  8. Good understanding and knowledge of CI/CD processes and GitHub->DBT->Snowflake integrations, including version control and deployment of Fivetran connector configurations and Airflow DAGs as part of the same pipeline

  9. 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

  10. Good experience in developing UNIX and Python scripts for data auditing and automating various database platform manual activities.

  11. Working knowledge of the legacy ETL/ELT platform being modernized – Informatica PowerCenter/IICS – sufficient to interpret existing mappings and workflows for migration to the DBT-based target architecture; familiarity with SnowSQL, SnowPipe, Spark and Kafka is a plus

  12. Well versed with Waterfall, Agile, Scrum and similar project delivery methodologies.

  13. Experienced in internal as well as external stakeholder management

  14. dbt Analytics Engineering Certification, SnowPro-Core / SnowPro-Advanced certification, and/or Fivetran or Apache Airflow certification will be an added advantage.

  15. 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.

  16. Good to have Retail / eCommerce (home furnishings or consumer retail) domain experience.



Key skills

Required

AgileAirflowCI/CDELTETLKafkaPythonReconciliationSQLScrumService Level Agreements (SLA)Stakeholder ManagementUnixdbtSnowflake

Preferred

AWSGoogle Cloud Platform (GCP)Microsoft AzurePower BITableau

Soft skills

CommunicationPresentation SkillsProblem Solving

Job market insights

470active Agile jobs in Pune
47active Airflow jobs in Pune
434active CI/CD jobs in Pune
₹15L – ₹28L advertised yearly salary for IT Jobs in Pune (middle half of 64 posts that show a salary; median ₹22L)
81 more open jobs at Zensar Technologies

Most IT Jobs posts in Pune ask for 3–6 years of experience (43% of 1544 that say).

Hiring most for IT Jobs in Pune

  • Citi76 open jobs
  • Capgemini46 open jobs
  • Wipro Limited38 open jobs

Jobs asking for Agile in Pune also ask for

  • SQL32%
  • Scrum30%
  • CI/CD29%
  • Java27%
  • JIRA23%

From live job posts on CoreHRx, updated 22 Nov 2026. Skill figures count posts that list their skills; salary figures only posts that show a salary.

Questions about this job

What is the salary for this Dbt Technical Specialist job?

The post does not state the pay. As an estimate, comparable posts on CoreHRx advertise ₹15L – ₹28L a year (typical for IT Jobs in Pune, 64 posts).

How much experience does this job need?

The post asks for 9–12 Yrs experience.

Where is this job based?

In Pune.

What kind of job is this?

It is a full time job.

This page helps Indian job seekers prepare for Python interviews for backend, data engineering and data analyst roles, whether you are a fresher facing your first technical round or an experienced developer aiming for a senior position. It has 60 questions in three levels, easy, medium and hard, each with a concise sample answer and, where it helps, runnable Python 3.12 code. Topics include data structures, OOP, generators, decorators, the GIL and concurrency, type hints, testing and performance. Answer each question aloud in your own words first, then compare with the sample answer and run the code to check your understanding.

Questions you may be asked

  1. What is the difference between mutable and immutable types in Python?
  2. What is the difference between a list and a tuple?
  3. What is the difference between is and ==?
  4. What are *args and **kwargs?

Get IT jobs in Pune by email

Create a free profile and we email you new IT jobs in Pune, at most once a week.

Similar jobs

Sales Executive

Adithya It Solutions Pvt Ltd
Salem
CommunicationReal Estate Sales
Easy Apply Full time On-site 3 days ago

Free · takes a minute · your resume fills your profile