Data Engineer-Data Integration
Summary
Build and maintain data integration solutions, designing ETL/ELT pipelines with Informatica to load and transform data into Snowflake warehouses. The role focuses on data quality, performance tuning of SQL and Snowflake jobs, troubleshooting production issues, and collaborating with stakeholders.
About the role
We are looking for a Data Engineer – Data Integration to support the development and maintenance of data integration solutions using Informatica and Snowflake. The role will focus on building reliable ETL/ELT processes, integrating data from various source systems, ensuring data quality, and optimizing data workflows and warehouse performance.
Key responsibilities
Design, develop, and maintain ETL/ELT processes using Informatica and Snowflake.
Extract, transform, and load data from various source systems into Snowflake data warehouses.
Develop data mappings, workflows, and reusable components following best practices.
Optimize ETL jobs, SQL queries, and Snowflake performance for scalability and efficiency.
Implement data quality, validation, and reconciliation processes.
Troubleshoot and resolve data integration and performance issues.
Collaborate with Business Analysts, Data Engineers, and other stakeholders to understand requirements and deliver solutions.
Support production deployments, monitoring, and incident resolution.
About you
Hands‑on experience with Informatica
Hands‑on experience with Snowflake
Experience in ETL/ELT development and data integration
Strong knowledge of SQL
Knowledge of data mapping, workflows, and data validation
Strong troubleshooting and problem‑solving skills
Experience with Snowflake performance optimization
Experience supporting production deployments, monitoring, and incident resolution
Experience collaborating with business and technical stakeholders