2,426,328open jobs
149,975companies
297,570added this week
Browse all
Location
In office (Pune)
Seniority
Staff · 9+ years exp
Visa
Sponsors visas in United States, United Kingdom; no register of this country names it

Confirmed on the employer's own hiring board on Nov 20, 2026. First seen by Alion on Nov 20, 2026. Zensar Technologies scores B on the Alion truth index.

Overview
Company
Impact
Profile match
Zensar Technologies is an Indian technology services company founded in 1991 and part of the RPG Group, providing digital engineering, application services and infrastructure management to clients in banking, insurance, retail, manufacturing and healthcare. Its work covers experience design, cloud and data engineering, application development and maintenance, and increasingly applied artificial intelligence, delivered from centres in India, South Africa, Europe and the United States. Headquartered in Pune and listed in India, it earns a large share of revenue from North America and has been repositioning toward higher-value engineering work.

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.

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

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

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

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

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

  • 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

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

  • 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

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

  • Experienced in internal as well as external stakeholder management

  • dbt Analytics Engineering Certification, SnowPro-Core / SnowPro-Advanced certification, and/or Fivetran or Apache Airflow certification will be an 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 Retail / eCommerce (home furnishings or consumer retail) domain experience.

Free account
Stop reading job ads. Get the ones that fit.
One free account turns this page into a shortlist built around your stack, your level and your pay.
Match on every job. Stack, seniority, pay and location, scored against your profile.
2,426,328 open roles. Read straight off company career pages, refreshed every day.
Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.
3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.
Create a free account Continue with Google
Free forever. No card. Under a minute.

Your match

How well do you fit this role?
Two answers are enough for a real match. No account needed.
Check my fit
Answers stay in this browser until you create an account.

Recommended for you based on this role

Sales
Similar stack
Same company
Pune
In office · Chennai
Java
Java
Spring Boot
Databases
Apache Kafka
Google Bigtable
DevOps
GCP
Docker
Kubernetes
Apply
In office · 10+ years exp · Bengaluru
Java
SQL
Java
Spring Boot
Databases
Oracle
DevOps
CI/CD
Management
Oracle ERP
Marketing
Salesforce
Apply
In office · Bengaluru
Python
Python
pySpark
Databases
Databricks
Delta Lake
DynamoDB
AI/ML
Spark
DevOps
Rest API
AWS
Amazon EC2
Amazon S3
Amazon ECS
Apply
In office · 8+ years exp · Bengaluru
JavaScript
TypeScript
C#
C#
ASP.NET Core
Entity Framework Core
AI/ML
Embeddings
Function Calling
AI Agents
Semantic Kernel
LLM
RAG
OpenAI
Frontend
Angular
React.js
DevOps
Rest API
Azure
CI/CD
Docker
Cybersecurity
Microsoft Entra ID
Apply
In office · Noida
DevOps
Terraform
Ansible
Azure
HAProxy
AWS
Nginx
DNS
Cybersecurity
Wireshark
Tcpdump
Management
ITIL
Apply
In office · Full-Time · Pune
Marketing
Salesforce
HubSpot
Marketo
Apply
In office · Pune
Apply
≈ $9k – $26k per year (Estimated) · Hybrid · Full-Time · 3+ years exp · Bachelor's Degree · Pune · New Delhi
SQL
Databases
MS SQL
Azure SQL Database
Analytics
Power BI
ETL/ELT
Management
Power Automate
Power Apps
SharePoint
Agile
Apply
In office · Confidential · Full-Time · Pune
JavaScript
TypeScript
Node JS
Node JS
Express
Databases
RabbitMQ
Apache Kafka
DevOps
Rest API
AWS
AWS Step Functions
Cybersecurity
Least Privilege
Apply
Engineer Software 1 day ago
In office · Confidential · Full-Time · Pune
JavaScript
TypeScript
Node JS
Databases
PostgreSQL
RabbitMQ
Apache Kafka
DevOps
Rest API
CI/CD
Git
Cybersecurity
Active Directory
LDAP
QA
Jest
Vitest
Apply
See all jobs
This is one of many
2,426,328 more open roles from verified company boards, updated every day.