Data Engineer-Data Integration

IGO TECHONOLOGIES; Philippines; On-site; PHP 600,000 - 1,200,000; Full time

Job summary

IGO TECHONOLOGIES is seeking a Data Engineer – Data Integration to design and maintain robust data pipelines. You will work with Informatica and Snowflake to deliver reliable ETL/ELT solutions, integrate data from multiple sources, and ensure data quality across the data warehouse.

The role collaborates with Business Analysts and Data Engineers to translate requirements into scalable workflows, optimize SQL and Snowflake performance, and support production deployments and incident resolution in

Qualifications

• Hands-on experience with Informatica and Snowflake.
• Strong SQL and data transformation skills.
• Proven ability to design and maintain ETL/ELT pipelines.

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.

Skills

SQL

ETL/ELT development

Data integration

Data quality

Troubleshooting

Performance optimization

ETL/ELT

Tools

Informatica

Snowflake

Job description

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