Informatica Data Warehouse Engineer (Single Store)

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

Technical Skills

#J-18808-Ljbffr