- Develop and maintain ETL workflows using Informatica PowerCenter or Informatica Intelligent Cloud Services (IICS/IDMC).
- Build mappings, sessions, workflows, and data integration processes.
- Develop and support data extraction, transformation, and loading (ETL) solutions.
- Troubleshoot ETL jobs, resolve data issues, and support production environments.
- Participate in testing, deployments, and data integration enhancements.
Requirements
- Hands-on experience developing mappings, sessions, and workflows.
- Solid knowledge of SQL and relational databases.
- Basic understanding of ETL concepts, data transformation, and data integration.
- Familiarity with Slowly Changing Dimensions (SCD) and Change Data Capture (CDC) concepts.
- Experience supporting ETL testing, deployments, and production support.