Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
- Gratuity calculator
  
  Check your gratuity amount
- HRA calculator
  
  Check how much of your HRA is tax-free
- Salary hike calculator
  
  Check your salary hike
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Campus placements
  
  Interviews questions for 2K+ colleges
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

WINNERS AWAITED!
- ABECA 2025
  
  WINNERS AWAITED!
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
- AmbitionBox Best Places to Work 2021
  
  1st Edition

Add office photos

Employer? Claim Account for FREE

Stratacent

Compare

3.5

based on 19 Reviews

1 Stratacent Developer Job

DBT Developer +Tester

Stratacent India Private Limited

3.5

based on 19 Reviews

1-2 years

₹ 7 - 7L/yr (AmbitionBox estimate)

Pune

1 vacancy

DBT Developer +Tester

Stratacent

posted 7d ago

Job Role Insights

Flexible timing

Key skills for the job

Data Analytics SQL Healthcare Clinical Data Management Clinical SAS Programming Life Sciences

+ 4 more

Job Description

Title/Position : DBT Developer + Tester
Job Location: Pune/Gurgaon
Experience : 6+ Years
Employment Type: Full Time
Shift Timings: UK Timings (3 PM to 12 midnight)

Responsibilities.

Analysing existing inefficient/ legacy ETL codes and migrating them to efficient DBT jobs.
Understanding target architecture and building / maintaining jobs around Snowflake and DBT ecosystem.
Developing complex SQL queries in Snowflake as well as DBT for ETL/ELT.
Troubleshooting any ETL/ELT or data related issues during development life cycle as well as production phases.
Supporting and doing ETL/ELT migrations into Snowflake ecosystem. using DBT
Supporting customer issues and advising team/ client around Snowflake / DBT ecosystem for best practices and solving technical challenges.
Design and implement efficient data pipelines (ETLs) in order to integrate data from a variety of sources (files and DB tables) into Snowflake warehouse using DBT.

Develop and execute testing strategies using DBT features in conjunction with Snowflake.

Provide documentation, training, and consulting for team members.

Have a strong ETL background with at least 2 ETL/ELT tools such as Informatica, SAS DI Studio (or any other) in addition to DBT.

Key Skills Required:

Prior implementation experience of DBT is a must.
Hands on experience in writing advanced SQL Queries with and without DBT jobs.
Hands on with multiple DBT features such as macros, jinja, tests, sources, documentations related advanced features, etc.
Well versed with DWH and ETL/ELT concepts. Must have worked on multiple end to end data warehouse implementations.
Worked in Offshore / Onsite Engagements and collaborated across time zones.
Should be able to work in developer and tester capacity at different stages of project.
Bachelors degree or higher in a technology related field (e.g. Engineering, Computer Science, etc.) required, masters degree a plus.
Develop and execute test plans, test cases, and automation scripts for ETL pipelines and data validation.

Perform SQL-based data validation to ensure data integrity, consistency, and correctness.

Automate data quality tests using Python and/or SQL and integrate them into CI/CD pipelines.

Exposure to REST APIs usage/ integration

Good to Have:

Knowledge and Hands on experience with AWS services
Data management Experience working with data governance, data operations.
CI/ CD
DBT Certification

BFSI Experience
Python Programming

Company Profile
.
We have partnerships with SAS, Automation Anywhere, Snowflake, Azure, AWS and GCP.
URL - http://stratacent.com

Employee Benefits:
Group Medical Insurance
Cab facility
Meals/snacks
Continuous Learning Program

Stratacent India Private Limited is an equal opportunity employer and will not discriminate against any employee or applicant for employment on the basis of race, color, creed, religion, age, sex, national origin, ancestry, handicap, or any other factors

Employment Type: Full Time, Permanent

Read full job description

Prepare for Developer roles with real interview advice