Talent.com
Informatica Data Warehouse Engineer (Single Store)

Informatica Data Warehouse Engineer (Single Store)

AdvansysRiyadh, Riyadh Region, Saudi Arabia
2 منذ أيام
الوصف الوظيفي

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.

    • #J-18808-Ljbffr

    إنشاء تنبيه وظيفي لهذا البحث

    Data Engineer • Riyadh, Riyadh Region, Saudi Arabia