We need an experienced Informatica PowerCenter Developer who can analyze Informatica mappings, workflows, and session XMLs, and validate SQL logic for functional correctness. The role focuses heavily on reading/understanding Informatica transformation logic and ensuring that equivalent SQL reflects the same behavior.
Key Responsibilities
- Analyze Informatica mappings, transformations, workflows, and session XMLs
- Validate SQL logic to ensure functional parity with Informatica processes
- Review complex transformation logic (lookups, joins, expressions, filters, aggregations, etc.)
- Reconstruct mapping logic from XML exports and documentation
- Identify logic gaps, inconsistencies, or deviations
- Collaborate with engineering teams to ensure end-to-end consistency
- Support troubleshooting and root-cause analysis related to mapping logic
- Maintain documentation and enforce ETL logic standards.
Key Skills
- Informatice Power Center
- SQL
- XML
