DBT / DataStage

Teamware Solutions

3 - 5 years

3 - 5 Lacs

Hyderabad Telangana India

Posted:21 hours ago| Platform: Foundit logo

Apply

Skills Required

dbt snowflake Google BigQuery

Work Mode

On-site

Job Type

Full Time

Job Description

DBT (Data Build Tool) / DataStage Developer

Roles and Responsibilities:

Design, develop, and implement data transformation logic
using either
DBT (Data Build Tool)
for data modeling within data warehouses (e.g., Snowflake, BigQuery, Redshift) or
IBM DataStage
for complex ETL (Extract, Transform, Load) processes.
Create, maintain, and optimize data pipelines
to ensure efficient and reliable data flow from source systems to target data platforms.
Write, test, and deploy SQL-based data transformations
using DBT, ensuring data integrity and performance.
For DataStage,
develop and fine-tune DataStage jobs, sequences, and routines
for data extraction, transformation, and loading.
Collaborate with data architects, data engineers, and business analysts
to understand data requirements and translate them into technical solutions.
Perform data profiling, data quality checks, and validation
to ensure accuracy and consistency of data.
Troubleshoot and resolve data pipeline issues
, performance bottlenecks, and data discrepancies.
Implement and maintain
version control
for data models and ETL jobs.
Contribute to the development of
data governance and data quality standards
.
Create and maintain comprehensive
technical documentation
for data models, ETL processes, and data flows.
Participate in
code reviews
and provide constructive feedback to peers.

Required Skills and Qualifications:

Proven experience as a
Data Engineer / Developer
with a focus on data transformation.
Strong expertise in either DBT (Data Build Tool)
for data modeling and transformation in modern data warehouses
OR extensive experience with IBM DataStage
for enterprise-level ETL.
Solid understanding of
data warehousing concepts, dimensional modeling, and ETL/ELT methodologies
.
Highly proficient in
SQL
(Structured Query Language) for complex data manipulation and querying.
Experience with cloud data platforms like
Snowflake, Google BigQuery, or Amazon Redshift
(if DBT focused).
Familiarity with
version control systems
(e.g., Git).
Strong analytical and problem-solving skills with attention to detail.
Excellent communication skills (written and verbal) and ability to work collaboratively in a team environment.
Knowledge of scripting languages (e.g., Python) is a plus.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.