:

Role : Informatica DBT Engineer.

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.

Required Skillset :

- Demonstrated expertise in designing and managing end-to-end data pipelines using Informatica PowerCenter or IICS, combined with up-to-date DBT transformation workflows.
- Strong proficiency in SQL and data modeling techniques, with the ability to write complex, performant queries for large-scale datasets.
- Proven experience working within cloud data environments such as Snowflake, AWS Redshift, or Google BigQuery.
- Ability to communicate complex technical concepts effectively to both technical peers and non-technical business stakeholders.
- Strong analytical mindset with a focus on problem-solving and the ability to adapt to evolving project requirements in a fast-paced, hybrid work environment.

📌 NTT Data - Informatica DBT Engineer - Python/SQL (India)
🏢 NTT DATA INFORMATION PROCESSING SERVICES
📍 India