Informatica Developer

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