Informatica Developers

Syren Cloud Inc.; Hyderabad; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Syren Cloud Inc. seeks a skilled Migration Lead to drive the CDI-PC to IDMC migration. You will own the assessment, wave planning, conversion decisions and handoff to validation.

You will coordinate asset inventory, sequencing and remediation scope, ensuring smooth execution across teams. The role requires deep Informatica PowerCenter 9.x/10.x expertise, IDMC/IICS proficiency, and strong SQL and shell scripting abilities.

Qualifications

• Expertise in PowerCenter mappings, workflows, and transformations (9.x/10.x).
• Proficiency with IDMC/IICS Mapping Designer and Taskflow Designer.
• Strong SQL for complex reconciliations and stored procedures (PL/SQL or T-SQL).
• Shell scripting to modify CDI-PC command tasks.
• Experience with PC to Cloud Conversion tooling in IDMC.

Responsibilities

• Lead assessment, wave planning, and conversion decisions for CDI-PC to IDMC migration.
• Coordinate asset inventory, sequencing, and remediation scope before wave sizing.
• Publish converted assets and resolve flagged conversion issues prior to validation.

Tools

Informatica PowerCenter 9.x/10.x

Informatica IDMC / IICS

SQL — PL/SQL or T-SQL

Shell scripting

PC to Cloud Conversion utility

UNIX/Linux

Job description

Leads the technical execution of the CDI-PC to IDMC migration. Owns the assessment, wave planning, conversion decisions, and handoff to validation.

Key Responsibilities

Assessment

• Export repository XML using PowerCenter Repository Manager; run or interpret Migration Factory / PC to Cloud Conversion assessment outputs
• Build the asset inventory and dependency sequencing map (mapplets before mappings, always)
• Classify every asset into Simple / Medium / Complex and assign a migration strategy
• Identify manual remediation scope: flag all command tasks, stored procedures, and custom transformations before wave sizing is committed

Conversion

• Execute automated conversion of simple and medium assets using PC2CDI or IDMC's built-in PC to Cloud Conversion utility
• Manually rebuild complex assets — command tasks rewritten as Taskflows, stored procedures evaluated and converted or kept, custom Java transformations rewritten in IDMC native
• Recreate all connections, parameter sets, and schedules in IDMC per wave as a dedicated parallel workstream — these are not part of the automated stream and are owned entirely by this role
• Review and publish converted assets in IDMC Mapping Designer and Taskflow Designer; resolve all flagged conversion issues before passing to validation

Validation and Cutover

• Design SQL reconciliation scripts for mapping-level and business-level validation where CDV is unavailable
• Interpret CDV or manual validation outputs; triage and resolve discrepancies
• Prepare the cutover runbook, define rollback triggers, and execute the mandatory dry run

Required Skills

Must have (will not function without these):

• Informatica PowerCenter 9.x / 10.x — Mapping Designer, Workflow Manager, Workflow Monitor, Repository Manager, all standard and non-standard transformations
• Informatica IDMC / IICS — Mapping Designer, Taskflow Designer, Mapping Tasks, Connections, Parameters, Secure Agent, Monitor
• SQL — complex reconciliation queries, stored procedure reading, PL/SQL or T-SQL, push-down optimisation techniques Informatica Knowledge
• Shell scripting — reading and rewriting existing CDI-PC command task scripts
• PC to Cloud Conversion utility — running conversion projects within IDMC from exported XML

Strong to have:

• PC2CDI Modernization Service or Migration Factory experience
• UNIX/Linux — file system navigation, job scheduling, log reading

Good to have:

• Python for validation scripting
• CLAIRE GPT — not essential, accelerates redesign work