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.
- Prior ETL migration project experience.

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

📌 DBT Migration Developer (Informatica to dbt) (Chennai)
🏢 Trinity Technology Solutions
📍 Chennai