Informatica Data Warehouse Engineer (Single Store)

Advansys; Saudi Arabia; On-site; SAR 90,000 - 120,000; Full time

Job summary

A leading data solutions provider in Saudi Arabia is seeking a Data Integration Specialist to design and develop ETL workflows and manage data pipelines. The ideal candidate will bring at least 4 years of experience in ETL using Informatica PowerCenter, with a strong background in data warehouse architecture and data quality management. This role emphasizes collaboration with business analysts to deliver effective technical solutions.

Qualifications

• At least 4 years of hands-on experience in data integration and ETL using Informatica tools.
• Experience in designing and implementing Data Warehouses for enterprise projects.
• Proficiency in Query performance optimization and managing large data volumes.

Responsibilities

• Design and maintain ETL workflows using Informatica.
• Collaborate with stakeholders to gather and translate business requirements.
• Perform data quality checks and error handling.

Skills

Data integration using Informatica PowerCenter

Data modeling

ETL process design

Data Quality Management

BI/Analytics fundamentals

Tools

Informatica PowerCenter

Oracle

SQL Server

Snowflake

Power BI

Job description

Key Responsibilities

• Design, develop, and maintain ETL workflows and mappings using Informatica PowerCenter (or IICS).
• Collaborate with business analysts, data architects, and stakeholders to gather and translate business requirements into technical solutions.
• Develop and optimize data pipelines to extract, transform, and load data from multiple sources into the data warehouse.
• Perform data quality checks, error handling, and performance tuning to ensure reliable and efficient data processing.
• Maintain and enhance existing data warehouse architectures, including star/snowflake schemas, fact and dimension tables.
• Implement and monitor job scheduling and workflow dependencies (e.g., using Control‑M, Autosys, or Informatica Scheduler).
• Support data governance, metadata management, and data lineage initiatives.
• Troubleshoot and resolve ETL and data‑related issues in production and development environments.
• Participate in code reviews, unit testing, and deployment activities following DevOps or CI/CD practices.

Qualifications

• At least 4 years of hands‑on experience in data integration and ETL using Informatica PowerCenter or Informatica Intelligent Cloud Services (IICS).
• Proven experience in the design and implementation of Data Warehouses for large‑scale enterprise projects.
• Knowledge and practical experience with database systems such as Oracle, SQL Server, Snowflake, or equivalent platforms like SingleStore (MemSQL).
• Technical skills: proficiency in designing and implementing ETL/ELT processes using Informatica tools.
• Experience in data modeling, including the design and construction of Star Schema and Snowflake Schema models.
• Ability to optimize query performance and manage large data volumes in SingleStore environments.
• Experience in Data Quality Management, implementing data validation and auditing mechanisms.
• Familiarity with BI/Analytics fundamentals and connecting data warehouses to reporting tools such as Power BI or Tableau.