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