Informatica DBT Engineer - NTT Data

NTT DATA, Inc.; Gurugram District, Bengaluru; Hybrid; INR 1,200,000 - 2,400,000; Full time

Job summary

NTT DATA invites experienced Informatica DBT Engineer candidates to join our team. This role involves translating Informatica sessions and mappings into Python EL scripts and dbt models, with a hybrid work arrangement in Bangalore or Gurgaon.

You will develop Python EL pipelines, land high-volume data using SQLAlchemy, cx_Oracle, pyodbc, and bulk export tools. Design dbt transformation models, write dbt tests and Python unit tests, and orchestrate Airflow DAGs to mirror Informatica workflows.

Qualifications

• Assess Informatica workflows and translate into Python EL scripts and dbt models.
• Develop and maintain Python EL pipelines for high-volume data landing.
• Design dbt models using best practices and incremental strategies.
• Create dbt-native tests and Python unit tests for quality.
• Develop Airflow DAGs to orchestrate Python EL and dbt scripts.
• Contribute to GitLab CI/CD pipelines for dbt and Airflow.

Responsibilities

• Assess complex Informatica workflows including sessions and mappings.
• Land high-volume data into target warehouse using Python EL scripts.
• Design and implement dbt transformation models.
• Develop and run tests to ensure data quality and correctness.
• Create and maintain Airflow DAGs to automate end-to-end pipelines.
• Improve CI/CD for dbt and Airflow deployments.

Skills

Informatica

Python

dbt

Airflow

SQLAlchemy

cx_Oracle

pyodbc

Tools

GitLab CI/CD

Oracle Data Pump

SQL Server BCP

dbt

Airflow

Job description

Dear Aspirants,

Greeting From NTT DATA

Excellent opening for Informatica DBT Engineer.

Experience : 5 to 15 Years

Location : Bangalore or Gurgaon

Work mode: Hybrid

JD for Reference:

• Assess complex Informatica workflows including sessions, mappings, and parameterizations and translate them into equivalent Python EL scripts and dbt transformation models.
• Develop and maintain Python EL pipelines to land high-volume data, including billion-row tables, into the target warehouse using SQLAlchemy, cx_Oracle, pyodbc, and bulk export tools such as Oracle Data Pump and SQL Server BCP.
• Design and develop dbt transformation models based on Informatica mapping logic, incorporating dbt best practices including model layering, macros, incremental strategies, and snapshot patterns.
• Develop dbt-native tests as well as custom Python unit tests to validate transformation correctness and data quality.
• Develop Airflow DAGs to orchestrate Python EL and dbt scripts end-to-end, producing output that is functionally equivalent to the source Informatica workflows.
• Contribute to GitLab CI/CD pipeline for dbt and Airflow code, including lint gates, automated testing, and deployment to shared NAS .

Thanks and Regards,

Omkumaran D

HR TA

NTT DATA