
Informatica Data Warehouse Engineer (Single Store)
JOB_REQUIREMENTS
Employment Type
Not specified
Company Location
Not specified
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.
© 2025 Qureos. All rights reserved.