Informatica DBT Engineer – Python/SQL
Job Description
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.
Are you interested in this position?
Apply by clicking on the “Apply Now” button below!
#GraphicDesignJobsOnline
#WebDesignRemoteJobs
#FreelanceGraphicDesigner
#WorkFromHomeDesignJobs
#OnlineWebDesignWork
#RemoteDesignOpportunities
#HireGraphicDesigners
#DigitalDesignCareers
# Dynamicbrand guru
