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.

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.