Informatica Data Warehouse Engineer (Single Store)

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.