Infomatica Engineer

Analyze existing Informatica PowerCenter/Cloud mappings, workflows, sessions, and parameters used in current Yellowbricks/Snowflake environments. Document business logic, transformation rules, data flows, dependencies, and schedules for each mapping/workflow. Work closely with dbt and Snowflake developers to explain existing logic and assist in re-implementing it in the target stack. Provide impact analysis for migration waves (which jobs, tables, and reports are impacted). Support code clean-up, rationalization, and retirement of redundant or obsolete mappings. Implement bug fixes or minor enhancements in Informatica where needed during the transition period. Assist with parallel runs and reconciliation between Informatica outputs and dbt outputs on Snowflake. Maintain Informatica environments (Dev/Test) from a code/configuration perspective in coordination with platform/admin teams. Participate in knowledge transfer sessions with onshore SMEs and downstream teams. 4-7 years of hands-on experience with Informatica PowerCenter and/or Informatica Cloud. Strong ability to read, understand, and document complex mappings and workflows. Solid understanding of ETL concepts, data warehousing, and dimensional modeling. Exposure to Snowflake or other cloud DWs is a plus. Experience in migration projects (Informatica to another ETL/ELT technology, or DW modernization) is highly desirable. Familiarity with job scheduling tools (Control-M, Autosys, etc.) is an advantage.