Informatica Developer

KPI Partners; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

A leading IT consulting firm is seeking an experienced Informatica PowerCenter Developer in Bengaluru, India. The role involves analyzing Informatica mappings and validating SQL logic to ensure functional correctness. Responsibilities include reviewing transformation logic, collaborating with engineering teams, and maintaining ETL documentation. Ideal candidates should possess strong knowledge of Informatica PowerCenter, SQL, and XML. This is a full-time position.

Qualifications

• Proficient in analyzing Informatica mappings and workflows.
• Experience in validating SQL logic for functional correctness.
• Ability to read and understand complex transformation logic.

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).
• Reconstruct mapping logic from XML exports and documentation.
• Collaborate with engineering teams to ensure end-to-end consistency.
• Support troubleshooting and root-cause analysis.
• Maintain documentation and enforce ETL logic standards.

Skills

Informatica PowerCenter

SQL

XML

Job description

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
• 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

• Informatica PowerCenter
• SQL
• XML

Seniority Level

Mid-Senior level

Employment Type

Full-time

Job Function

Information Technology

Industries

IT Services and IT Consulting and Software Development