Data Engineer-Data Integration
Summary
Data Engineer building and maintaining ETL/ELT data integration solutions using Informatica and Snowflake, optimizing warehouse performance and ensuring data quality.
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