DBT Migration Developer (Informatica to dbt)

Trinity Technology Solutions LLC

Chennai

On-site

INR 800,000 - 1,200,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Trinity Technology Solutions LLC is seeking a DBT Migration Developer to migrate client ETL workloads from Informatica PowerCenter/IICS to dbt on a cloud data warehouse. You will analyze mappings and rebuild logic as modular dbt models.

Join a performance-minded team to optimize SQL, manage dbt projects with Git and CI/CD, and support go-live activities alongside architects, analysts and QA. Bachelor's degree in CS/IT/Engineering preferred.

Qualifications

  • Hands-on dbt experience (Core or Cloud) in production.
  • Strong Informatica PowerCenter / IICS knowledge.
  • Expert SQL and data warehousing concepts (dimensional modelling, SCDs).
  • Experience with Snowflake, Databricks, BigQuery or Redshift.

Responsibilities

  • Analyse Informatica mappings and workflows and document the transformation logic.
  • Rebuild that logic as modular, tested dbt models (incremental models, snapshots, macros).
  • Reconcile legacy and dbt outputs to ensure data accuracy.
  • Optimise SQL performance and maintain dbt projects through Git and CI/CD.
  • Support testing, cutover and go-live alongside architects, analysts and QA.

Skills

dbt (Core/Cloud)
Informatica PowerCenter / IICS
SQL
Data warehousing concepts

Education

Bachelor's degree (CS/IT/Engineering)

Tools

Snowflake
Databricks
BigQuery
Redshift
Git
CI/CD

Job description

We are hiring a DBT Migration Developer to migrate our client's ETL workloads from Informatica (PowerCenter / IICS) to dbt on a cloud data warehouse.

Key responsibilities
  • Analyse Informatica mappings and workflows and document the transformation logic.
  • Rebuild that logic as modular, tested dbt models (incremental models, snapshots, macros).
  • Reconcile legacy and dbt outputs to ensure data accuracy.
  • Optimise SQL performance and maintain dbt projects through Git and CI/CD.
  • Support testing, cutover and go-live alongside architects, analysts and QA.
Required skills
  • Hands-on dbt experience (Core or Cloud) in production.
  • Strong Informatica PowerCenter / IICS knowledge.
  • Expert SQL and data warehousing concepts (dimensional modelling, SCDs).
  • Experience with Snowflake, Databricks, BigQuery or Redshift.
Good to have
  • dbt or Snowflake certification, Python, and Airflow or similar orchestration tools.
Education

Bachelor's degree in Computer Science, IT, Engineering or a related field.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Migration Engineer (Informatica / dbt)
Data Migration Engineer (Informatica / dbt)

Predoole Analytics Pvt. Ltd. • Mumbai

On-site
INR 1,200,000 - 1,800,000
DBT/Snowflake Engineer
DBT/Snowflake Engineer

NTT DATA, Inc. • Bengaluru

On-site
INR 4,000,000 - 7,000,000
Data Migration Engineer (Informatica / DBT)
Data Migration Engineer (Informatica / DBT)

Predoole Analytics • Mumbai, Pune District

On-site
INR 1,200,000 - 1,800,000
Data Engineer DBT
Data Engineer DBT

Multiverse Solutions • Dadri

On-site
INR 900,000 - 1,300,000
Sr Tech Data Validation & DBT Engineer
Sr Tech Data Validation & DBT Engineer

NTT DATA, Inc. • Bengaluru

On-site
INR 1,200,000 - 2,400,000
DBT Lead
DBT Lead

Coforge Limited • Dadri

On-site
INR 700,000 - 1,200,000
Dbt Developer (7-9 Years)
Dbt Developer (7-9 Years)

Talent Zone Consultant • Bengaluru

On-site
INR 1,800,000 - 2,800,000
Data Engineer
Data Engineer

atsMantra® • Hyderabad

On-site
INR 1,500,000 - 2,600,000
DBT / Analytical Engineer
DBT / Analytical Engineer

InApp Inc. • India

Hybrid
INR 1,800,000 - 3,200,000
Senior DBT Engineer
Senior DBT Engineer

Saama Technologies • Pune District, Chennai

Hybrid
INR 3,000,000 - 5,000,000