Informatica Data Warehouse Engineer (Single Store)
Advansys ME
Date: 2 weeks ago
City: Riyadh
Contract type: Full time
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.
Requirements
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.
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.
Requirements
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.
How to apply
To apply for this job you need to authorize on our website. If you don't have an account yet, please register.
Post a resumeSimilar jobs
28 Management SC SubContracts
Bechtel Corporation,
Riyadh
1 day ago
Requisition ID: 289978 Relocation Authorized: National - Single Telework Type: Full-Time Office/Project Work Location: Riyadh Extraordinary Teams Building Inspiring ProjectsSince 1898, we have helped customers complete more than 25,000 projects in 160 countries on all seven continents that have created jobs, grown economies, improved the resiliency of the world's infrastructure, increased access to energy, resources, and vital services, and made...
Sustainability Manager
AtkinsRéalis,
Riyadh
1 day ago
OverviewThe Sustainability Manager will lead and oversee all sustainability-related activities across the construction Sites, ensuring full compliance with Employer's sustainability requirements and industry best practices. The role focuses on integrating sustainable construction methods, reducing environmental impact, managing certification requirements, and ensuring that project works support long-term environmental performance goals.Your roleEnsuring all staff involved in sustainability management are adequately trained.Leading the...
Senior Planning & Scheduling Engineer
WSP in the Middle East,
Riyadh
1 day ago
Job DescriptionThe Senior Planning & Scheduling Engineer will lead planning and scheduling activities, providing technical oversight and reporting on project progress, milestones, and critical paths. The role requires expertise in scheduling large-scale infrastructure projects, strong analytical skills, and experience in GCC countries.The project involves extensive land development, including civil infrastructure, utilities, and urban facilities. The Senior Planning & Scheduling Engineer...
