Job Description

:
Role & responsibilities
Designing, building, and maintaining ETL/ELT pipelines using dbt
Creating and managing data models and transformations using dbt to ensure efficient and accurate data consumption for analytics and reporting.
Developing and maintaining a data quality framework, including automated testing and cross-dataset validation.
Writing and optimizing SQL queries for efficient data processing within cloud components.
Working with data engineers, analysts, scientists, and business stakeholders to deliver data solutions.
Supporting day-to-day incident and ticket resolution related to data pipelines.
Creating and maintaining comprehensive documentation for data pipelines, configurations, and procedures.
Utilizing GCP services like BigQuery, Cloud Composer, Cloud Functions, etc.
Developing and maintaining SQL/Python scripts for data ingestion, transformation, and automation tasks.
Preferred candidate profile
Typically requires 2~13 years of experience in data engineering or a related field.
Proficiency in using dbt for data transformation, testing, and documentation.
Advanced SQL skills for data modeling, performance optimization, and querying large datasets.
Understanding of data warehousing concepts, dimensional modeling, and star schema design.
Experience with ETL/ELT tools and frameworks, including Apache Beam, Cloud Dataflow, Data Fusion, or Airflow/Composer.
Skills:
Required Skills - DBT (Data Build tool), SQL, Any cloud
Location: Bangalore, Chennai, Gurgaon, Pune, Kolkata, Hyderabad
About Company:
Welcome to Tredence! Since our founding in 2013, we have been dedicated to transforming data into actionable insights, helping over 50 Fortune 500 clients win in their respective industries. With our headquarters in San Jose and a presence in 5 countries, our mission is to be the world's most indispensable analytics partner. At Tredence, we blend deep domain expertise with advanced AI and data science to drive unparalleled business value. We are excited to have you join us on this innovative journey.

Skills Required