Informatica Data Warehouse Engineer; Single Store

Responsibilities

• Design, develop, and maintain ETL workflows and mappings using Informatica Power Center (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 Dev Ops or CI/CD practices.

• At least 4 years of hands-on experience in data integration and ETL using Informatica Power Center 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 Single Store (MemSQL).

• 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 Single Store 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.