Informatica Data Warehouse Engineer (Single Store)

Advansys; Riyadh; On-site; SAR 150,000 - 200,000; Full time

Job summary

A leading tech company in Riyadh seeks an experienced ETL Developer to design, develop, and maintain workflows using Informatica tools. The ideal candidate will have over 4 years of experience in data integration and warehouse implementation, with strong skills in data quality management and database platforms. Join us to contribute to large-scale enterprise projects and optimize data pipelines.

Qualifications

• At least 4 years of hands-on experience in data integration and ETL using Informatica.
• Experience in the design and implementation of Data Warehouses for enterprise projects.
• Practical knowledge of database systems such as Oracle or SQL Server.

Responsibilities

• Design, develop, and maintain ETL workflows using Informatica.
• Collaborate with stakeholders to translate business requirements into technical solutions.
• Develop and optimize data pipelines for data warehousing.

Skills

Informatica PowerCenter

Data Warehousing

SQL

Data Quality Management

Power BI

Tools

Informatica IICS

Oracle

SQL Server

Snowflake

Job description

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.